Sample code for 30+ languages & platforms
VB.NET Requires Chilkat v11.0.0+

Constant Contact V3: Compare results for sent email activities

See more Constant Contact Examples

Compare one to ten sent primary_email or resend activities with status DONE. Supply activity IDs from your sent newsletters. Campaign IDs identify a different resource. This report requires campaign_data and permission to view campaign metrics.

Each row shows sends, unique opens, unique clicks, bounces and the last metrics refresh. The code matches results by activity ID, keeps the input order, and prints any partial-success errors alongside the available results. A missing result is reported separately from a measured zero.

Authorize the application using the same account and credential store.

Constant Contact developer guide

Chilkat VB.NET Downloads

VB.NET
Dim success As Boolean = False

'  Assumes Chilkat is unlocked. See Global Unlock Sample.
Dim vault As New Chilkat.Secrets
vault.Location = "local_manager"
vault.AutoSplit = True
Dim entry As New Chilkat.JsonObject
entry.UpdateString("appName","ConstantContactV3")
entry.UpdateString("service","OAuth2")
entry.UpdateString("username","my-account")
Dim tokens As New Chilkat.JsonObject
Dim loaded As Boolean = vault.GetSecretJson(entry,tokens)
If (loaded <> True) Then
    Debug.WriteLine("Run the desktop authorization example using this account and store.")
    Exit Sub
End If

If (tokens.JsonTypeOf("access_token") <> 1) Then
    Debug.WriteLine("The saved authorization has no access token.")
    Exit Sub
End If

Dim http As New Chilkat.Http
http.RequireSslCertVerify = True
http.AuthToken = tokens.StringOf("access_token")
Dim resp As New Chilkat.HttpResponse

Dim ids As New Chilkat.JsonArray
ids.AddStringAt(-1,"FIRST_SENT_ACTIVITY_ID")
ids.AddStringAt(-1,"SECOND_SENT_ACTIVITY_ID")
If ((ids.Size < 1) Or (ids.Size > 10)) Then
    Debug.WriteLine("Choose one to ten sent activity IDs.")
    Exit Sub
End If

Dim url As New Chilkat.StringBuilder
url.Append("https://api.cc.email/v3/reports/stats/email_campaign_activities/")
Dim i As Integer = 0
While (i < ids.Size)
    If (i > 0) Then
        url.Append(",")
    End If

    url.Append(ids.StringAt(i))
    i = i + 1
End While
success = http.HttpNoBody("GET",url.GetAsString(),resp)
If ((success <> True) And (resp.StatusCode <= 0)) Then
    Debug.WriteLine("Read statistics: HTTP request failed.")
    Exit Sub
End If

If ((success <> True) Or ((resp.StatusCode < 200) Or (resp.StatusCode >= 300))) Then
    Debug.WriteLine("Read statistics: HTTP " & resp.StatusCode & " " & resp.BodyStr)
    Exit Sub
End If

Dim report As New Chilkat.JsonObject
success = report.Load(resp.BodyStr)
If (success <> True) Then
    Debug.WriteLine("Expected a JSON object in the response.")
    Exit Sub
End If

i = 0
While (i < report.SizeOfArray("errors"))
    report.I = i
    Debug.WriteLine(report.StringOf("errors[i].error_key") & ": " & report.StringOf("errors[i].error_message"))
    i = i + 1
End While
Debug.WriteLine("Activity ID | Sends | Unique opens | Unique clicks | Bounces | Last refresh")
Dim row As New Chilkat.JsonObject
i = 0
While (i < ids.Size)
    Dim id As String = ids.StringAt(i)
    success = report.FindRecord2("results","campaign_activity_id",id,True,row)
    If (success = True) Then
        '  StringOf preserves a reported zero and leaves an unavailable individual metric blank.
        Debug.WriteLine(id & " | " & row.StringOf("stats.em_sends") & " | " & row.StringOf("stats.em_opens") & " | " & row.StringOf("stats.em_clicks") & " | " & row.StringOf("stats.em_bounces") _
             & " | " & row.StringOf("last_refresh_time"))
    Else
        Debug.WriteLine(id & " | No statistics returned")
    End If

    i = i + 1
End While