PowerBuilder Requires Chilkat v11.0.0+
PowerBuilder
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
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