Constant Contact
Features | Details |
Release Status | Released |
Source API Version | v2 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | Constantcontact email Constantcontact password |
Replication Type | Full Replication Key based replication |
Replication Key | NA lastRunDate |
Suggested Replication Frequency | 24 hrs |
Tables/APIs Supported | ​ |
Contacts | EmailCampaigns |
MyLibraryFiles | AccountInfo |
TrashFiles | ContactLists |
ContactTracking | EmailCampaignSummary |
Events
Signin to Daton
Select constantcontact from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide your constantcontact email and password to authorize Daton to periodically extract data from constantcontact.
Post successful authentication you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration
Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
Contacts
Purpose: Method for retrieving a list of contacts.
Source API Documentation: https://constantcontact.mashery.com/io-docs​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
id | NUMERIC |
status | STRING |
fax | STRING |
addresses | RECORD |
notes | STRING |
confirmed | BOOLEAN |
lists | RECORD |
source | STRING |
email_addresses | RECORD |
prefix_name | STRING |
first_name | STRING |
middle_name | STRING |
last_name | STRING |
job_title | STRING |
company_name | STRING |
home_phone | NUMERIC |
work_phone | NUMERIC |
cell_phone | NUMERIC |
custom_fields | STRING |
created_date | TIMESTAMP |
modified_date | TIMESTAMP |
source_details | STRING |
EmailCampaigns
Purpose: This collection method returns a list of email campaigns.
Source API Documentation: https://constantcontact.mashery.com/io-docs​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
id | NUMERIC |
name | STRING |
status | STRING |
modified_date | TIMESTAMP |
MyLibraryFiles
Purpose: Retrieve the account's MyLibrary folder collection.
Source API Documentation: https://constantcontact.mashery.com/io-docs​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
name | STRING |
id | NUMERIC |
description | STRING |
folder | STRING |
height | NUMERIC |
width | NUMERIC |
size | NUMERIC |
url | STRING |
source | STRING |
status | STRING |
thumbnail | RECORD |
created_date | TIMESTAMP |
modified_date | TIMESTAMP |
folder_id | STRING |
is_image | BOOLEAN |
file_type | STRING |
AccountInfo
Purpose: Method to retrieve information about the account.
Source API Documentation: https://constantcontact.mashery.com/io-docs​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
website | STRING |
organization_name | STRING |
time_zone | STRING |
first_name | STRING |
last_name | STRING |
STRING | |
phone | STRING |
company_logo | STRING |
country_code | STRING |
status_code | STRING |
organization_addresses | STRING |
TrashFiles
Purpose: Retrieve files in the Trash folder
Source API Documentation: https://constantcontact.mashery.com/io-docs​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
name | STRING |
id | STRING |
description | STRING |
folder | STRING |
height | NUMERIC |
width | NUMERIC |
size | NUMERIC |
url | STRING |
source | STRING |
status | STRING |
thumbnail | RECORD |
created_date | TIMESTAMP |
modified_date | TIMESTAMP |
folder_id | STRING |
is_image | BOOLEAN |
file_type | STRING |
ContactLists
Purpose: This collection method returns a list of ContactLists.
Source API Documentation: https://constantcontact.mashery.com/io-docs​
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
id | NUMERIC |
name | STRING |
status | STRING |
created_date | TIMESTAMP |
modified_date | TIMESTAMP |
contact_count | NUMERIC |
ContactTracking
Purpose: Method for getting all activities for a Contact
Source API Documentation: https://constantcontact.mashery.com/io-docs​
Replication: key based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
activity_type | STRING |
campaign_id | NUMERIC |
contact_id | NUMERIC |
open_date | TIMESTAMP |
EmailCampaignSummary
Purpose: Get a summary of all activities for an email campaign
Source API Documentation: https://constantcontact.mashery.com/io-docs​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
checkid | INTEGER |
start_date | TIMESTAMP |
end_date | TIMESTAMP |
sends | NUMERIC |
opens | NUMERIC |
clicks | NUMERIC |
forwards | NUMERIC |
unsubscribes | NUMERIC |
bounces | NUMERIC |
spam_count | NUMERIC |
Events
Purpose: Retrieve all EventSpot events in the account
Source API Documentation: https://constantcontact.mashery.com/io-docs​
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
id | STRING |
name | STRING |
title | STRING |
status | STRING |
location | STRING |
type | STRING |
address | RECORD |
description | STRING |
start_date | TIMESTAMP |
end_date | TIMESTAMP |
created_date | TIMESTAMP |
total_registered_count | NUMERIC |
time_zone_id | STRING |
active_date | TIMESTAMP |
is_checkin_available | BOOLEAN |
event_detail_url | STRING |