Constant Contact
Constant Contact ETL connector for data replication
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 |
email |
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 |
