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.

Iterable-Specific Features and Limitations

Skyvia has the following limitations for Iterable:

• In the Data Integration product, Iterable connections are supported only for packages, which use a new data integration runtime.

  Make sure that the Use new runtime checkbox is selected on the tab bar if you want to use Iterable in your package.

• Skyvia supports DML operations for such Iterable objects:
  • INSERT, UPDATE, DELETE: CatalogItems.
  • INSERT, UPDATE: Templates.
  • INSERT, DELETE: Lists, Catalogs.
  • INSERT: Campaigns, Events, InAppMessages.

• Skyvia supports Replication with Incremental Updates for such Iterable objects: Campaigns, CatalogItems, Events (with a mandatory filter by Email), InAppMessages (with a mandatory filter by Email), Lists, MessagesTypes, Templates.

• Skyvia supports Synchronization for such Iterable objects: CatalogItems, Templates.

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

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

• Campaigns object. Such fields as SendAt, SendMode, StartTimeZone, DefaultTimeZone and DataFields are used only for import operations. When retrieving data, they always remain empty.

• The following stored procedures can be used for Campaigns object:

  • AbortCampaign: call AbortCampaign(:campaignId)

  • TriggerCampaign: call TriggerCampaign (:campaignId, :listIds, :suppressionListIds, :dataFields, :allowRepeatMarketingSends) (where _campaignId_ is a mandatory parameter, all others – optional)

  • CancelScheduledOrRecurringCampaign: call CancelScheduledOrRecurringCampaign (:campaignId)

Iterable Connections

To create a connection to Iterable, you simply need to enter your API Key. To start creating a connection, follow the below steps:

1. Click +NEW in the top menu.
2. Click Connection in the menu on the left to open the Select Connector page.
3. In the opened pane, click Iterable.
4. In the Connection Editor page, specify a connection name that will be used to identify the connection.

5. Enter your API Key.

   

6. Use the Test Connection button to make sure that the connection is successful and then click Create Connection.

   API Key — REST API key used for connecting to Iterable. You can read more about creating an Iterable API Key here. Please note your API Key is available for full copying only the first time when it is created. Later on it will be half hiden. So paste your API Key to a safe place (word document, etc).

Receiving New Iterable API Key

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

1. Sign in to Iterable.

2. Click Integrations in the top menu.

   

3. Select API keys.

4. Click New API Key.

   

Supported Actions and Actions Specifics

Iterable connector supports the following actions:

• Execute Command in Source, Lookup, and Target Data Flow components and in Import and Export tasks in the Advanced mode.

• Execute Query in Source Data Flow components and in Import and Export tasks in the Advanced mode.

• Lookup in Lookup Data Flow components.
• Insert in Target Data Flow components.