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

DataFlex
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