VBScript Requires Chilkat v11.0.0+
VBScript
Constant Contact V3: Find a contact list by name
See more Constant Contact Examples
Start with the full list name from the Constant Contact account. Read its list_id and the number of active, mailable contacts. Use the ID for list membership operations or campaign targeting. This lookup requires contact_data.
Authorize the application using the same account and credential store.
Constant Contact developer guide
Chilkat VBScript Downloads
Dim fso, outFile
Set fso = CreateObject("Scripting.FileSystemObject")
'Create a Unicode (utf-16) output text file.
Set outFile = fso.CreateTextFile("output.txt", True, True)
success = 0
' Assumes Chilkat is unlocked. See Global Unlock Sample.
set vault = CreateObject("Chilkat.Secrets")
vault.Location = "local_manager"
vault.AutoSplit = 1
set entry = CreateObject("Chilkat.JsonObject")
success = entry.UpdateString("appName","ConstantContactV3")
success = entry.UpdateString("service","OAuth2")
success = entry.UpdateString("username","my-account")
set tokens = CreateObject("Chilkat.JsonObject")
loaded = vault.GetSecretJson(entry,tokens)
If (loaded <> 1) Then
outFile.WriteLine("Run the desktop authorization example using this account and store.")
WScript.Quit
End If
If (tokens.JsonTypeOf("access_token") <> 1) Then
outFile.WriteLine("The saved authorization has no access token.")
WScript.Quit
End If
set http = CreateObject("Chilkat.Http")
http.RequireSslCertVerify = 1
http.AuthToken = tokens.StringOf("access_token")
set resp = CreateObject("Chilkat.HttpResponse")
' Use the full display name. AddParam encodes spaces and punctuation.
listName = "Workshop announcements"
set query = CreateObject("Chilkat.HttpRequest")
query.HttpVerb = "GET"
query.AddParam "name",listName
query.AddParam "status","active"
query.AddParam "include_membership_count","active"
success = http.HttpReq("https://api.cc.email/v3/contact_lists",query,resp)
If ((success <> 1) And (resp.StatusCode <= 0)) Then
outFile.WriteLine("Look up list: HTTP request failed.")
WScript.Quit
End If
If ((success <> 1) Or (resp.StatusCode <> 200)) Then
outFile.WriteLine("Look up list: HTTP " & resp.StatusCode & " " & resp.BodyStr)
WScript.Quit
End If
set matches = CreateObject("Chilkat.JsonObject")
success = matches.Load(resp.BodyStr)
If (success <> 1) Then
outFile.WriteLine("Expected a JSON object in the response.")
WScript.Quit
End If
If (matches.SizeOfArray("lists") = 0) Then
outFile.WriteLine("No active email list named " & listName)
WScript.Quit
End If
If ((matches.SizeOfArray("lists") <> 1) Or (matches.StringOfEquals("lists[0].name",listName,1) <> 1)) Then
outFile.WriteLine("Expected one exact list name.")
WScript.Quit
End If
listId = matches.StringOf("lists[0].list_id")
If (listId = "") Then
outFile.WriteLine("Missing list ID.")
WScript.Quit
End If
outFile.WriteLine(listName & " | List ID: " & listId & " | Mailable contacts: " & matches.IntOf("lists[0].membership_count"))
outFile.Close