Constant Contact
Constant Contact ETL connector for data replication
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
- 1.Signin to Daton
- 2.Select constantcontact from Integrations page
- 3.Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
- 4.Provide your constantcontact email and password to authorize Daton to periodically extract data from constantcontact.
- 5.Post successful authentication you will be prompted to choose from the list of available tables
- 6.Then select all required fields for each table
- 7.Submit the integration
- 1.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
- 2.Users would be able to edit/pause/re-activate/delete integration anytime
- 3.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.
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.
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.
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.
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
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.
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
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
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
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 modified 2yr ago