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

Xbase++
LOCAL nSuccess
LOCAL oVault
LOCAL oEntry
LOCAL oTokens
LOCAL nLoaded
LOCAL oHttp
LOCAL oResp
LOCAL oIds
LOCAL oUrl
LOCAL i
LOCAL oReport
LOCAL oRow
LOCAL cId

nSuccess := 0

//  Assumes Chilkat is unlocked. See Global Unlock Sample.
oVault := CreateObject("Chilkat.Secrets")
oVault:Location := "local_manager"
oVault:AutoSplit := 1
oEntry := CreateObject("Chilkat.JsonObject")
oEntry:UpdateString("appName", "ConstantContactV3")
oEntry:UpdateString("service", "OAuth2")
oEntry:UpdateString("username", "my-account")
oTokens := CreateObject("Chilkat.JsonObject")
nLoaded := oVault:GetSecretJson(oEntry, oTokens)
IF (nLoaded != 1)
    ? "Run the desktop authorization example using this account and store."
    oVault:destroy()
    oEntry:destroy()
    oTokens:destroy()
    RETURN
ENDIF

IF (oTokens:JsonTypeOf("access_token") != 1)
    ? "The saved authorization has no access token."
    oVault:destroy()
    oEntry:destroy()
    oTokens:destroy()
    RETURN
ENDIF

oHttp := CreateObject("Chilkat.Http")
oHttp:RequireSslCertVerify := 1
oHttp:AuthToken := oTokens:StringOf("access_token")
oResp := CreateObject("Chilkat.HttpResponse")

oIds := CreateObject("Chilkat.JsonArray")
oIds:AddStringAt(-1, "FIRST_SENT_ACTIVITY_ID")
oIds:AddStringAt(-1, "SECOND_SENT_ACTIVITY_ID")
IF ((oIds:Size < 1) .OR. (oIds:Size > 10))
    ? "Choose one to ten sent activity IDs."
    oVault:destroy()
    oEntry:destroy()
    oTokens:destroy()
    oHttp:destroy()
    oResp:destroy()
    oIds:destroy()
    RETURN
ENDIF

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

    oUrl:Append(oIds:StringAt(i))
    i := i + 1
ENDDO
nSuccess := oHttp:HttpNoBody("GET", oUrl:GetAsString(), oResp)
IF ((nSuccess != 1) .AND. (oResp:StatusCode <= 0))
    ? "Read statistics: HTTP request failed."
    oVault:destroy()
    oEntry:destroy()
    oTokens:destroy()
    oHttp:destroy()
    oResp:destroy()
    oIds:destroy()
    oUrl:destroy()
    RETURN
ENDIF

IF ((nSuccess != 1) .OR. ((oResp:StatusCode < 200) .OR. (oResp:StatusCode >= 300)))
    ? "Read statistics: HTTP " + Str(oResp:StatusCode) + " " + oResp:BodyStr
    oVault:destroy()
    oEntry:destroy()
    oTokens:destroy()
    oHttp:destroy()
    oResp:destroy()
    oIds:destroy()
    oUrl:destroy()
    RETURN
ENDIF

oReport := CreateObject("Chilkat.JsonObject")
nSuccess := oReport:Load(oResp:BodyStr)
IF (nSuccess != 1)
    ? "Expected a JSON object in the response."
    oVault:destroy()
    oEntry:destroy()
    oTokens:destroy()
    oHttp:destroy()
    oResp:destroy()
    oIds:destroy()
    oUrl:destroy()
    oReport:destroy()
    RETURN
ENDIF

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

    i := i + 1
ENDDO

oVault:destroy()
oEntry:destroy()
oTokens:destroy()
oHttp:destroy()
oResp:destroy()
oIds:destroy()
oUrl:destroy()
oReport:destroy()
oRow:destroy()