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

Constant Contact V3: Find a campaign and its primary email activity

See more Constant Contact Examples

Enter the unique campaign name from the account. Follow the campaign collection’s cursor until the name matches, then fetch that campaign’s details. Select the activity whose role is primary_email. A permalink or resend can appear first.

The example writes the two IDs to newsletter-selection.json, the same file produced by the draft example. Run this lookup when selecting an existing newsletter for review or scheduling.

Authorize the application using the same account and credential store.

Constant Contact developer guide

Chilkat PowerBuilder Downloads

PowerBuilder
integer li_rc
long li_Success
oleobject loo_Vault
oleobject loo_Entry
oleobject loo_Tokens
long li_Loaded
oleobject loo_Http
oleobject loo_Resp
string ls_CampaignName
string ls_CampaignId
oleobject loo_Url
oleobject loo_Page
long li_Count
long i
oleobject loo_Campaign
oleobject loo_Primary
string ls_SelectedCampaign
string ls_SelectedActivity
oleobject loo_Selection

li_Success = 0

//  Assumes Chilkat is unlocked. See Global Unlock Sample.
loo_Vault = create oleobject
li_rc = loo_Vault.ConnectToNewObject("Chilkat.Secrets")
if li_rc < 0 then
    destroy loo_Vault
    MessageBox("Error","Connecting to COM object failed")
    return
end if
loo_Vault.Location = "local_manager"
loo_Vault.AutoSplit = 1
loo_Entry = create oleobject
li_rc = loo_Entry.ConnectToNewObject("Chilkat.JsonObject")

loo_Entry.UpdateString("appName","ConstantContactV3")
loo_Entry.UpdateString("service","OAuth2")
loo_Entry.UpdateString("username","my-account")
loo_Tokens = create oleobject
li_rc = loo_Tokens.ConnectToNewObject("Chilkat.JsonObject")

li_Loaded = loo_Vault.GetSecretJson(loo_Entry,loo_Tokens)
if li_Loaded <> 1 then
    Write-Debug "Run the desktop authorization example using this account and store."
    destroy loo_Vault
    destroy loo_Entry
    destroy loo_Tokens
    return
end if

if loo_Tokens.JsonTypeOf("access_token") <> 1 then
    Write-Debug "The saved authorization has no access token."
    destroy loo_Vault
    destroy loo_Entry
    destroy loo_Tokens
    return
end if

loo_Http = create oleobject
li_rc = loo_Http.ConnectToNewObject("Chilkat.Http")

loo_Http.RequireSslCertVerify = 1
loo_Http.AuthToken = loo_Tokens.StringOf("access_token")
loo_Resp = create oleobject
li_rc = loo_Resp.ConnectToNewObject("Chilkat.HttpResponse")

ls_CampaignName = "Workshop newsletter"
ls_CampaignId = ""
loo_Url = create oleobject
li_rc = loo_Url.ConnectToNewObject("Chilkat.StringBuilder")

loo_Url.Append("https://api.cc.email/v3/emails?limit=50")
loo_Page = create oleobject
li_rc = loo_Page.ConnectToNewObject("Chilkat.JsonObject")

do while ((loo_Url.Length > 0) AND (ls_CampaignId = ""))
    li_Success = loo_Http.HttpNoBody("GET",loo_Url.GetAsString(),loo_Resp)
    if (li_Success <> 1) AND (loo_Resp.StatusCode <= 0) then
        Write-Debug "Read campaigns: HTTP request failed."
        destroy loo_Vault
        destroy loo_Entry
        destroy loo_Tokens
        destroy loo_Http
        destroy loo_Resp
        destroy loo_Url
        destroy loo_Page
        return
    end if

    if (li_Success <> 1) OR (loo_Resp.StatusCode <> 200) then
        Write-Debug "Read campaigns: HTTP " + string(loo_Resp.StatusCode) + " " + loo_Resp.BodyStr
        destroy loo_Vault
        destroy loo_Entry
        destroy loo_Tokens
        destroy loo_Http
        destroy loo_Resp
        destroy loo_Url
        destroy loo_Page
        return
    end if

    li_Success = loo_Page.Load(loo_Resp.BodyStr)
    li_Count = loo_Page.SizeOfArray("campaigns")
    if (li_Success <> 1) OR (li_Count < 0) then
        Write-Debug "Expected a page of campaigns."
        destroy loo_Vault
        destroy loo_Entry
        destroy loo_Tokens
        destroy loo_Http
        destroy loo_Resp
        destroy loo_Url
        destroy loo_Page
        return
    end if

    i = 0
    do while ((i < li_Count) AND (ls_CampaignId = ""))
        loo_Page.I = i
        if loo_Page.StringOfEquals("campaigns[i].name",ls_CampaignName,1) = 1 then
            ls_CampaignId = loo_Page.StringOf("campaigns[i].campaign_id")
        end if

        i = i + 1
    loop
    loo_Url.Clear()
    if (ls_CampaignId = "") AND (loo_Page.JsonTypeOf("_links.next.href") = 1) then
        loo_Url.Append(loo_Page.StringOf("_links.next.href"))
        if loo_Url.StartsWith("/v3/emails?",1) <> 1 then
            Write-Debug "Unexpected campaign pagination link."
            destroy loo_Vault
            destroy loo_Entry
            destroy loo_Tokens
            destroy loo_Http
            destroy loo_Resp
            destroy loo_Url
            destroy loo_Page
            return
        end if

        loo_Url.Prepend("https://api.cc.email")
    end if

loop
if ls_CampaignId = "" then
    Write-Debug "No campaign named " + ls_CampaignName
    destroy loo_Vault
    destroy loo_Entry
    destroy loo_Tokens
    destroy loo_Http
    destroy loo_Resp
    destroy loo_Url
    destroy loo_Page
    return
end if

loo_Http.SetUrlVar("campaign",ls_CampaignId)
li_Success = loo_Http.HttpNoBody("GET","https://api.cc.email/v3/emails/{$campaign}",loo_Resp)
if (li_Success <> 1) AND (loo_Resp.StatusCode <= 0) then
    Write-Debug "Read campaign: HTTP request failed."
    destroy loo_Vault
    destroy loo_Entry
    destroy loo_Tokens
    destroy loo_Http
    destroy loo_Resp
    destroy loo_Url
    destroy loo_Page
    return
end if

if (li_Success <> 1) OR (loo_Resp.StatusCode <> 200) then
    Write-Debug "Read campaign: HTTP " + string(loo_Resp.StatusCode) + " " + loo_Resp.BodyStr
    destroy loo_Vault
    destroy loo_Entry
    destroy loo_Tokens
    destroy loo_Http
    destroy loo_Resp
    destroy loo_Url
    destroy loo_Page
    return
end if

loo_Campaign = create oleobject
li_rc = loo_Campaign.ConnectToNewObject("Chilkat.JsonObject")

li_Success = loo_Campaign.Load(loo_Resp.BodyStr)
if li_Success <> 1 then
    Write-Debug "Expected a JSON object in the response."
    destroy loo_Vault
    destroy loo_Entry
    destroy loo_Tokens
    destroy loo_Http
    destroy loo_Resp
    destroy loo_Url
    destroy loo_Page
    destroy loo_Campaign
    return
end if

//  The campaign identifies the newsletter. The primary activity identifies the email to test or schedule.
loo_Primary = create oleobject
li_rc = loo_Primary.ConnectToNewObject("Chilkat.JsonObject")

li_Success = loo_Campaign.FindRecord2("campaign_activities","role","primary_email",1,loo_Primary)
if (li_Success <> 1) OR (loo_Primary.JsonTypeOf("campaign_activity_id") <> 1) then
    Write-Debug "No primary email activity ID in the response."
    destroy loo_Vault
    destroy loo_Entry
    destroy loo_Tokens
    destroy loo_Http
    destroy loo_Resp
    destroy loo_Url
    destroy loo_Page
    destroy loo_Campaign
    destroy loo_Primary
    return
end if

ls_SelectedCampaign = loo_Campaign.StringOf("campaign_id")
ls_SelectedActivity = loo_Primary.StringOf("campaign_activity_id")
if (ls_SelectedCampaign = "") OR (ls_SelectedActivity = "") then
    Write-Debug "Missing campaign or activity ID."
    destroy loo_Vault
    destroy loo_Entry
    destroy loo_Tokens
    destroy loo_Http
    destroy loo_Resp
    destroy loo_Url
    destroy loo_Page
    destroy loo_Campaign
    destroy loo_Primary
    return
end if

Write-Debug "Campaign ID: " + ls_SelectedCampaign
Write-Debug "Primary activity ID: " + ls_SelectedActivity
loo_Selection = create oleobject
li_rc = loo_Selection.ConnectToNewObject("Chilkat.JsonObject")

loo_Selection.UpdateString("name",loo_Campaign.StringOf("name"))
loo_Selection.UpdateString("campaign_id",ls_SelectedCampaign)
loo_Selection.UpdateString("campaign_activity_id",ls_SelectedActivity)
li_Success = loo_Selection.WriteFile("newsletter-selection.json")
if li_Success <> 1 then
    Write-Debug "Could not save newsletter-selection.json. Keep the IDs printed above."
    destroy loo_Vault
    destroy loo_Entry
    destroy loo_Tokens
    destroy loo_Http
    destroy loo_Resp
    destroy loo_Url
    destroy loo_Page
    destroy loo_Campaign
    destroy loo_Primary
    destroy loo_Selection
    return
end if

Write-Debug "Saved newsletter-selection.json."


destroy loo_Vault
destroy loo_Entry
destroy loo_Tokens
destroy loo_Http
destroy loo_Resp
destroy loo_Url
destroy loo_Page
destroy loo_Campaign
destroy loo_Primary
destroy loo_Selection