Iterable

Iterable is a cross-channel marketing platform that powers unified customer experiences and empowers you to create, optimize and measure every interaction across the entire customer journey.

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

Backup: Skyvia Backup does not support Iterable.

Query: Skyvia Query supports Iterable.

Establishing Connection

To establish a connection to Iterable, you need to specify your API Key.

Getting Credentials

To get a new Iterable API Key, perform the following steps:

  1. Sign in to Iterable.

  2. Click Integrations in the top menu.

    Iterable API Key

  3. Select API keys.

  4. Click New API Key.

    Iterable API Key

API Key is available for copying only the first time when it is created. So copy it and store it in a safe place.

Creating Connection

Paste the obtained API key into the API Key box in Skyvia.

Connection Editor window

Additional Connection Parameters

Suppressing Extended Requests

Iterable 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 additional fields is the following:

Object Field
Templates CreatorUserId, MessageTypeId, Metadata, FromName, FromEmail, ReplyToEmail, Subject, PreheaderText, CcEmails, BccEmails, HTML, PlainText, DataFeedIds, CacheDataFeed, MergeDataFeedContext

To reduce the number of API calls, select the Suppress Extended Requests checkbox. However, please note that the fields, listed above will not be available in Skyvia (will return empty values) even if they have values in Iterable because its API does not return them without extended requests.

Connector Specifics

Object Peculiarities

Campaigns

The fields SendAt, SendMode, StartTimeZone, DefaultTimeZone and DataFields are added only for using in import operations. They always return empty values.

Events

When importing data to the Events object, in addition to the required EventName field, you also need to specify one of these fields: Email or UserId.

Required Filters

Retrieving data from the Events, InAppMessages, and Users objects is only possible when filtering by Email.

DML Operations Supports

Operation Object
INSERT, UPDATE, DELETE CatalogItems
INSERT, UPDATE Templates
INSERT, DELETE Catalogs, Lists
INSERT Events, Campaigns, InAppMessages

Incremental Replication and Synchronization

Synchronization is supported for the following objects: CatalogItems, Templates.

Replication with Incremental Updates is supported for the following objects: Campaigns, CatalogItems, Events, InAppMessages, Lists, MessagesTypes, Templates.

Note that you need to add filters by the Email field for Events and AppMessages in a replication package if you want to replicate these object.

Stored Procedures

A part of the Iterable functionality is supported in Skyvia via stored procedures:

call AbortCampaign(:campaignId) — aborts a campaign with the specified id.

call TriggerCampaign (:campaignId, :listIds, :suppressionListIds, :dataFields, :allowRepeatMarketingSends) — triggers a campaign with the specified id against the specified lists. The listIds and suppressionListIds parameters must be specified as JSON arrays of integers, for example [1, 2, 3], and listIds must be a non-empty array. The dataFields parameter should be a JSON object with the respective fields to merge into handlebars context.

call CancelScheduledOrRecurringCampaign (:campaignId) — cancels a campaign with the specified id.

Supported Actions

Skyvia supports all the common actions for Iterable.

On This Page