Iterable

Iterable is a customer engagement platform that enables brands to create, execute, and optimize cross-channel campaigns.

Iterable integration replicates data using the Iterable API 1.8.

See the Schema section for a list of objects available for replication.

Présentation générale de ce connecteur, y compris des liens utiles et les fonctions supportées.

Caractéristique/Fonctionnalité	Détails du support
Projets Qlik Talend Data Integration supportés	Projets de réplication uniquement. Les projets de pipeline de données ne sont pas supportés.
Méthodes de mise à jour de la cible	Tâches de réplication : Appliquer les modifications Stocker les modifications Tâches de dépôt temporaire de données dans un lac de données : Change Data Capture (CDC)
Gestion des métadonnées	La génération manuelle de métadonnées n'est pas nécessaire.
Évolution du schéma	Seule l'opération Modifier le type de données de la colonne est supportée.
Réplication de colonnes LOB (NCLOB, CLOB et BLOB)	Non supporté.
Opération CDC planifiée	Requis. C'est ainsi que la cible est mise à jour en fonction des modifications apportées à la source. Pour les tâches de réplication, consultez Planification de tâches . Pour les tâches de dépôt temporaire dans un lac, consultez Planification de CDC pour les tâches de dépôt temporaire dans un lac.
Notifications	Partiellement supporté Définition de notifications en cas de modifications du fonctionnement
Monitoring	CDC uniquement, car Chargement complet n'est pas pertinent pour ce connecteur. Surveillance d'une tâche de données individuelle
Désimbrication automatique des charges utiles des colonnes JSON	Non supporté. Les charges utiles des colonnes JSON des jeux de données sources ne sont pas automatiquement désimbriquées sur la cible.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Assurez-vous que le compte que vous utilisez dispose d'un accès en lecture sur les tables à récupérer.

You must be an org admin or a user with API and Webhook configuration permissions in your Iterable account.

To generate the API key:

Log into your Iterable account.
Navigate to Integrations > API Keys.
Click New API Key.
In the Create a new API key window, name your API key and select read-only.
Click Create.
Copy the key.

Creating the connection

Pour plus d'informations, consultez Connexion à des applications SaaS.

Complétez les propriétés de connexion requises.
Fournissez un nom pour la connexion dans Nom de la connexion.
Sélectionnez Ouvrir les métadonnées de connexion pour définir les métadonnées de la connexion lors de sa création.
Cliquez sur Créer.

Connection settings
Setting	Description
Data gateway	Sélectionnez une Passerelle de déplacement des données si cela est nécessaire pour votre cas d'utilisation. Note Informations Ce champ n'est pas disponible avec l'abonnement Démarreur Qlik Talend Cloud, car il ne supporte pas Passerelle de déplacement des données. Si vous avez un autre niveau d'abonnement et si vous ne souhaitez pas utiliser Passerelle de déplacement des données, sélectionnez Aucune. Pour des informations sur les avantages de Passerelle de déplacement des données et les cas d'utilisation qui la nécessitent, consultez Passerelle de données Qlik - Déplacement des données.
Start Date	Saisissez la date, au format `MM/DD/YYYY`, à partir de laquelle les données doivent être répliquées de votre source vers votre cible.
Iterable API Key	Iterable API key.
Window in Days	Window in days. This parameter should be set to an optimum value to improve historical sync performance. Setting this value too low will take longer to complete historical sync and setting it larger may result in request timeouts or memory overflow issues.

Schema

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 1.

Depending on your destination, table and column names may not appear as they are outlined below.

campaigns

The campaigns table contains information about campaigns in your Iterable projcect.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Iterable API method

Join campaigns with	on
email_bounce	campaigns.id = email_bounce.campaignId campaigns.templateId = email_bounce.templateId
email_click	campaigns.id = email_click.campaignId campaigns.templateId = email_click.templateId
email_complaint	campaigns.id = email_complaint.campaignId campaigns.templateId = email_complaint.templateId
email_open	campaigns.id = email_open.campaignId campaigns.templateId = email_open.templateId
email_send	campaigns.id = email_send.campaignId campaigns.templateId = email_send.templateId
email_send_skip	campaigns.id = email_send_skip.campaignId campaigns.templateId = email_send_skip.templateId
email_subscribe	campaigns.id = email_subscribe.campaignId campaigns.templateId = email_subscribe.templateId
email_unsubscribe	campaigns.id = email_unsubscribe.campaignId campaigns.templateId = email_unsubscribe.templateId
templates	campaigns.id = templates.campaignId campaigns.templateId = templates.templateId

campaignState

STRING

createdAt

DATE-TIME

createdByUserId

STRING

endedAt

DATE-TIME

INTEGER

labels

ARRAY

This is a nested data structure.

listIds

ARRAY

This is a nested data structure.

messageMedium

STRING

name

STRING

recurringCampaignId

INTEGER

sendSize

NUMBER

startAt

DATE-TIME

suppressionListIds

ARRAY

This is a nested data structure.

templateId

INTEGER

type

STRING

updatedAt

DATE-TIME

updatedByUserId

STRING

workflowId

INTEGER

channels

The channels table contains information about all channels within your Iterable project.

Replication Method

Full Table

Primary Key

Useful links

Iterable API method

Join channels with	on
email_send	channels.id = email_send.channelId
email_send_skip	channels.id = email_send_skip.channelId
email_subscribe	channels.id = email_subscribe.channelIds.items
email_unsubscribe	channels.id = email_unsubscribe.channelIds.items channels.id = email_unsubscribe.channelId
message_types	channels.id = message_types.channelId

channelType

STRING

INTEGER

messageMedium

STRING

name

STRING

email_bounce

The email_bounce table contains information about bounced emails within your Iterable campaign.

Replication Method	CDC
Primary Key	email
Replication Key	createdAt
Useful links	Iterable API method

Join email_bounce with	on
campaigns	email_bounce.campaignId = campaigns.id email_bounce.templateId = campaigns.templateId
email_click	email_bounce.campaignId = email_click.campaignId email_bounce.email = email_click.email email_bounce.templateId = email_click.templateId
email_complaint	email_bounce.campaignId = email_complaint.campaignId email_bounce.email = email_complaint.email email_bounce.templateId = email_complaint.templateId
email_open	email_bounce.campaignId = email_open.campaignId email_bounce.email = email_open.email email_bounce.templateId = email_open.templateId
email_send	email_bounce.campaignId = email_send.campaignId email_bounce.email = email_send.email email_bounce.templateId = email_send.templateId
email_send_skip	email_bounce.campaignId = email_send_skip.campaignId email_bounce.email = email_send_skip.email email_bounce.templateId = email_send_skip.templateId
email_subscribe	email_bounce.campaignId = email_subscribe.campaignId email_bounce.email = email_subscribe.email email_bounce.templateId = email_subscribe.templateId
email_unsubscribe	email_bounce.campaignId = email_unsubscribe.campaignId email_bounce.email = email_unsubscribe.email email_bounce.templateId = email_unsubscribe.templateId
templates	email_bounce.campaignId = templates.campaignId email_bounce.templateId = templates.templateId
users	email_bounce.email = users.email
list_users	email_bounce.email = list_users.email

campaignId

INTEGER

createdAt

DATE-TIME

email

STRING

eventName

STRING

itblInternal

OBJECT

This is a nested data structure:

documentCreatedAt: DATE-TIME
documentUpdatedAt: DATE-TIME

messageId

STRING

recipientState

STRING

status

STRING

templateId

INTEGER

email_click

The email_click table contains information about clicks on your Iterable email campaign.

Replication Method	CDC
Primary Key	email
Replication Key	createdAt
Useful links	Iterable API method

Join email_click with	on
campaigns	email_click.campaignId = campaigns.id email_click.templateId = campaigns.templateId
email_bounce	email_click.campaignId = email_bounce.campaignId email_click.email = email_bounce.email email_click.templateId = email_bounce.templateId
email_complaint	email_click.campaignId = email_complaint.campaignId email_click.email = email_complaint.email email_click.templateId = email_complaint.templateId
email_open	email_click.campaignId = email_open.campaignId email_click.email = email_open.email email_click.templateId = email_open.templateId
email_send	email_click.campaignId = email_send.campaignId email_click.email = email_send.email email_click.templateId = email_send.templateId
email_send_skip	email_click.campaignId = email_send_skip.campaignId email_click.email = email_send_skip.email email_click.templateId = email_send_skip.templateId
email_subscribe	email_click.campaignId = email_subscribe.campaignId email_click.email = email_subscribe.email email_click.templateId = email_subscribe.templateId
email_unsubscribe	email_click.campaignId = email_unsubscribe.campaignId email_click.email = email_unsubscribe.email email_click.templateId = email_unsubscribe.templateId
templates	email_click.campaignId = templates.campaignId email_click.templateId = templates.templateId
users	email_click.email = users.email
list_users	email_click.email = list_users.email

campaignId

INTEGER

city

STRING

contentId

INTEGER

country

STRING

createdAt

DATE-TIME

email

STRING

eventName

STRING

hrefIndex

INTEGER

STRING

itblInternal

OBJECT

This is a nested data structure:

documentCreatedAt: DATE-TIME
documentUpdatedAt: DATE-TIME

messageId

STRING

region

STRING

templateId

INTEGER

url

STRING

userAgent

STRING

userAgentDevice

STRING

email_complaint

The email_complaint table contains information about email recipients that sent complaints for your Iterable campain.

Replication Method	CDC
Primary Key	email
Replication Key	createdAt
Useful links	Iterable API method

Join email_complaint with	on
campaigns	email_complaint.campaignId = campaigns.id email_complaint.templateId = campaigns.templateId
email_bounce	email_complaint.campaignId = email_bounce.campaignId email_complaint.email = email_bounce.email email_complaint.templateId = email_bounce.templateId
email_click	email_complaint.campaignId = email_click.campaignId email_complaint.email = email_click.email email_complaint.templateId = email_click.templateId
email_open	email_complaint.campaignId = email_open.campaignId email_complaint.email = email_open.email email_complaint.templateId = email_open.templateId
email_send	email_complaint.campaignId = email_send.campaignId email_complaint.email = email_send.email email_complaint.templateId = email_send.templateId
email_send_skip	email_complaint.campaignId = email_send_skip.campaignId email_complaint.email = email_send_skip.email email_complaint.templateId = email_send_skip.templateId
email_subscribe	email_complaint.campaignId = email_subscribe.campaignId email_complaint.email = email_subscribe.email email_complaint.templateId = email_subscribe.templateId
email_unsubscribe	email_complaint.campaignId = email_unsubscribe.campaignId email_complaint.email = email_unsubscribe.email email_complaint.templateId = email_unsubscribe.templateId
templates	email_complaint.campaignId = templates.campaignId email_complaint.templateId = templates.templateId
users	email_complaint.email = users.email
list_users	email_complaint.email = list_users.email

campaignId

INTEGER

createdAt

DATE-TIME

email

STRING

eventName

STRING

itblInternal

OBJECT

This is a nested data structure:

documentCreatedAt: DATE-TIME
documentUpdatedAt: DATE-TIME

messageId

STRING

recipientState

STRING

templateId

INTEGER

email_open

The email_open table contains information about email recipients that opened your Iterable campaign.

Replication Method	CDC
Primary Key	email
Replication Key	createdAt
Useful links	Iterable API method

Join email_open with	on
campaigns	email_open.campaignId = campaigns.id email_open.templateId = campaigns.templateId
email_bounce	email_open.campaignId = email_bounce.campaignId email_open.email = email_bounce.email email_open.templateId = email_bounce.templateId
email_click	email_open.campaignId = email_click.campaignId email_open.email = email_click.email email_open.templateId = email_click.templateId
email_complaint	email_open.campaignId = email_complaint.campaignId email_open.email = email_complaint.email email_open.templateId = email_complaint.templateId
email_send	email_open.campaignId = email_send.campaignId email_open.email = email_send.email email_open.templateId = email_send.templateId
email_send_skip	email_open.campaignId = email_send_skip.campaignId email_open.email = email_send_skip.email email_open.templateId = email_send_skip.templateId
email_subscribe	email_open.campaignId = email_subscribe.campaignId email_open.email = email_subscribe.email email_open.templateId = email_subscribe.templateId
email_unsubscribe	email_open.campaignId = email_unsubscribe.campaignId email_open.email = email_unsubscribe.email email_open.templateId = email_unsubscribe.templateId
templates	email_open.campaignId = templates.campaignId email_open.templateId = templates.templateId
users	email_open.email = users.email
list_users	email_open.email = list_users.email

campaignId

INTEGER

city

STRING

contentId

INTEGER

country

STRING

createdAt

DATE-TIME

email

STRING

eventName

STRING

itblInternal

OBJECT

This is a nested data structure:

documentCreatedAt: DATE-TIME
documentUpdatedAt: DATE-TIME

messageId

STRING

proxySource

STRING

region

STRING

templateId

INTEGER

userAgent

STRING

userAgentDevice

STRING

email_send

The email_send table contains information about campaign emails you sent in your Iterable account.

Replication Method	CDC
Primary Key	email
Replication Key	createdAt
Useful links	Iterable API method

Join email_send with	on
campaigns	email_send.campaignId = campaigns.id email_send.templateId = campaigns.templateId
email_bounce	email_send.campaignId = email_bounce.campaignId email_send.email = email_bounce.email email_send.templateId = email_bounce.templateId
email_click	email_send.campaignId = email_click.campaignId email_send.email = email_click.email email_send.templateId = email_click.templateId
email_complaint	email_send.campaignId = email_complaint.campaignId email_send.email = email_complaint.email email_send.templateId = email_complaint.templateId
email_open	email_send.campaignId = email_open.campaignId email_send.email = email_open.email email_send.templateId = email_open.templateId
email_send_skip	email_send.campaignId = email_send_skip.campaignId email_send.channelId = email_send_skip.channelId email_send.email = email_send_skip.email email_send.templateId = email_send_skip.templateId
email_subscribe	email_send.campaignId = email_subscribe.campaignId email_send.channelId = email_subscribe.channelIds.items email_send.email = email_subscribe.email email_send.templateId = email_subscribe.templateId
email_unsubscribe	email_send.campaignId = email_unsubscribe.campaignId email_send.channelId = email_unsubscribe.channelIds.items email_send.channelId = email_unsubscribe.channelId email_send.email = email_unsubscribe.email email_send.templateId = email_unsubscribe.templateId
templates	email_send.campaignId = templates.campaignId email_send.templateId = templates.templateId
channels	email_send.channelId = channels.id
message_types	email_send.channelId = message_types.channelId
users	email_send.email = users.email
list_users	email_send.email = list_users.email

campaignId

INTEGER

catalogCollectionCount

INTEGER

catalogLookupCount

INTEGER

channelId

INTEGER

contentId

INTEGER

createdAt

DATE-TIME

email

STRING

espName

STRING

itblInternal

OBJECT

This is a nested data structure:

documentCreatedAt: DATE-TIME
documentUpdatedAt: DATE-TIME

messageBusId

STRING

messageId

STRING

messageTypeId

INTEGER

productRecommendationCount

INTEGER

templateId

INTEGER

transactionalData

OBJECT

This is a nested data structure:

campaignId: INTEGER
categories: ARRAY, which is also a nested data structure.
compare_at_price: NUMBER
createdAt: DATE-TIME
description: STRING
discount: INTEGER
email: STRING
eventName: STRING
eventUpdatedAt: DATE-TIME
handle: STRING
id: INTEGER
imageUrl: STRING
inventory: INTEGER
itblInternal: OBJECT, which is also a nested data structure.
- documentCreatedAt: DATE-TIME
- documentUpdatedAt: DATE-TIME
name: STRING
price: INTEGER
product_id: STRING
product_type: STRING
sku: STRING
sku: INTEGER
url: STRING
vendor: STRING

email_send_skip

The email_send_skip table contains information about campaign email recipients that were skipped in your Iterable account.

Replication Method	CDC
Primary Key	email
Replication Key	createdAt
Useful links	Iterable API method

Join email_send_skip with	on
campaigns	email_send_skip.campaignId = campaigns.id email_send_skip.templateId = campaigns.templateId
email_bounce	email_send_skip.campaignId = email_bounce.campaignId email_send_skip.email = email_bounce.email email_send_skip.templateId = email_bounce.templateId
email_click	email_send_skip.campaignId = email_click.campaignId email_send_skip.email = email_click.email email_send_skip.templateId = email_click.templateId
email_complaint	email_send_skip.campaignId = email_complaint.campaignId email_send_skip.email = email_complaint.email email_send_skip.templateId = email_complaint.templateId
email_open	email_send_skip.campaignId = email_open.campaignId email_send_skip.email = email_open.email email_send_skip.templateId = email_open.templateId
email_send	email_send_skip.campaignId = email_send.campaignId email_send_skip.channelId = email_send.channelId email_send_skip.email = email_send.email email_send_skip.templateId = email_send.templateId
email_subscribe	email_send_skip.campaignId = email_subscribe.campaignId email_send_skip.channelId = email_subscribe.channelIds.items email_send_skip.email = email_subscribe.email email_send_skip.templateId = email_subscribe.templateId
email_unsubscribe	email_send_skip.campaignId = email_unsubscribe.campaignId email_send_skip.channelId = email_unsubscribe.channelIds.items email_send_skip.channelId = email_unsubscribe.channelId email_send_skip.email = email_unsubscribe.email email_send_skip.templateId = email_unsubscribe.templateId
templates	email_send_skip.campaignId = templates.campaignId email_send_skip.templateId = templates.templateId
channels	email_send_skip.channelId = channels.id
message_types	email_send_skip.channelId = message_types.channelId
users	email_send_skip.email = users.email
list_users	email_send_skip.email = list_users.email

campaignId

INTEGER

channelId

INTEGER

contentId

INTEGER

createdAt

DATE-TIME

email

STRING

itblInternal

OBJECT

This is a nested data structure:

documentCreatedAt: DATE-TIME
documentUpdatedAt: DATE-TIME

messageId

STRING

messageTypeId

INTEGER

reason

STRING

templateId

INTEGER

transactionalData

OBJECT

This is a nested data structure:

campaignId: INTEGER
categories: ARRAY, which is also a nested data structure.
compare_at_price: NUMBER
createdAt: DATE-TIME
description: STRING
discount: INTEGER
email: STRING
eventName: STRING
eventUpdatedAt: DATE-TIME
handle: STRING
id: INTEGER
imageUrl: STRING
inventory: INTEGER
itblInternal: OBJECT, which is also a nested data structure.
- documentCreatedAt: DATE-TIME
- documentUpdatedAt: DATE-TIME
name: STRING
price: INTEGER
product_id: STRING
product_type: STRING
sku: STRING
sku: INTEGER
url: STRING
vendor: STRING

The email_subscribe table contains information about emails subscribed to your Iterable campaign.

Replication Method	CDC
Primary Key	email
Replication Key	createdAt
Useful links	Iterable API method

Join email_subscribe with	on
campaigns	email_subscribe.campaignId = campaigns.id email_subscribe.templateId = campaigns.templateId
email_bounce	email_subscribe.campaignId = email_bounce.campaignId email_subscribe.email = email_bounce.email email_subscribe.templateId = email_bounce.templateId
email_click	email_subscribe.campaignId = email_click.campaignId email_subscribe.email = email_click.email email_subscribe.templateId = email_click.templateId
email_complaint	email_subscribe.campaignId = email_complaint.campaignId email_subscribe.email = email_complaint.email email_subscribe.templateId = email_complaint.templateId
email_open	email_subscribe.campaignId = email_open.campaignId email_subscribe.email = email_open.email email_subscribe.templateId = email_open.templateId
email_send	email_subscribe.campaignId = email_send.campaignId email_subscribe.channelIds.items = email_send.channelId email_subscribe.email = email_send.email email_subscribe.templateId = email_send.templateId
email_send_skip	email_subscribe.campaignId = email_send_skip.campaignId email_subscribe.channelIds.items = email_send_skip.channelId email_subscribe.email = email_send_skip.email email_subscribe.templateId = email_send_skip.templateId
email_unsubscribe	email_subscribe.campaignId = email_unsubscribe.campaignId email_subscribe.channelIds.items = email_unsubscribe.channelIds.items email_subscribe.channelIds.items = email_unsubscribe.channelId email_subscribe.email = email_unsubscribe.email email_subscribe.templateId = email_unsubscribe.templateId
templates	email_subscribe.campaignId = templates.campaignId email_subscribe.templateId = templates.templateId
channels	email_subscribe.channelIds.items = channels.id
message_types	email_subscribe.channelIds.items = message_types.channelId
users	email_subscribe.email = users.email
list_users	email_subscribe.email = list_users.email

email_unsubscribe

The email_unsubscribe table contains information about emails unsubscribed from your Iterable campaign.

Replication Method	CDC
Primary Key	email
Replication Key	createdAt
Useful links	Iterable API method

Join email_unsubscribe with	on
campaigns	email_unsubscribe.campaignId = campaigns.id email_unsubscribe.templateId = campaigns.templateId
email_bounce	email_unsubscribe.campaignId = email_bounce.campaignId email_unsubscribe.email = email_bounce.email email_unsubscribe.templateId = email_bounce.templateId
email_click	email_unsubscribe.campaignId = email_click.campaignId email_unsubscribe.email = email_click.email email_unsubscribe.templateId = email_click.templateId
email_complaint	email_unsubscribe.campaignId = email_complaint.campaignId email_unsubscribe.email = email_complaint.email email_unsubscribe.templateId = email_complaint.templateId
email_open	email_unsubscribe.campaignId = email_open.campaignId email_unsubscribe.email = email_open.email email_unsubscribe.templateId = email_open.templateId
email_send	email_unsubscribe.campaignId = email_send.campaignId email_unsubscribe.channelIds.items = email_send.channelId email_unsubscribe.channelId = email_send.channelId email_unsubscribe.email = email_send.email email_unsubscribe.templateId = email_send.templateId
email_send_skip	email_unsubscribe.campaignId = email_send_skip.campaignId email_unsubscribe.channelIds.items = email_send_skip.channelId email_unsubscribe.channelId = email_send_skip.channelId email_unsubscribe.email = email_send_skip.email email_unsubscribe.templateId = email_send_skip.templateId
email_subscribe	email_unsubscribe.campaignId = email_subscribe.campaignId email_unsubscribe.channelIds.items = email_subscribe.channelIds.items email_unsubscribe.channelId = email_subscribe.channelIds.items email_unsubscribe.email = email_subscribe.email email_unsubscribe.templateId = email_subscribe.templateId
templates	email_unsubscribe.campaignId = templates.campaignId email_unsubscribe.templateId = templates.templateId
channels	email_unsubscribe.channelIds.items = channels.id email_unsubscribe.channelId = channels.id
message_types	email_unsubscribe.channelIds.items = message_types.channelId email_unsubscribe.channelId = message_types.channelId
users	email_unsubscribe.email = users.email
list_users	email_unsubscribe.email = list_users.email

bounceMessage

STRING

campaignId

INTEGER

channelId

INTEGER

channelIds

ARRAY

This is a nested data structure.

createdAt

DATE-TIME

email

STRING

emailListId

INTEGER

emailListIds

ARRAY

This is a nested data structure.

eventName

STRING

itblInternal

OBJECT

This is a nested data structure:

documentCreatedAt: DATE-TIME
documentUpdatedAt: DATE-TIME

messageId

STRING

recipientState

STRING

status

STRING

templateId

INTEGER

unsubSource

STRING

workflowId

INTEGER

list_users

The list_users table contains information about users in a list in your Iterable account.

Replication Method

Full Table

Primary Keys

listId

Useful links

Iterable API method

Join list_users with	on
users	list_users.email = users.email
email_bounce	list_users.email = email_bounce.email
email_click	list_users.email = email_click.email
email_complaint	list_users.email = email_complaint.email
email_open	list_users.email = email_open.email
email_send	list_users.email = email_send.email
email_send_skip	list_users.email = email_send_skip.email
email_subscribe	list_users.email = email_subscribe.email
email_unsubscribe	list_users.email = email_unsubscribe.email
lists	list_users.listId = lists.id

email

STRING

listId

INTEGER

updatedAt

DATE-TIME

lists

The lists tablecontains information about lists within your Iterable project.

Replication Method

Full Table

Primary Key

Useful links

Iterable API method

Join lists with	on
list_users	lists.id = list_users.listId

createdAt

DATE-TIME

description

STRING

INTEGER

listType

STRING

name

STRING

message_types

The message_types table contains information about all message types within your Iterable project.

Replication Method

Full Table

Primary Key

Useful links

Iterable API method

Join message_types with	on
channels	message_types.channelId = channels.id
email_send	message_types.channelId = email_send.channelId
email_send_skip	message_types.channelId = email_send_skip.channelId
email_subscribe	message_types.channelId = email_subscribe.channelIds.items
email_unsubscribe	message_types.channelId = email_unsubscribe.channelIds.items message_types.channelId = email_unsubscribe.channelId
templates	message_types.id = templates.messageTypeId

channelId

INTEGER

createdAt

DATE-TIME

INTEGER

name

STRING

subscriptionPolicy

STRING

updatedAt

DATE-TIME

metadata

The metadata table contains the metadata for a single key in your Iterable account.

Replication Method

Full Table

Primary Key

key

Useful links

Iterable API method

key

STRING

lastModified

DATE-TIME

size

INTEGER

table

STRING

value

OBJECT

This is a nested data structure:

categories: ARRAY, which is also a nested data structure.
compare_at_price: NUMBER
description: STRING
discount: INTEGER
handle: STRING
id: STRING
imageUrl: STRING
inventory: INTEGER
name: STRING
price: INTEGER
product_id: STRING
product_type: STRING
sku: STRING
url: STRING
vendor: STRING

templates

The templates table contains information about project templates in you Iterable account.

Replication Method	CDC
Primary Key	templateId
Replication Key	updatedAt
Useful links	Iterable API method

Join templates with	on
campaigns	templates.campaignId = campaigns.id templates.templateId = campaigns.templateId
email_bounce	templates.campaignId = email_bounce.campaignId templates.templateId = email_bounce.templateId
email_click	templates.campaignId = email_click.campaignId templates.templateId = email_click.templateId
email_complaint	templates.campaignId = email_complaint.campaignId templates.templateId = email_complaint.templateId
email_open	templates.campaignId = email_open.campaignId templates.templateId = email_open.templateId
email_send	templates.campaignId = email_send.campaignId templates.templateId = email_send.templateId
email_send_skip	templates.campaignId = email_send_skip.campaignId templates.templateId = email_send_skip.templateId
email_subscribe	templates.campaignId = email_subscribe.campaignId templates.templateId = email_subscribe.templateId
email_unsubscribe	templates.campaignId = email_unsubscribe.campaignId templates.templateId = email_unsubscribe.templateId
message_types	templates.messageTypeId = message_types.id

campaignId

INTEGER

clientTemplateId

STRING

createdAt

DATE-TIME

creatorUserId

STRING

messageTypeId

INTEGER

name

STRING

templateId

INTEGER

updatedAt

DATE-TIME

users

The users table contains information about all users in your Iterable account.

Replication Method	CDC
Primary Key	email
Replication Key	profileUpdatedAt
Useful links	Iterable documentation Iterable API method

Join users with	on
email_bounce	users.email = email_bounce.email
email_click	users.email = email_click.email
email_complaint	users.email = email_complaint.email
email_open	users.email = email_open.email
email_send	users.email = email_send.email
email_send_skip	users.email = email_send_skip.email
email_subscribe	users.email = email_subscribe.email
email_unsubscribe	users.email = email_unsubscribe.email
list_users	users.email = list_users.email

CCProvider

STRING

Industry

STRING

accessIp

STRING

acquisition_source

STRING

actively_seeking

BOOLEAN

age

INTEGER

auctionDigest

OBJECT

This is a nested data structure.

ARRAY

This is a nested data structure.

auctionDigest.auctionDateLocation

ARRAY

This is a nested data structure.

auctionDigest.auctionHouse

ARRAY

This is a nested data structure.

auctionDigest.auctionImageUrl

ARRAY

This is a nested data structure.

auctionDigest.auctionInfo

ARRAY

This is a nested data structure.

auctionDigest.name

ARRAY

This is a nested data structure.

averageOrderValue

NUMBER

badgeCount

INTEGER

bestFriend

STRING

booked_activity_before

BOOLEAN

booked_package_before

BOOLEAN

browserTokens

STRING

city

STRING

congressional Districts

STRING

counties

STRING

current_employer

STRING

current_employer_id

STRING

date_last_booked_package

DATE-TIME

daysSinceLastOrder

INTEGER

designation

STRING

devices

OBJECT

This is a nested data structure.

ARRAY

This is a nested data structure.

devices.applicationName

ARRAY

This is a nested data structure.

devices.endpointEnabled

ARRAY

This is a nested data structure.

devices.platform

ARRAY

This is a nested data structure.

devices.platformEndpoint

ARRAY

This is a nested data structure.

devices.token

ARRAY

This is a nested data structure.

email

STRING

emailListIds

ARRAY

This is a nested data structure.

estimatedSizing

STRING

experience

STRING

favoriteAnimal

STRING

favoriteCategories

OBJECT

This is a nested data structure.

ARRAY

This is a nested data structure.

favoriteCategories.category

ARRAY

This is a nested data structure.

favoriteCategory

STRING

favoriteCuisine

STRING

favoriteItem

STRING

favoriteProduct

STRING

favoriteRestaurant

STRING

favoriteShowCategories

STRING

favorite_category

STRING

favoritedShows

STRING

fb_follow

BOOLEAN

featuredDeal

STRING

firstName

STRING

gender

STRING

hasMobileApp

BOOLEAN

highestBidPrice

STRING

house Districts

STRING

industry

STRING

installedDropbox

BOOLEAN

installed_sync

BOOLEAN

interested_in_detergent

BOOLEAN

interested_in_soap

BOOLEAN

interested_in_toilet_paper

BOOLEAN

invoice

OBJECT

This is a nested data structure.

ARRAY

This is a nested data structure.

invoice.customAmount

ARRAY

This is a nested data structure.

invoice.customSubTotal

ARRAY

This is a nested data structure.

invoice.customerEmail

ARRAY

This is a nested data structure.

invoice.customerName

ARRAY

This is a nested data structure.

invoice.invoiceDate

ARRAY

This is a nested data structure.

invoice.invoiceNumber

ARRAY

This is a nested data structure.

invoice.merchantName

ARRAY

This is a nested data structure.

invoice.totalDue

ARRAY

This is a nested data structure.

is_active

BOOLEAN

is_available

BOOLEAN

itblInternal.emailDomain

STRING

jobRecommendations

OBJECT

This is a nested data structure.

ARRAY

This is a nested data structure.

jobRecommendations.applicationURL

ARRAY

This is a nested data structure.

jobRecommendations.description

ARRAY

This is a nested data structure.

jobRecommendations.id

ARRAY

This is a nested data structure.

jobRecommendations.imageUrl

ARRAY

This is a nested data structure.

jobRecommendations.name

ARRAY

This is a nested data structure.

job_categories_interested

STRING

job_title

STRING

lastAccessedAgent

STRING

lastKnownLatitude

NUMBER

lastKnownLongitude

NUMBER

lastName

STRING

lastOrderlocation

STRING

lastOrderrestaurant

STRING

last_game_played

STRING

last_purchased

STRING

last_purchased_category

STRING

last_session_date

DATE-TIME

level

INTEGER

lifetime Dontation

STRING

lifetime_Spent

STRING

locale

STRING

location

STRING

loyalty_member

BOOLEAN

loyalty_points

INTEGER

loyalty_program

BOOLEAN

major

STRING

marketSmith_subscription

BOOLEAN

merchantId

INTEGER

name

STRING

newListedVehicles

OBJECT

This is a nested data structure.

ARRAY

This is a nested data structure.

newListedVehicles.category

ARRAY

This is a nested data structure.

newListedVehicles.imageUrl

ARRAY

This is a nested data structure.

newListedVehicles.miles

ARRAY

This is a nested data structure.

newListedVehicles.name

ARRAY

This is a nested data structure.

newListedVehicles.noHagglePrice

ARRAY

This is a nested data structure.

newListedVehicles.price

ARRAY

This is a nested data structure.

newListedVehicles.sku

ARRAY

This is a nested data structure.

offers

OBJECT

This is a nested data structure.

ARRAY

This is a nested data structure.

offers.Intro APR

ARRAY

This is a nested data structure.

offers.categories

ARRAY

This is a nested data structure.

offers.description

ARRAY

This is a nested data structure.

offers.id

ARRAY

This is a nested data structure.

offers.imageUrl

ARRAY

This is a nested data structure.

offers.intro APR

ARRAY

This is a nested data structure.

offers.name

ARRAY

This is a nested data structure.

offers.quantity

ARRAY

This is a nested data structure.

offers.sku

ARRAY

This is a nested data structure.

offers.url

ARRAY

This is a nested data structure.

onboardingCohort

STRING

paid_user

BOOLEAN

passively_seeking

BOOLEAN

phoneNumber

STRING

phoneNumberDetails

OBJECT

This is a nested data structure.

ARRAY

This is a nested data structure.

phoneNumberDetails.carrier

ARRAY

This is a nested data structure.

phoneNumberDetails.countryCodeISO

ARRAY

This is a nested data structure.

phoneNumberDetails.lineType

ARRAY

This is a nested data structure.

phoneNumberDetails.updatedAt

ARRAY

This is a nested data structure.

profileUpdatedAt

DATE-TIME

promoCode

STRING

readingList

OBJECT

This is a nested data structure.

ARRAY

This is a nested data structure.

readingList.avgRating

ARRAY

This is a nested data structure.

readingList.bookAuthor

ARRAY

This is a nested data structure.

readingList.bookName

ARRAY

This is a nested data structure.

readingList.imageUrl

ARRAY

This is a nested data structure.

recommendedVehicles

OBJECT

This is a nested data structure.

ARRAY

This is a nested data structure.

recommendedVehicles.TrueCar Estimate

ARRAY

This is a nested data structure.

recommendedVehicles.category

ARRAY

This is a nested data structure.

recommendedVehicles.estimateDescription

ARRAY

This is a nested data structure.

recommendedVehicles.imageUrl

ARRAY

This is a nested data structure.

recommendedVehicles.name

ARRAY

This is a nested data structure.

recommendedVehicles.sku

ARRAY

This is a nested data structure.

region

STRING

sat

STRING

scheduled_ride

DATE-TIME

selected_games

STRING

senate Districts

STRING

shoppingCartItems

OBJECT

This is a nested data structure.

ARRAY

This is a nested data structure.

shoppingCartItems.categories

ARRAY

This is a nested data structure.

shoppingCartItems.description

ARRAY

This is a nested data structure.

shoppingCartItems.id

ARRAY

This is a nested data structure.

shoppingCartItems.imageUrl

ARRAY

This is a nested data structure.

shoppingCartItems.name

ARRAY

This is a nested data structure.

shoppingCartItems.price

ARRAY

This is a nested data structure.

shoppingCartItems.quantity

ARRAY

This is a nested data structure.

shoppingCartItems.sku

ARRAY

This is a nested data structure.

shoppingCartItems.url

ARRAY

This is a nested data structure.

shopppingCartTotal

INTEGER

should_receive_recommendation

BOOLEAN

signupDate

DATE-TIME

signupSource

STRING

state

STRING

streetAddress

STRING

swingTrader_subscription

BOOLEAN

tagline

STRING

timeZone

STRING

times donated

STRING

times_purchased

STRING

totalOrderCount

INTEGER

totalOrders

STRING

totalPurchases

INTEGER

totalSpent

NUMBER

total_playtime

INTEGER

type

STRING

university_interest

STRING

unsubscribedChannelIds

ARRAY

This is a nested data structure.

unsubscribedMessageTypeIds

ARRAY

This is a nested data structure.

uploaded_resume

BOOLEAN

userId

STRING

user_type

STRING

vegetarian_menu

OBJECT

This is a nested data structure.

ARRAY

This is a nested data structure.

vegetarian_menu.featured_item_availability

ARRAY

This is a nested data structure.

vegetarian_menu.featured_item_description

ARRAY

This is a nested data structure.

vegetarian_menu.featured_item_id

ARRAY

This is a nested data structure.

vegetarian_menu.featured_item_image_url

ARRAY

This is a nested data structure.

vegetarian_menu.featured_item_menu_availability

ARRAY

This is a nested data structure.

vegetarian_menu.featured_item_menu_date

ARRAY

This is a nested data structure.

vip

BOOLEAN

wishList

OBJECT

This is a nested data structure.

ARRAY

This is a nested data structure.

wishList.name

ARRAY

This is a nested data structure.

wishList.price

ARRAY

This is a nested data structure.

zip

STRING

Cette page vous a-t-elle aidé ?

Si vous rencontrez des problèmes sur cette page ou dans son contenu – une faute de frappe, une étape manquante ou une erreur technique – faites-le-nous savoir.

Laissez vos commentaires ici