DataFlex Requires Chilkat v11.0.0+
DataFlex
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 DataFlex Downloads
Use ChilkatAx-win32.pkg
Procedure Test
Boolean iSuccess
Handle hoVault
Variant vEntry
Handle hoEntry
Variant vTokens
Handle hoTokens
Boolean iLoaded
Handle hoHttp
Variant vResp
Handle hoResp
Handle hoIds
Handle hoUrl
Integer i
Handle hoReport
Variant vRow
Handle hoRow
String sId
String sTemp1
String sTemp2
String sTemp3
String sTemp4
String sTemp5
Integer iTemp1
Integer iTemp2
Move False To iSuccess
// Assumes Chilkat is unlocked. See Global Unlock Sample.
Get Create (RefClass(cComChilkatSecrets)) To hoVault
If (Not(IsComObjectCreated(hoVault))) Begin
Send CreateComObject of hoVault
End
Set ComLocation Of hoVault To "local_manager"
Set ComAutoSplit Of hoVault To True
Get Create (RefClass(cComChilkatJsonObject)) To hoEntry
If (Not(IsComObjectCreated(hoEntry))) Begin
Send CreateComObject of hoEntry
End
Get ComUpdateString Of hoEntry "appName" "ConstantContactV3" To iSuccess
Get ComUpdateString Of hoEntry "service" "OAuth2" To iSuccess
Get ComUpdateString Of hoEntry "username" "my-account" To iSuccess
Get Create (RefClass(cComChilkatJsonObject)) To hoTokens
If (Not(IsComObjectCreated(hoTokens))) Begin
Send CreateComObject of hoTokens
End
Get pvComObject of hoEntry to vEntry
Get pvComObject of hoTokens to vTokens
Get ComGetSecretJson Of hoVault vEntry vTokens To iLoaded
If (iLoaded <> True) Begin
Showln "Run the desktop authorization example using this account and store."
Procedure_Return
End
Get ComJsonTypeOf Of hoTokens "access_token" To iTemp1
If (iTemp1 <> 1) Begin
Showln "The saved authorization has no access token."
Procedure_Return
End
Get Create (RefClass(cComChilkatHttp)) To hoHttp
If (Not(IsComObjectCreated(hoHttp))) Begin
Send CreateComObject of hoHttp
End
Set ComRequireSslCertVerify Of hoHttp To True
Get ComStringOf Of hoTokens "access_token" To sTemp1
Set ComAuthToken Of hoHttp To sTemp1
Get Create (RefClass(cComChilkatHttpResponse)) To hoResp
If (Not(IsComObjectCreated(hoResp))) Begin
Send CreateComObject of hoResp
End
Get Create (RefClass(cComChilkatJsonArray)) To hoIds
If (Not(IsComObjectCreated(hoIds))) Begin
Send CreateComObject of hoIds
End
Get ComAddStringAt Of hoIds -1 "FIRST_SENT_ACTIVITY_ID" To iSuccess
Get ComAddStringAt Of hoIds -1 "SECOND_SENT_ACTIVITY_ID" To iSuccess
Get ComSize Of hoIds To iTemp1
Get ComSize Of hoIds To iTemp2
If ((iTemp1 < 1) Or (iTemp2 > 10)) Begin
Showln "Choose one to ten sent activity IDs."
Procedure_Return
End
Get Create (RefClass(cComChilkatStringBuilder)) To hoUrl
If (Not(IsComObjectCreated(hoUrl))) Begin
Send CreateComObject of hoUrl
End
Get ComAppend Of hoUrl "https://api.cc.email/v3/reports/stats/email_campaign_activities/" To iSuccess
Move 0 To i
While (i < (ComSize(hoIds)))
If (i > 0) Begin
Get ComAppend Of hoUrl "," To iSuccess
End
Get ComStringAt Of hoIds i To sTemp1
Get ComAppend Of hoUrl sTemp1 To iSuccess
Move (i + 1) To i
Loop
Get ComGetAsString Of hoUrl To sTemp1
Get pvComObject of hoResp to vResp
Get ComHttpNoBody Of hoHttp "GET" sTemp1 vResp To iSuccess
Get ComStatusCode Of hoResp To iTemp1
If ((iSuccess <> True) And (iTemp1 <= 0)) Begin
Showln "Read statistics: HTTP request failed."
Procedure_Return
End
Get ComStatusCode Of hoResp To iTemp1
Get ComStatusCode Of hoResp To iTemp2
If ((iSuccess <> True) Or ((iTemp1 < 200) Or (iTemp2 >= 300))) Begin
Get ComStatusCode Of hoResp To iTemp1
Get ComBodyStr Of hoResp To sTemp1
Showln "Read statistics: HTTP " iTemp1 " " sTemp1
Procedure_Return
End
Get Create (RefClass(cComChilkatJsonObject)) To hoReport
If (Not(IsComObjectCreated(hoReport))) Begin
Send CreateComObject of hoReport
End
Get ComBodyStr Of hoResp To sTemp1
Get ComLoad Of hoReport sTemp1 To iSuccess
If (iSuccess <> True) Begin
Showln "Expected a JSON object in the response."
Procedure_Return
End
Move 0 To i
While (i < (ComSizeOfArray(hoReport, "errors")))
Set ComI Of hoReport To i
Get ComStringOf Of hoReport "errors[i].error_key" To sTemp1
Get ComStringOf Of hoReport "errors[i].error_message" To sTemp2
Showln sTemp1 ": " sTemp2
Move (i + 1) To i
Loop
Showln "Activity ID | Sends | Unique opens | Unique clicks | Bounces | Last refresh"
Get Create (RefClass(cComChilkatJsonObject)) To hoRow
If (Not(IsComObjectCreated(hoRow))) Begin
Send CreateComObject of hoRow
End
Move 0 To i
While (i < (ComSize(hoIds)))
Get ComStringAt Of hoIds i To sId
Get pvComObject of hoRow to vRow
Get ComFindRecord2 Of hoReport "results" "campaign_activity_id" sId True vRow To iSuccess
If (iSuccess = True) Begin
// StringOf preserves a reported zero and leaves an unavailable individual metric blank.
Get ComStringOf Of hoRow "stats.em_sends" To sTemp1
Get ComStringOf Of hoRow "stats.em_opens" To sTemp2
Get ComStringOf Of hoRow "stats.em_clicks" To sTemp3
Get ComStringOf Of hoRow "stats.em_bounces" To sTemp4
Get ComStringOf Of hoRow "last_refresh_time" To sTemp5
Showln sId " | " sTemp1 " | " sTemp2 " | " sTemp3 " | " sTemp4 " | " sTemp5
End
Else Begin
Showln sId " | No statistics returned"
End
Move (i + 1) To i
Loop
End_Procedure