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
- 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
Workflow
- 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
Constantcontact Data
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
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 1yr ago