Constant Contact
Constant Contact ETL connector for data replication
Snapshot
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
Integrate Constantcontact with Daton
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
Workflow
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
Constantcontact Data
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 |
Last updated