Constant Contact

Constant Contact ETL connector for data replication

Need help with something?

Talk to data expert

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