Sample code for 30+ languages & platforms
Visual FoxPro 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 Visual FoxPro Downloads

Visual FoxPro
LOCAL lnSuccess
LOCAL loVault
LOCAL loEntry
LOCAL loTokens
LOCAL lnLoaded
LOCAL loHttp
LOCAL loResp
LOCAL loIds
LOCAL loUrl
LOCAL i
LOCAL loReport
LOCAL loRow
LOCAL lcId

lnSuccess = 0

*  Assumes Chilkat is unlocked. See Global Unlock Sample.
loVault = CreateObject('Chilkat.Secrets')
loVault.Location = "local_manager"
loVault.AutoSplit = 1
loEntry = CreateObject('Chilkat.JsonObject')
loEntry.UpdateString("appName","ConstantContactV3")
loEntry.UpdateString("service","OAuth2")
loEntry.UpdateString("username","my-account")
loTokens = CreateObject('Chilkat.JsonObject')
lnLoaded = loVault.GetSecretJson(loEntry,loTokens)
IF (lnLoaded <> 1) THEN
    ? "Run the desktop authorization example using this account and store."
    RELEASE loVault
    RELEASE loEntry
    RELEASE loTokens
    CANCEL
ENDIF

IF (loTokens.JsonTypeOf("access_token") <> 1) THEN
    ? "The saved authorization has no access token."
    RELEASE loVault
    RELEASE loEntry
    RELEASE loTokens
    CANCEL
ENDIF

loHttp = CreateObject('Chilkat.Http')
loHttp.RequireSslCertVerify = 1
loHttp.AuthToken = loTokens.StringOf("access_token")
loResp = CreateObject('Chilkat.HttpResponse')

loIds = CreateObject('Chilkat.JsonArray')
loIds.AddStringAt(-1,"FIRST_SENT_ACTIVITY_ID")
loIds.AddStringAt(-1,"SECOND_SENT_ACTIVITY_ID")
IF ((loIds.Size < 1) OR (loIds.Size > 10)) THEN
    ? "Choose one to ten sent activity IDs."
    RELEASE loVault
    RELEASE loEntry
    RELEASE loTokens
    RELEASE loHttp
    RELEASE loResp
    RELEASE loIds
    CANCEL
ENDIF

loUrl = CreateObject('Chilkat.StringBuilder')
loUrl.Append("https://api.cc.email/v3/reports/stats/email_campaign_activities/")
i = 0
DO WHILE (i < loIds.Size)
    IF (i > 0) THEN
        loUrl.Append(",")
    ENDIF

    loUrl.Append(loIds.StringAt(i))
    i = i + 1
ENDDO
lnSuccess = loHttp.HttpNoBody("GET",loUrl.GetAsString(),loResp)
IF ((lnSuccess <> 1) AND (loResp.StatusCode <= 0)) THEN
    ? "Read statistics: HTTP request failed."
    RELEASE loVault
    RELEASE loEntry
    RELEASE loTokens
    RELEASE loHttp
    RELEASE loResp
    RELEASE loIds
    RELEASE loUrl
    CANCEL
ENDIF

IF ((lnSuccess <> 1) OR ((loResp.StatusCode < 200) OR (loResp.StatusCode >= 300))) THEN
    ? "Read statistics: HTTP " + STR(loResp.StatusCode) + " " + loResp.BodyStr
    RELEASE loVault
    RELEASE loEntry
    RELEASE loTokens
    RELEASE loHttp
    RELEASE loResp
    RELEASE loIds
    RELEASE loUrl
    CANCEL
ENDIF

loReport = CreateObject('Chilkat.JsonObject')
lnSuccess = loReport.Load(loResp.BodyStr)
IF (lnSuccess <> 1) THEN
    ? "Expected a JSON object in the response."
    RELEASE loVault
    RELEASE loEntry
    RELEASE loTokens
    RELEASE loHttp
    RELEASE loResp
    RELEASE loIds
    RELEASE loUrl
    RELEASE loReport
    CANCEL
ENDIF

i = 0
DO WHILE (i < loReport.SizeOfArray("errors"))
    loReport.I = i
    ? loReport.StringOf("errors[i].error_key") + ": " + loReport.StringOf("errors[i].error_message")
    i = i + 1
ENDDO
? "Activity ID | Sends | Unique opens | Unique clicks | Bounces | Last refresh"
loRow = CreateObject('Chilkat.JsonObject')
i = 0
DO WHILE (i < loIds.Size)
    lcId = loIds.StringAt(i)
    lnSuccess = loReport.FindRecord2("results","campaign_activity_id",lcId,1,loRow)
    IF (lnSuccess = 1) THEN
        *  StringOf preserves a reported zero and leaves an unavailable individual metric blank.
        ? lcId + " | " + loRow.StringOf("stats.em_sends") + " | " + loRow.StringOf("stats.em_opens") + " | " + loRow.StringOf("stats.em_clicks") + " | " + loRow.StringOf("stats.em_bounces") + " | " + loRow.StringOf("last_refresh_time")
    ELSE
        ? lcId + " | No statistics returned"
    ENDIF

    i = i + 1
ENDDO

RELEASE loVault
RELEASE loEntry
RELEASE loTokens
RELEASE loHttp
RELEASE loResp
RELEASE loIds
RELEASE loUrl
RELEASE loReport
RELEASE loRow