Constant Contact

Constant Contact is an easy-to-use email marketing service that helps create effective email marketing and other online marketing campaigns to meet customers’ business goals.

Data integration: Skyvia supports importing data to and from Constant Contact, exporting Constant Contact data to CSV files, replicating Constant Contact data to relational databases, and synchronizing Constant Contact data with other cloud apps and relational databases.

Backup: Skyvia Backup does not support Constant Contact backup.

Query: Skyvia Query supports Constant Contact.

Establishing Connection

To create a connection, log in with a Constant Contact account. Skyvia stores only the OAuth authentication token. Skyvia does not store your credentials.

Creating Connection

To create a Constant Contact connection, perform the following steps:

Connection Editor window

  1. Click Sign In with Constant Contact.

  2. Enter your Constant Contact credentials and click Sign in.

    Log In window

  3. Give your consent to the list of requested permissions.

Grant permissions

Additional Connection Parameters

Suppress Extended Requests

Constant Contact API returns only part of the fields for some objects when querying multiple records. To query the values of additional fields, Skyvia performs additional extended requests for each record of such an object. However, this can decrease performance and significantly increase the number of API calls.

The list of such additional fields is the following:

OBJECT FIELD
Campaigns CampaignActivities

To reduce the number of API calls, select the Suppress Extended Requests checkbox. However, please note that some fields in such objects are unavailable in Skyvia (return empty values) even if they have values in Constant Contact because its API does not return them without extended requests.

Use Custom Fields

Select this checkbox to make Constant Contact custom fields available in Skyvia.

Connector Specifics

Object Specifics

Campaigns

The Campaigns object stores data about campaign activities as a JSON array. If you need to load data into the Campaigns object, you must map the Name, and Activities fields and provide values for the Activities field as JSON arrays, for example:

[{ "format_type": 5, "from_name": "NAME", "from_email": "[email protected]", "reply_to_email": "[email protected]", "subject": "SUBJECT", "html_content": "CONTENT" }]

Where NAME, [email protected], SUBJECT, and CONTENT should be replaced with the respective values. You may also add the preheader parameter and physical_address_in_footer and document_properties objects to records in the JSON array.

Campaign activity data, stored in the Activity field of the Campaigns object is also available via the CampaignActivities object.

You can access some Constant Contact objects only via their parent objects. For example, to query CampaignActivities, Constant Contact API requires the ID of the corresponding Campaigns record. To get records from a number of other objects, Constant Contact API requires the ID of the corresponding CampaignActivity. These are the following objects: EmailLinksReport, EmailDidNotOpensReport, EmailBouncesReport, EmailBouncesReport, EmailForwardsReport, EmailForwardsReport, EmailOpensReport, EmailOptoutsReport, EmailSendsReport, EmailUniqueOpensReport, EmailPreviews, CampaignActivitySchedule, CampaignActivitySendHistory.

Skyvia does not require the ID of the parent object from users. If you don’t specify the IDs of the parent objects (for example, in a filter), Skyvia queries all the parent object records first, takes their IDs, and then queries child object records for each parent object record. This allows querying child objects without knowing their parents, but this method takes time and consumes many API calls. It uses at least one API call for every parent object record. Thus, working with child objects without filtering them on their parents can be very slow and use additional API calls.

We strongly recommend using filters by the parent object fields when querying data from child objects. This reduces the number of parent object records for which child object data must be queried.

DML Operations Support

Operation Object
INSERT, UPDATE, DELETE Campaigns, ContactCustomFields, ContactLists, Contacts, Segments
INSERT AccountEmails, CampaignActivitySchedule

Incremental Replication and Synchronization

Skyvia supports Incremental Replication for the following Constant Contact objects: Campaigns, ContactCustomFields, ContactLists, Contacts, EmailBouncesReport, EmailDidNotOpensReport, EmailForwardsReport, EmailOpensReport, EmailOptoutsReport, EmailSendsReport, EmailUniqueOpensReport, Segments. Skyvia detects only the newly created records for the objects with the *Report suffix in their names.

Skyvia supports Synchronization for the following ConstantContact objects: Campaigns, ContactCustomFields, ContactLists, Contacts, Segments.

Custom Fields

Constant Contact API supports custom fields for the Contacts object. You can add custom fields of the following types.

Constant Contact Type DbType
Text String
Date Date

Stored Procedures

For user convenience Skyvia represents part of the supported Constant Contact features as stored procedures. Procedures help to optimize connector performance and avoid exceeding API limits.

You can call a stored procedure, for example, as a text of the command in the ExecuteCommand action in a Target component of a Data Flow or in Query.

GetContacts

Use this command to select all the existing contacts.

call GetContacts()

GetContactsByIds

This command selects the particular contacts by their Ids.

call GetContactsByIds(:Id)

The Id parameter can be a single ID value or a JSON array of ID values.

For example, use the following format to select a single contact call GetContactsByIds('2b1ee4d2-44fb-11ef-ade7-fa163eb6961b').

Use the following format to select multiple contacts call GetContactsByIds('["2b1ee4d2-44fb-11ef-ade7-fa163eb6961b","770b9666-4540-11ef-b0e3-fa163e504c74"]').

GetContactsByListIds

This command selects the particular contacts by their list Ids.

call GetContactsByListIds(:ListId)

The ListId parameter can be a single ID value or a JSON array of ID values.

For example, use the following format to select contacts from a single list call GetContactsByListIds('4894476a-4a81-11ef-ab7d-fa163edfbcfb').

Use the following format to select contacts from multiple lists call GetContactsByListIds('["4894476a-4a81-11ef-ab7d-fa163edfbcfb","6764a04e-5bb2-11ef-a45b-fa163edfbcfb"]').

GetContactsBySegmentId

Use the following command to select contacts by the segment Id. You can find out the segment Id value by selecting the Segmants object.

call GetContactsBySegmentId(:SegmentId)

Supported Actions

Skyvia supports all the common actions for Constant Contact.

On This Page