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.

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