# Iterable Core (v1) Information note **Iterable is in beta** Iterable is currently in beta. The info in this guide is subject to change. Information note **Iterable extraction is supported by Stitch** This integration is powered by [Singer's](https://www.singer.io/) Iterable tap and certified by Stitch. [Check out and contribute to the repo on GitHub](https://github.com/singer-io/tap-iterable). For support, contact [Support](https://community.qlik.com/t5/Support/ct-p/qlikSupport). ## Iterable integration summary Stitch’s Iterable integration replicates data using the [Iterable API 1.8](https://api.iterable.com/api). Refer to the [Schema](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#schema) section for a list of objects available for replication. ## Iterable feature snapshot A high-level look at Stitch's Iterable (v1) integration, including release status, useful links, and the features supported in Stitch. | **STITCH** | | | | | --- | --- | --- | --- | | **[Release status](https://help.qlik.com/en-US/stitch/integrations/identify-an-integration-version)** | Beta | **Supported by**

the Info icon

Indicates if the integration is supported by Stitch or the Singer community. | [Stitch](https://community.qlik.com/t5/Support/ct-p/qlikSupport) | | **Stitch plan**

the Info icon

The type of Stitch plan required to use the integration. | Standard | **[API availability](https://help.qlik.com/en-US/stitch/developers/stitch-connect/guides/source-destination-reference)**

the Info icon

Indicates if the integration is available as a source in Stitch Connect. | the Remove icon

This version of the integration isn't available via the API.


Not available | | **Singer GitHub repository** | [singer-io/tap-iterable](https://github.com/singer-io/tap-iterable) | | | | **REPLICATION SETTINGS** | | | | | **[Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling)**

the Info icon

A type of replication scheduling where an integration's Replication Frequency is anchored to a time you select. | the Success icon

This feature is supported for this version of the integration.


Supported | **[Advanced Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling)**

the Info icon

A type of replication scheduling that allows you to specify granular start times for data extraction using cron expressions. | the Success icon

This feature is supported for this version of the integration.


Supported | | **Table-level reset**

the Info icon

Indicates if data can be reset at the table level. If unsupported, data can only be reset at the integration level. | the Remove icon

Table-level resets are not supported for this integration. Resets are only supported at the integration level.


Unsupported | **[Configurable Replication Methods](https://help.qlik.com/en-US/stitch/replication/replication-methods)**

the Info icon

Indicates if Replication Methods can be defined by you for tables in the integration. | the Remove icon

Configurable Replication Methods are not supported for this integration. Stitch will use pre-defined replication methods for tables you set to replicate.


Unsupported | | **DATA SELECTION** | | | | | **Table selection**

the Info icon

The ability to select individual tables for replication in the Stitch interface. If table selection is unavailable, all tables and all the columns they contain will be set to replicate by default. | the Success icon

This feature is supported for this version of the integration.


Supported | **Column selection**

the Info icon

The ability to select individual columns for replication in the Stitch interface. If column selection is unavailable, all columns will be set to replicate by default. | the Success icon

This feature is supported for this version of the integration.


Supported | | **Select all**

the Info icon

Indicates if the integration supports selecting all available tables and columns. | the Success icon

Supported


Supported | | | | **TRANSPARENCY** | | | | | **[Extraction Logs](https://help.qlik.com/en-US/stitch/replication/extractions/integration-extraction-logs)**

the Info icon

Logs detailing the Extraction phase of the replication process for a given integration. Includes error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.


Supported | **[Loading Reports](https://help.qlik.com/en-US/stitch/replication/integration-loading-reports)**

the Info icon

Reports detailing the Loading phase of the replication process for a given integration. Includes the number of rows loaded for each table and error info, should an error occur. | the Success icon

This feature is supported for this version of the integration.


Supported | ## Connecting Iterable ### Iterable setup requirements To set up Iterable in Stitch, you need: * You must be an **org admin** or a user with **API and Webhook configuration permissions** in your Iterable account. ### Step 1: Generate an Iterable API key 1. Sign into you Iterable account. 2. Navigate to **Integrations**>**API Keys**. 3. Click **New API Key**. 4. In the **Create a new API key** window, name your API key and select **read-only**. 5. Click **Create**. 6. Copy your new API key and have it ready for the next step. ### Step 2: Add Iterable as a Stitch data source 1. [Sign into your Stitch account](https://app.stitchdata.com/). 2. On the Stitch Dashboard page, click the **Add Integration** button. 3. Click the **Iterable** icon. 4. Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your destination. For example, the name “Stitch Iterable” would create a schema called `stitch_iterable` in the destination. **Note**: Schema names cannot be changed after you save the integration. 5. In the **Iterable API Key** field, paste the API key you copied in [step 1](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#generate-api-key). 6. In the **API Window in Days** field, enter a value. 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. ### Step 3: Define the historical replication start date The Sync Historical Data setting defines the starting date for your Iterable integration. This means that data **equal to or newer than this date** will be replicated to your data warehouse. Change this setting if you want to replicate data beyond Iterable’s default setting of **1 year**. For a detailed look at historical replication jobs, check out the [Syncing Historical SaaS Data](https://help.qlik.com/en-US/stitch/replication/syncing-historical-saas-data-resetting-replication-keys) guide. ### Step 4: Create a replication schedule Information note Replication schedules affect the time Extraction begins, not the time to data loaded. Refer to the [Replication Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling) documentation for more information. In the **Replication Frequency** section, you’ll create the integration’s [replication schedule](https://help.qlik.com/en-US/stitch/replication/replication-scheduling). An integration’s replication schedule determines how often Stitch runs a replication job, and the time that job begins. Iterable integrations support the following replication scheduling methods: * [Replication Frequency](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/replication-frequency) * [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/anchor-scheduling) * [Advanced Scheduling using Cron](https://help.qlik.com/en-US/stitch/replication/replication-scheduling/advanced-scheduling) (Advanced or Premium plans only) To keep your row usage low, consider setting the integration to replicate less frequently. See the [Understanding and Reducing Your Row Usage guide](https://help.qlik.com/en-US/stitch/getting-started/understanding-stitch-usage) for tips on reducing your usage. ### Step 5: Set objects to replicate Information note **Is an object missing or not replicating?** Verify that the object meets the requirements for [selection](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#selection-requirements) and [replication](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#replication-requirements). The last step is to select the tables and columns you want to replicate. [Learn about the available tables for this integration.](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#schema) **Note**: If a replication job is currently in progress, new selections won’t be used until the next job starts. * Selection options * Individual tables and columns * All tables and columns For Iterable integrations, you can select: 1. **Individual tables and columns** 2. **All tables and columns** Click the tabs to view instructions for each selection method. 1. In the integration’s **Tables to Replicate tab**, locate a table you want to replicate. 2. To track a table, click the **checkbox** next to the table’s name. A blue checkmark means the table is set to replicate. 3. To track a column, click the **checkbox** next to the column’s name. A blue checkmark means the column is set to replicate. 4. Repeat this process for all the tables and columns you want to replicate. 5. When finished, click the **Finalize Your Selections** button at the bottom of the screen to save your selections. Information note **Important**: Using the **Select All** feature will overwrite any previous selections. However, selections aren’t final until **Finalize Your Selections** is clicked. Clicking **Cancel** will restore your previous selections. Refer to the [Select All guide](https://help.qlik.com/en-US/stitch/replication/extractions/data-selection/setting-tables-and-columns-to-replicate#set-all-data-to-replicate) for more info about this feature. 1. Click into the integration from the Stitch Dashboard page. 2. Click the **Tables to Replicate** tab. 3. In the list of tables, click the box next to the **Table Names** column. 4. In the menu that displays, click **Track all Tables and Fields**: ![The Track all Tables and Fields menu in the Tables to Replicate tab](https://help.qlik.com/en-US/stitch/images/replication/select-all-tables-menu.png)The Track all Tables and Fields menu in the Tables to Replicate tabThe Track all Tables and Fields menu in the Tables to Replicate tab 5. Click the **Finalize Your Selections** button at the bottom of the page to save your data selections. ### Initial and historical replication jobs After you finish setting up Iterable, its **Sync Status** may show as **Pending** on either the Stitch Dashboard or in the Integration Details page. For a new integration, a **Pending** status indicates that Stitch is in the process of scheduling the initial replication job for the integration. **This may take some time to complete.** Information note **Initial replication jobs with Anchor Scheduling** If using Anchor Scheduling, an initial replication job may not kick off immediately. This depends on the selected Replication Frequency and Anchor Time. Refer to the [Anchor Scheduling](https://help.qlik.com/en-US/stitch/replication/replication-scheduling#job-scheduling-and-anchor-times) documentation for more information. #### Free historical data loads The first seven days of replication, beginning when data is first replicated, are free. Rows replicated from the new integration during this time won’t count towards your quota. Stitch offers this as a way of testing new integrations, measuring usage, and ensuring historical data volumes don’t quickly consume your quota. Information note **Replication will continue after the seven days are over**. If you’re no longer interested in this source, be sure to **pause** or **delete** the integration to prevent unwanted usage. ## Iterable table reference Information note **Schemas and versioning** Schemas and naming conventions can change from version to version, so we recommend verifying your integration’s version before continuing. The schema and info displayed below is for **version 1** of this integration. Information note **Table and column names in your destination** Depending on your destination, table and column names may not appear as they are outlined below. For example: Object names are lowercased in Redshift (`CusTomERs` > `customers`), while case is maintained in PostgreSQL destinations (`CusTomERs` > `CusTomERs`). Refer to the [Loading Guide](https://help.qlik.com/en-US/stitch/replication/loading/destination-guides) for your destination for more info. ### campaigns The **campaigns** table contains information about campaigns in your Iterable projcect. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updatedAt | | **Useful links** | [campaigns schema on GitHub](https://github.com/singer-io/tap-iterable/tree/master/tap_iterable/schemas/campaigns.json "Opens in new tab: campaigns schema on GitHub")


[Iterable API method](https://api.iterable.com/api/docs#campaigns_campaigns "Opens in new tab: Iterable API method") | campaigns table foreign keys | Join campaigns with | on | | --- | --- | | [email_bounce](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-bounce) | ```
campaigns.id = email_bounce.campaignId
```

```
campaigns.templateId = email_bounce.templateId
``` | | [email_click](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-click) | ```
campaigns.id = email_click.campaignId
```

```
campaigns.templateId = email_click.templateId
``` | | [email_complaint](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-complaint) | ```
campaigns.id = email_complaint.campaignId
```

```
campaigns.templateId = email_complaint.templateId
``` | | [email_open](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-open) | ```
campaigns.id = email_open.campaignId
```

```
campaigns.templateId = email_open.templateId
``` | | [email_send](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-send) | ```
campaigns.id = email_send.campaignId
```

```
campaigns.templateId = email_send.templateId
``` | | [email_send_skip](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-send-skip) | ```
campaigns.id = email_send_skip.campaignId
```

```
campaigns.templateId = email_send_skip.templateId
``` | | [email_subscribe](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-subscribe) | ```
campaigns.id = email_subscribe.campaignId
```

```
campaigns.templateId = email_subscribe.templateId
``` | | [email_unsubscribe](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-unsubscribe) | ```
campaigns.id = email_unsubscribe.campaignId
```

```
campaigns.templateId = email_unsubscribe.templateId
``` | | [templates](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#templates) | ```
campaigns.id = templates.campaignId
```

```
campaigns.templateId = templates.templateId
``` | campaigns table schema | **campaignState**


STRING | | --- | | **createdAt**


DATE-TIME | | **createdByUserId**


STRING | | **endedAt**


DATE-TIME | | **id**


INTEGER | | **labels**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **listIds**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **messageMedium**


STRING | | **name**


STRING | | **recurringCampaignId**


INTEGER | | **sendSize**


NUMBER | | **startAt**


DATE-TIME | | **suppressionListIds**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [channels schema on GitHub](https://github.com/singer-io/tap-iterable/tree/master/tap_iterable/schemas/channels.json "Opens in new tab: channels schema on GitHub")


[Iterable API method](https://api.iterable.com/api/docs#channels_channels "Opens in new tab: Iterable API method") | channels table foreign keys | Join channels with | on | | --- | --- | | [email_send](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-send) | ```
channels.id = email_send.channelId
``` | | [email_send_skip](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-send-skip) | ```
channels.id = email_send_skip.channelId
``` | | [email_subscribe](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-subscribe) | ```
channels.id = email_subscribe.channelIds.items
``` | | [email_unsubscribe](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-unsubscribe) | ```
channels.id = email_unsubscribe.channelIds.items
```

```
channels.id = email_unsubscribe.channelId
``` | | [message_types](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#message-types) | ```
channels.id = message_types.channelId
``` | channels table schema | **channelType**


STRING | | --- | | **id**


INTEGER | | **messageMedium**


STRING | | **name**


STRING | ### email\_bounce The **email\_bounce** table contains information about bounced emails within your Iterable campaign. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | email | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | createdAt | | **Useful links** | [email_bounce schema on GitHub](https://github.com/singer-io/tap-iterable/tree/master/tap_iterable/schemas/email_bounce.json "Opens in new tab: email_bounce schema on GitHub")


[Iterable API method](https://api.iterable.com/api/docs#export_exportDataJson "Opens in new tab: Iterable API method") | email\_bounce table foreign keys | Join email\_bounce with | on | | --- | --- | | [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#campaigns) | ```
email_bounce.campaignId = campaigns.id
```

```
email_bounce.templateId = campaigns.templateId
``` | | [email_click](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-click) | ```
email_bounce.campaignId = email_click.campaignId
```

```
email_bounce.email = email_click.email
```

```
email_bounce.templateId = email_click.templateId
``` | | [email_complaint](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-complaint) | ```
email_bounce.campaignId = email_complaint.campaignId
```

```
email_bounce.email = email_complaint.email
```

```
email_bounce.templateId = email_complaint.templateId
``` | | [email_open](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-open) | ```
email_bounce.campaignId = email_open.campaignId
```

```
email_bounce.email = email_open.email
```

```
email_bounce.templateId = email_open.templateId
``` | | [email_send](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-send) | ```
email_bounce.campaignId = email_send.campaignId
```

```
email_bounce.email = email_send.email
```

```
email_bounce.templateId = email_send.templateId
``` | | [email_send_skip](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-subscribe) | ```
email_bounce.campaignId = email_subscribe.campaignId
```

```
email_bounce.email = email_subscribe.email
```

```
email_bounce.templateId = email_subscribe.templateId
``` | | [email_unsubscribe](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-unsubscribe) | ```
email_bounce.campaignId = email_unsubscribe.campaignId
```

```
email_bounce.email = email_unsubscribe.email
```

```
email_bounce.templateId = email_unsubscribe.templateId
``` | | [templates](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#templates) | ```
email_bounce.campaignId = templates.campaignId
```

```
email_bounce.templateId = templates.templateId
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#users) | ```
email_bounce.email = users.email
``` | | [list_users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#list-users) | ```
email_bounce.email = list_users.email
``` | email\_bounce table schema | **campaignId**


INTEGER | | --- | | **createdAt**


DATE-TIME | | **email**


STRING | | **eventName**


STRING | | **itblInternal**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand itblInternal

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | email | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | createdAt | | **Useful links** | [email_click schema on GitHub](https://github.com/singer-io/tap-iterable/tree/master/tap_iterable/schemas/email_click.json "Opens in new tab: email_click schema on GitHub")


[Iterable API method](https://api.iterable.com/api/docs#export_exportDataJson "Opens in new tab: Iterable API method") | email\_click table foreign keys | Join email\_click with | on | | --- | --- | | [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#campaigns) | ```
email_click.campaignId = campaigns.id
```

```
email_click.templateId = campaigns.templateId
``` | | [email_bounce](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-bounce) | ```
email_click.campaignId = email_bounce.campaignId
```

```
email_click.email = email_bounce.email
```

```
email_click.templateId = email_bounce.templateId
``` | | [email_complaint](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-complaint) | ```
email_click.campaignId = email_complaint.campaignId
```

```
email_click.email = email_complaint.email
```

```
email_click.templateId = email_complaint.templateId
``` | | [email_open](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-open) | ```
email_click.campaignId = email_open.campaignId
```

```
email_click.email = email_open.email
```

```
email_click.templateId = email_open.templateId
``` | | [email_send](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-send) | ```
email_click.campaignId = email_send.campaignId
```

```
email_click.email = email_send.email
```

```
email_click.templateId = email_send.templateId
``` | | [email_send_skip](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-subscribe) | ```
email_click.campaignId = email_subscribe.campaignId
```

```
email_click.email = email_subscribe.email
```

```
email_click.templateId = email_subscribe.templateId
``` | | [email_unsubscribe](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-unsubscribe) | ```
email_click.campaignId = email_unsubscribe.campaignId
```

```
email_click.email = email_unsubscribe.email
```

```
email_click.templateId = email_unsubscribe.templateId
``` | | [templates](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#templates) | ```
email_click.campaignId = templates.campaignId
```

```
email_click.templateId = templates.templateId
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#users) | ```
email_click.email = users.email
``` | | [list_users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#list-users) | ```
email_click.email = list_users.email
``` | email\_click table schema | **campaignId**


INTEGER | | --- | | **city**


STRING | | **contentId**


INTEGER | | **country**


STRING | | **createdAt**


DATE-TIME | | **email**


STRING | | **eventName**


STRING | | **hrefIndex**


INTEGER | | **ip**


STRING | | **itblInternal**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand itblInternal

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | email | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | createdAt | | **Useful links** | [email_complaint schema on GitHub](https://github.com/singer-io/tap-iterable/tree/master/tap_iterable/schemas/email_complaint.json "Opens in new tab: email_complaint schema on GitHub")


[Iterable API method](https://api.iterable.com/api/docs#export_exportDataJson "Opens in new tab: Iterable API method") | email\_complaint table foreign keys | Join email\_complaint with | on | | --- | --- | | [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#campaigns) | ```
email_complaint.campaignId = campaigns.id
```

```
email_complaint.templateId = campaigns.templateId
``` | | [email_bounce](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-bounce) | ```
email_complaint.campaignId = email_bounce.campaignId
```

```
email_complaint.email = email_bounce.email
```

```
email_complaint.templateId = email_bounce.templateId
``` | | [email_click](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-click) | ```
email_complaint.campaignId = email_click.campaignId
```

```
email_complaint.email = email_click.email
```

```
email_complaint.templateId = email_click.templateId
``` | | [email_open](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-open) | ```
email_complaint.campaignId = email_open.campaignId
```

```
email_complaint.email = email_open.email
```

```
email_complaint.templateId = email_open.templateId
``` | | [email_send](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-send) | ```
email_complaint.campaignId = email_send.campaignId
```

```
email_complaint.email = email_send.email
```

```
email_complaint.templateId = email_send.templateId
``` | | [email_send_skip](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-subscribe) | ```
email_complaint.campaignId = email_subscribe.campaignId
```

```
email_complaint.email = email_subscribe.email
```

```
email_complaint.templateId = email_subscribe.templateId
``` | | [email_unsubscribe](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-unsubscribe) | ```
email_complaint.campaignId = email_unsubscribe.campaignId
```

```
email_complaint.email = email_unsubscribe.email
```

```
email_complaint.templateId = email_unsubscribe.templateId
``` | | [templates](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#templates) | ```
email_complaint.campaignId = templates.campaignId
```

```
email_complaint.templateId = templates.templateId
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#users) | ```
email_complaint.email = users.email
``` | | [list_users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#list-users) | ```
email_complaint.email = list_users.email
``` | email\_complaint table schema | **campaignId**


INTEGER | | --- | | **createdAt**


DATE-TIME | | **email**


STRING | | **eventName**


STRING | | **itblInternal**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand itblInternal

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | email | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | createdAt | | **Useful links** | [email_open schema on GitHub](https://github.com/singer-io/tap-iterable/tree/master/tap_iterable/schemas/email_open.json "Opens in new tab: email_open schema on GitHub")


[Iterable API method](https://api.iterable.com/api/docs#export_exportDataJson "Opens in new tab: Iterable API method") | email\_open table foreign keys | Join email\_open with | on | | --- | --- | | [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#campaigns) | ```
email_open.campaignId = campaigns.id
```

```
email_open.templateId = campaigns.templateId
``` | | [email_bounce](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-bounce) | ```
email_open.campaignId = email_bounce.campaignId
```

```
email_open.email = email_bounce.email
```

```
email_open.templateId = email_bounce.templateId
``` | | [email_click](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-click) | ```
email_open.campaignId = email_click.campaignId
```

```
email_open.email = email_click.email
```

```
email_open.templateId = email_click.templateId
``` | | [email_complaint](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-complaint) | ```
email_open.campaignId = email_complaint.campaignId
```

```
email_open.email = email_complaint.email
```

```
email_open.templateId = email_complaint.templateId
``` | | [email_send](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-send) | ```
email_open.campaignId = email_send.campaignId
```

```
email_open.email = email_send.email
```

```
email_open.templateId = email_send.templateId
``` | | [email_send_skip](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-subscribe) | ```
email_open.campaignId = email_subscribe.campaignId
```

```
email_open.email = email_subscribe.email
```

```
email_open.templateId = email_subscribe.templateId
``` | | [email_unsubscribe](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-unsubscribe) | ```
email_open.campaignId = email_unsubscribe.campaignId
```

```
email_open.email = email_unsubscribe.email
```

```
email_open.templateId = email_unsubscribe.templateId
``` | | [templates](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#templates) | ```
email_open.campaignId = templates.campaignId
```

```
email_open.templateId = templates.templateId
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#users) | ```
email_open.email = users.email
``` | | [list_users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#list-users) | ```
email_open.email = list_users.email
``` | email\_open table schema | **campaignId**


INTEGER | | --- | | **city**


STRING | | **contentId**


INTEGER | | **country**


STRING | | **createdAt**


DATE-TIME | | **email**


STRING | | **eventName**


STRING | | **ip**


STRING | | **itblInternal**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand itblInternal

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | email | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | createdAt | | **Useful links** | [email_send schema on GitHub](https://github.com/singer-io/tap-iterable/tree/master/tap_iterable/schemas/email_send.json "Opens in new tab: email_send schema on GitHub")


[Iterable API method](https://api.iterable.com/api/docs#export_exportDataJson "Opens in new tab: Iterable API method") | email\_send table foreign keys | Join email\_send with | on | | --- | --- | | [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#campaigns) | ```
email_send.campaignId = campaigns.id
```

```
email_send.templateId = campaigns.templateId
``` | | [email_bounce](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-bounce) | ```
email_send.campaignId = email_bounce.campaignId
```

```
email_send.email = email_bounce.email
```

```
email_send.templateId = email_bounce.templateId
``` | | [email_click](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-click) | ```
email_send.campaignId = email_click.campaignId
```

```
email_send.email = email_click.email
```

```
email_send.templateId = email_click.templateId
``` | | [email_complaint](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-complaint) | ```
email_send.campaignId = email_complaint.campaignId
```

```
email_send.email = email_complaint.email
```

```
email_send.templateId = email_complaint.templateId
``` | | [email_open](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-open) | ```
email_send.campaignId = email_open.campaignId
```

```
email_send.email = email_open.email
```

```
email_send.templateId = email_open.templateId
``` | | [email_send_skip](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#templates) | ```
email_send.campaignId = templates.campaignId
```

```
email_send.templateId = templates.templateId
``` | | [channels](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#channels) | ```
email_send.channelId = channels.id
``` | | [message_types](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#message-types) | ```
email_send.channelId = message_types.channelId
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#users) | ```
email_send.email = users.email
``` | | [list_users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#list-users) | ```
email_send.email = list_users.email
``` | email\_send table schema | **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand itblInternal

documentCreatedAt

DATE-TIME

documentUpdatedAt

DATE-TIME

| | **messageBusId**


STRING | | **messageId**


STRING | | **messageTypeId**


INTEGER | | **productRecommendationCount**


INTEGER | | **templateId**


INTEGER | | **transactionalData**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand transactionalData

campaignId

INTEGER

categories

ARRAY

compare_at_price

NUMBER

createdAt

DATE-TIME

description

STRING

discount

INTEGER

email

STRING

eventName

STRING

eventUpdatedAt

DATE-TIME

handle

STRING

id

STRING

imageUrl

STRING

inventory

INTEGER

itblInternal

OBJECT

documentCreatedAt

DATE-TIME

documentUpdatedAt

DATE-TIME

name

STRING

price

INTEGER

product_id

STRING

product_type

STRING

sku

STRING

templateId

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | email | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | createdAt | | **Useful links** | [email_send_skip schema on GitHub](https://github.com/singer-io/tap-iterable/tree/master/tap_iterable/schemas/email_send_skip.json "Opens in new tab: email_send_skip schema on GitHub")


[Iterable API method](https://api.iterable.com/api/docs#export_exportDataJson "Opens in new tab: Iterable API method") | email\_send\_skip table foreign keys | Join email\_send\_skip with | on | | --- | --- | | [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#campaigns) | ```
email_send_skip.campaignId = campaigns.id
```

```
email_send_skip.templateId = campaigns.templateId
``` | | [email_bounce](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#templates) | ```
email_send_skip.campaignId = templates.campaignId
```

```
email_send_skip.templateId = templates.templateId
``` | | [channels](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#channels) | ```
email_send_skip.channelId = channels.id
``` | | [message_types](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#message-types) | ```
email_send_skip.channelId = message_types.channelId
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#users) | ```
email_send_skip.email = users.email
``` | | [list_users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#list-users) | ```
email_send_skip.email = list_users.email
``` | email\_send\_skip table schema | **campaignId**


INTEGER | | --- | | **channelId**


INTEGER | | **contentId**


INTEGER | | **createdAt**


DATE-TIME | | **email**


STRING | | **itblInternal**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand itblInternal

documentCreatedAt

DATE-TIME

documentUpdatedAt

DATE-TIME

| | **messageId**


STRING | | **messageTypeId**


INTEGER | | **reason**


STRING | | **templateId**


INTEGER | | **transactionalData**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand transactionalData

campaignId

INTEGER

categories

ARRAY

compare_at_price

NUMBER

createdAt

DATE-TIME

description

STRING

discount

INTEGER

email

STRING

eventName

STRING

eventUpdatedAt

DATE-TIME

handle

STRING

id

STRING

imageUrl

STRING

inventory

INTEGER

itblInternal

OBJECT

documentCreatedAt

DATE-TIME

documentUpdatedAt

DATE-TIME

name

STRING

price

INTEGER

product_id

STRING

product_type

STRING

sku

STRING

templateId

INTEGER

url

STRING

vendor

STRING

| ### email\_subscribe The **email\_subscribe** table contains information about emails subscribed to your Iterable campaign. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | email | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | createdAt | | **Useful links** | [email_subscribe schema on GitHub](https://github.com/singer-io/tap-iterable/tree/master/tap_iterable/schemas/email_subscribe.json "Opens in new tab: email_subscribe schema on GitHub")


[Iterable API method](https://api.iterable.com/api/docs#export_exportDataJson "Opens in new tab: Iterable API method") | email\_subscribe table foreign keys | Join email\_subscribe with | on | | --- | --- | | [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#campaigns) | ```
email_subscribe.campaignId = campaigns.id
```

```
email_subscribe.templateId = campaigns.templateId
``` | | [email_bounce](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-bounce) | ```
email_subscribe.campaignId = email_bounce.campaignId
```

```
email_subscribe.email = email_bounce.email
```

```
email_subscribe.templateId = email_bounce.templateId
``` | | [email_click](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-click) | ```
email_subscribe.campaignId = email_click.campaignId
```

```
email_subscribe.email = email_click.email
```

```
email_subscribe.templateId = email_click.templateId
``` | | [email_complaint](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-complaint) | ```
email_subscribe.campaignId = email_complaint.campaignId
```

```
email_subscribe.email = email_complaint.email
```

```
email_subscribe.templateId = email_complaint.templateId
``` | | [email_open](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-open) | ```
email_subscribe.campaignId = email_open.campaignId
```

```
email_subscribe.email = email_open.email
```

```
email_subscribe.templateId = email_open.templateId
``` | | [email_send](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#templates) | ```
email_subscribe.campaignId = templates.campaignId
```

```
email_subscribe.templateId = templates.templateId
``` | | [channels](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#channels) | ```
email_subscribe.channelIds.items = channels.id
``` | | [message_types](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#message-types) | ```
email_subscribe.channelIds.items = message_types.channelId
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#users) | ```
email_subscribe.email = users.email
``` | | [list_users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#list-users) | ```
email_subscribe.email = list_users.email
``` | email\_subscribe table schema | **campaignId**


INTEGER | | --- | | **channelIds**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **createdAt**


DATE-TIME | | **email**


STRING | | **emailListId**


INTEGER | | **emailListIds**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **eventName**


STRING | | **itblInternal**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand itblInternal

documentCreatedAt

DATE-TIME

documentUpdatedAt

DATE-TIME

| | **profileUpdatedAt**


DATE-TIME | | **signupSource**


STRING | | **templateId**


INTEGER | | **userId**


STRING | | **workflowId**


INTEGER | ### email\_unsubscribe The **email\_unsubscribe** table contains information about emails unsubscribed from your Iterable campaign. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | email | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | createdAt | | **Useful links** | [email_unsubscribe schema on GitHub](https://github.com/singer-io/tap-iterable/tree/master/tap_iterable/schemas/email_unsubscribe.json "Opens in new tab: email_unsubscribe schema on GitHub")


[Iterable API method](https://api.iterable.com/api/docs#export_exportDataJson "Opens in new tab: Iterable API method") | email\_unsubscribe table foreign keys | Join email\_unsubscribe with | on | | --- | --- | | [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#campaigns) | ```
email_unsubscribe.campaignId = campaigns.id
```

```
email_unsubscribe.templateId = campaigns.templateId
``` | | [email_bounce](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-bounce) | ```
email_unsubscribe.campaignId = email_bounce.campaignId
```

```
email_unsubscribe.email = email_bounce.email
```

```
email_unsubscribe.templateId = email_bounce.templateId
``` | | [email_click](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-click) | ```
email_unsubscribe.campaignId = email_click.campaignId
```

```
email_unsubscribe.email = email_click.email
```

```
email_unsubscribe.templateId = email_click.templateId
``` | | [email_complaint](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-complaint) | ```
email_unsubscribe.campaignId = email_complaint.campaignId
```

```
email_unsubscribe.email = email_complaint.email
```

```
email_unsubscribe.templateId = email_complaint.templateId
``` | | [email_open](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-open) | ```
email_unsubscribe.campaignId = email_open.campaignId
```

```
email_unsubscribe.email = email_open.email
```

```
email_unsubscribe.templateId = email_open.templateId
``` | | [email_send](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#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](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#templates) | ```
email_unsubscribe.campaignId = templates.campaignId
```

```
email_unsubscribe.templateId = templates.templateId
``` | | [channels](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#channels) | ```
email_unsubscribe.channelIds.items = channels.id
```

```
email_unsubscribe.channelId = channels.id
``` | | [message_types](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#message-types) | ```
email_unsubscribe.channelIds.items = message_types.channelId
```

```
email_unsubscribe.channelId = message_types.channelId
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#users) | ```
email_unsubscribe.email = users.email
``` | | [list_users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#list-users) | ```
email_unsubscribe.email = list_users.email
``` | email\_unsubscribe table schema | **bounceMessage**


STRING | | --- | | **campaignId**


INTEGER | | **channelId**


INTEGER | | **channelIds**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **createdAt**


DATE-TIME | | **email**


STRING | | **emailListId**


INTEGER | | **emailListIds**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **eventName**


STRING | | **itblInternal**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand itblInternal

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Keys ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | email

listId | | **Useful links** | [list_users schema on GitHub](https://github.com/singer-io/tap-iterable/tree/master/tap_iterable/schemas/list_users.json "Opens in new tab: list_users schema on GitHub")


[Iterable API method](https://api.iterable.com/api/docs#lists_getLists_0 "Opens in new tab: Iterable API method") | list\_users table foreign keys | Join list\_users with | on | | --- | --- | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#users) | ```
list_users.email = users.email
``` | | [email_bounce](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-bounce) | ```
list_users.email = email_bounce.email
``` | | [email_click](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-click) | ```
list_users.email = email_click.email
``` | | [email_complaint](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-complaint) | ```
list_users.email = email_complaint.email
``` | | [email_open](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-open) | ```
list_users.email = email_open.email
``` | | [email_send](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-send) | ```
list_users.email = email_send.email
``` | | [email_send_skip](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-send-skip) | ```
list_users.email = email_send_skip.email
``` | | [email_subscribe](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-subscribe) | ```
list_users.email = email_subscribe.email
``` | | [email_unsubscribe](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-unsubscribe) | ```
list_users.email = email_unsubscribe.email
``` | | [lists](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#lists) | ```
list_users.listId = lists.id
``` | list\_users table schema | **email**


STRING | | --- | | **listId**


INTEGER | | **updatedAt**


DATE-TIME | ### lists The **lists** tablecontains information about lists within your Iterable project. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [lists schema on GitHub](https://github.com/singer-io/tap-iterable/tree/master/tap_iterable/schemas/lists.json "Opens in new tab: lists schema on GitHub")


[Iterable API method](https://api.iterable.com/api/docs#lists_getLists "Opens in new tab: Iterable API method") | lists table foreign keys | Join lists with | on | | --- | --- | | [list_users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#list-users) | ```
lists.id = list_users.listId
``` | lists table schema | **createdAt**


DATE-TIME | | --- | | **description**


STRING | | **id**


INTEGER | | **listType**


STRING | | **name**


STRING | ### message\_types The **message\_types** table contains information about all message types within your Iterable project. | **Replication Method [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | id | | **Useful links** | [message_types schema on GitHub](https://github.com/singer-io/tap-iterable/tree/master/tap_iterable/schemas/message_types.json "Opens in new tab: message_types schema on GitHub")


[Iterable API method](https://api.iterable.com/api/docs#messageTypes_messageTypes "Opens in new tab: Iterable API method") | message\_types table foreign keys | Join message\_types with | on | | --- | --- | | [channels](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#channels) | ```
message_types.channelId = channels.id
``` | | [email_send](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-send) | ```
message_types.channelId = email_send.channelId
``` | | [email_send_skip](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-send-skip) | ```
message_types.channelId = email_send_skip.channelId
``` | | [email_subscribe](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-subscribe) | ```
message_types.channelId = email_subscribe.channelIds.items
``` | | [email_unsubscribe](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-unsubscribe) | ```
message_types.channelId = email_unsubscribe.channelIds.items
```

```
message_types.channelId = email_unsubscribe.channelId
``` | | [templates](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#templates) | ```
message_types.id = templates.messageTypeId
``` | message\_types table schema | **channelId**


INTEGER | | --- | | **createdAt**


DATE-TIME | | **id**


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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Full Table | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | key | | **Useful links** | [metadata schema on GitHub](https://github.com/singer-io/tap-iterable/tree/master/tap_iterable/schemas/metadata.json "Opens in new tab: metadata schema on GitHub")


[Iterable API method](https://api.iterable.com/api/docs#metadata_get "Opens in new tab: Iterable API method") | metadata table schema | **key**


STRING | | --- | | **lastModified**


DATE-TIME | | **size**


INTEGER | | **table**


STRING | | **value**


OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

Click to expand value

categories

ARRAY

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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | templateId | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | updatedAt | | **Useful links** | [templates schema on GitHub](https://github.com/singer-io/tap-iterable/tree/master/tap_iterable/schemas/templates.json "Opens in new tab: templates schema on GitHub")


[Iterable API method](https://api.iterable.com/api/docs#templates_getTemplates "Opens in new tab: Iterable API method") | templates table foreign keys | Join templates with | on | | --- | --- | | [campaigns](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#campaigns) | ```
templates.campaignId = campaigns.id
```

```
templates.templateId = campaigns.templateId
``` | | [email_bounce](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-bounce) | ```
templates.campaignId = email_bounce.campaignId
```

```
templates.templateId = email_bounce.templateId
``` | | [email_click](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-click) | ```
templates.campaignId = email_click.campaignId
```

```
templates.templateId = email_click.templateId
``` | | [email_complaint](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-complaint) | ```
templates.campaignId = email_complaint.campaignId
```

```
templates.templateId = email_complaint.templateId
``` | | [email_open](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-open) | ```
templates.campaignId = email_open.campaignId
```

```
templates.templateId = email_open.templateId
``` | | [email_send](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-send) | ```
templates.campaignId = email_send.campaignId
```

```
templates.templateId = email_send.templateId
``` | | [email_send_skip](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-send-skip) | ```
templates.campaignId = email_send_skip.campaignId
```

```
templates.templateId = email_send_skip.templateId
``` | | [email_subscribe](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-subscribe) | ```
templates.campaignId = email_subscribe.campaignId
```

```
templates.templateId = email_subscribe.templateId
``` | | [email_unsubscribe](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-unsubscribe) | ```
templates.campaignId = email_unsubscribe.campaignId
```

```
templates.templateId = email_unsubscribe.templateId
``` | | [message_types](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#message-types) | ```
templates.messageTypeId = message_types.id
``` | templates table schema | **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 [](https://help.qlik.com/en-US/stitch/replication/replication-methods)[the Info icon](https://help.qlik.com/en-US/stitch/replication/replication-methods)[](https://help.qlik.com/en-US/stitch/replication/replication-methods)** | Key-based Incremental | | --- | --- | | **Primary Key ![](https://help.qlik.com/en-US/stitch/images/replication/primary-key-icon.svg)** | email | | **Replication Key ![](https://help.qlik.com/en-US/stitch/images/replication/replication-key-icon.svg)** | profileUpdatedAt | | **Useful links** | [Iterable documentation](https://api.iterable.com/api/docs#export_exportDataJson "Opens in new tab: Iterable documentation")


[users schema on GitHub](https://github.com/singer-io/tap-iterable/tree/master/tap_iterable/schemas/users.json "Opens in new tab: users schema on GitHub")


[Iterable API method](ttps://api.iterable.com/api/docs#export_exportDataJson "Opens in new tab: Iterable API method") | users table foreign keys | Join users with | on | | --- | --- | | [email_bounce](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-bounce) | ```
users.email = email_bounce.email
``` | | [email_click](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-click) | ```
users.email = email_click.email
``` | | [email_complaint](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-complaint) | ```
users.email = email_complaint.email
``` | | [email_open](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-open) | ```
users.email = email_open.email
``` | | [email_send](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-send) | ```
users.email = email_send.email
``` | | [email_send_skip](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-send-skip) | ```
users.email = email_send_skip.email
``` | | [email_subscribe](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-subscribe) | ```
users.email = email_subscribe.email
``` | | [email_unsubscribe](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#email-unsubscribe) | ```
users.email = email_unsubscribe.email
``` | | [list_users](https://help.qlik.com/en-US/stitch/integrations/saas/iterable-core/v1#list-users) | ```
users.email = list_users.email
``` | users table schema | **CCProvider**


STRING | | --- | | **Industry**


STRING | | **accessIp**


STRING | | **acquisition\_source**


STRING | | **actively\_seeking**


BOOLEAN | | **age**


INTEGER | | **auctionDigest**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **auctionDigest.auctionDateLocation**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **auctionDigest.auctionHouse**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **auctionDigest.auctionImageUrl**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **auctionDigest.auctionInfo**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **auctionDigest.name**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **devices.applicationName**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **devices.endpointEnabled**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **devices.platform**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **devices.platformEndpoint**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **devices.token**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **email**


STRING | | **emailListIds**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **estimatedSizing**


STRING | | **experience**


STRING | | **favoriteAnimal**


STRING | | **favoriteCategories**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **favoriteCategories.category**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **invoice.customAmount**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **invoice.customSubTotal**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **invoice.customerEmail**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **invoice.customerName**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **invoice.invoiceDate**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **invoice.invoiceNumber**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **invoice.merchantName**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **invoice.totalDue**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **is\_active**


BOOLEAN | | **is\_available**


BOOLEAN | | **itblInternal.emailDomain**


STRING | | **jobRecommendations**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **jobRecommendations.applicationURL**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **jobRecommendations.description**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **jobRecommendations.id**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **jobRecommendations.imageUrl**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **jobRecommendations.name**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **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. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **newListedVehicles.category**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **newListedVehicles.imageUrl**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **newListedVehicles.miles**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **newListedVehicles.name**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **newListedVehicles.noHagglePrice**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **newListedVehicles.price**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **newListedVehicles.sku**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **offers**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **offers.Intro APR**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **offers.categories**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **offers.description**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **offers.id**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **offers.imageUrl**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **offers.intro APR**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **offers.name**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **offers.quantity**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **offers.sku**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **offers.url**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **onboardingCohort**


STRING | | **paid\_user**


BOOLEAN | | **passively\_seeking**


BOOLEAN | | **phoneNumber**


STRING | | **phoneNumberDetails**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **phoneNumberDetails.carrier**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **phoneNumberDetails.countryCodeISO**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **phoneNumberDetails.lineType**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **phoneNumberDetails.updatedAt**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **profileUpdatedAt**


DATE-TIME | | **promoCode**


STRING | | **readingList**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **readingList.avgRating**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **readingList.bookAuthor**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **readingList.bookName**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **readingList.imageUrl**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **recommendedVehicles**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **recommendedVehicles.TrueCar Estimate**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **recommendedVehicles.category**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **recommendedVehicles.estimateDescription**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **recommendedVehicles.imageUrl**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **recommendedVehicles.name**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **recommendedVehicles.sku**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **region**


STRING | | **sat**


STRING | | **scheduled\_ride**


DATE-TIME | | **selected\_games**


STRING | | **senate Districts**


STRING | | **shoppingCartItems**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **shoppingCartItems.categories**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **shoppingCartItems.description**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **shoppingCartItems.id**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **shoppingCartItems.imageUrl**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **shoppingCartItems.name**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **shoppingCartItems.price**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **shoppingCartItems.quantity**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **shoppingCartItems.sku**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **shoppingCartItems.url**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **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. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **unsubscribedMessageTypeIds**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **uploaded\_resume**


BOOLEAN | | **userId**


STRING | | **user\_type**


STRING | | **vegetarian\_menu**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **vegetarian\_menu.featured\_item\_availability**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **vegetarian\_menu.featured\_item\_description**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **vegetarian\_menu.featured\_item\_id**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **vegetarian\_menu.featured\_item\_image\_url**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **vegetarian\_menu.featured\_item\_menu\_availability**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **vegetarian\_menu.featured\_item\_menu\_date**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **vip**


BOOLEAN | | **wishList**

OBJECT

This is a nested data structure. If your destination doesn't natively support nested data, attributes in this object will be flattened into the table. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>.

ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **wishList.name**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **wishList.price**


ARRAY

This is a nested data structure. If your destination doesn't natively support nested data, attributes will be denested into a subtable. <a href='/en-US/stitch/replication/loading/understanding-loading-row-usage-for-nested-data-structures' target='new'>Learn more</a>. | | **zip**


STRING |