# Intercom (v02-02-2016) Information note **Intercom (v02-02-2016) end of life** This version of Intercom reached end of life on **January 31, 2021** and is no longer functioning. [Upgrade to the latest version (v2) to continue replicating data.](https://help.qlik.com/en-US/stitch/integrations/saas/intercom) ## Intercom integration summary Stitch’s Intercom integration replicates data using the [Intercom REST API (V1.0)](https://developers.intercom.com/intercom-api-reference/v1.0/reference). Refer to the [Schema](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#schema) section for a list of objects available for replication. ## Intercom feature snapshot A high-level look at Stitch's Intercom (v02-02-2016) 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)** | Sunset on January 31, 2021 | **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** | Not applicable | | | | **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 Remove icon

Advanced Scheduling is not supported for this integration.

Unsupported | | **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 Remove icon

Table selection is not supported for this integration. All available table and fields will be automatically selected for replication.

Unsupported | **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 Remove icon

Column selection is not supported for this integration. All available columns in tables set to replicate will be selected.

Unsupported | | **Select all**

the Info icon

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

As this integration doesn't support table or column selection, all available tables and columns are automatically replicated.

Unsupported | | | | **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 Remove icon

This feature is not supported for this version of the integration.

Unsupported | **[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 | ## Intercom replication ### Intercom Replication and Attribution Windows Every time Stitch runs a replication job for Intercom, the last 30 days’ worth of data will be replicated. This is applicable to all tables in the integration. Stitch replicates data in this way to account for updates made to existing records within the default attribution window of 30 days, thus ensuring you won’t make decisions based on stale (or false) data. **As a result, you may see a higher number of replicated rows than what’s being generated in Intercom**. Setting the Replication Frequency to a higher frequency - like 30 minutes - can result in re-replicating recent data and contribute to greater row usage. Selecting a lower frequency can help keep your row count low. ## Intercom 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 02-02-2016** 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. ### admins The `admins` table contains info about the admins and teams in your Intercom 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)** | id | | **Useful links** | [Intercom documentation](https://developers.intercom.io/docs/admins "Opens in new tab: Intercom documentation")

[Intercom API method](https://developers.intercom.io/docs/list-admins "Opens in new tab: Intercom API method") | admins table foreign keys | Join admins with | on | | --- | --- | | [conversations](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#conversations) | ```
admins.id = conversations.conversation_parts.assigned_to
```

```
admins.id = conversations.assignee.id
```

```
admins.id = conversations.conversation_parts.author.id
``` | | [contacts](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#contacts) | ```
admins.id = contacts.id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#users) | ```
admins.id = users.id
``` | admins table schema | **away\_mode\_enabled**

BOOLEAN | | --- | | **away\_mode\_reassign**

BOOLEAN | | **email**

STRING | | **id**

STRING | | **name**

STRING | | **team\_ids**

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>.

Click to expand team\_ids

value

INTEGER

| | **type**

STRING | ### companies The `companies` table contains info about the companies (or commercial organizations) that use your Intercom product. #### Custom Attributes If applicable, Stitch will replicate custom fields related to `companies` in Intercom. | **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)** | updated\_at | | **Useful links** | [Intercom documentation](https://developers.intercom.com/reference#companies "Opens in new tab: Intercom documentation")

[Intercom API method](https://developers.intercom.com/reference#iterating-over-all-companies "Opens in new tab: Intercom API method") | companies table foreign keys | Join companies with | on | | --- | --- | | [contacts](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#contacts) | ```
companies.id = contacts.companies.id
```

```
companies.segments.segments.id = contacts.segments.segments.id
```

```
companies.tags.tags.id = contacts.tags.tags.id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#users) | ```
companies.id = users.companies.id
```

```
companies.segments.segments.id = users.segments.segments.id
```

```
companies.tags.tags.id = users.tags.tags.id
``` | | [segments](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#segments) | ```
companies.segments.segments.id = segments.id
``` | | [conversations](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#conversations) | ```
companies.tags.tags.id = conversations.tags.tags.id
``` | | [tags](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#tags) | ```
companies.tags.tags.id = tags.id
``` | companies table schema | **company\_id**

STRING | | --- | | **created\_at**

DATE-TIME | | **custom\_attributes**

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>. | | **id**

STRING | | **monthly\_spend**

NUMBER | | **name**

STRING | | **plan**

STRING | | **remote\_created\_at**

DATE-TIME | | **segments**

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>.

Click to expand segments

segments

ARRAY

STRING

type

STRING

| | **session\_count**

INTEGER | | **tags**

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>.

Click to expand tags

tags

ARRAY

STRING

type

STRING

| | **type**

STRING | | **updated\_at**

DATE-TIME | | **user\_count**

NUMBER | ### company\_segments The `company_segments` table contains info about company segments. A segment is a group of users that are defined by a set of rules. | **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** | [Intercom documentation](https://developers.intercom.io/docs/companies "Opens in new tab: Intercom documentation")

[Intercom API method](https://developers.intercom.io/docs/list-segments "Opens in new tab: Intercom API method") | company\_segments table foreign keys | Join company\_segments with | on | | --- | --- | | [contacts](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#contacts) | ```
company_segments.id = contacts.segments.id
``` | company\_segments table schema | **created\_at**

DATE-TIME | | --- | | **id**

STRING | | **name**

STRING | | **person\_type**

STRING | | **type**

STRING | | **updated\_at**

DATE-TIME | ### contacts The `contacts` table contains info about the logged-out users, or leads, of your Intercom app. **Note**: `contacts` is equivalent to the `leads` object in Intercom’s API. See [Intercom’s documentation](https://developers.intercom.com/reference#leads) for more info. #### Custom Attributes If applicable, Stitch will replicate custom fields related to `contacts` (leads) in Intercom. | **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)** | updated\_at | | **Useful links** | [Intercom documentation](https://developers.intercom.com/reference#leads "Opens in new tab: Intercom documentation")

[Intercom API method](https://developers.intercom.com/reference#list-leads "Opens in new tab: Intercom API method") | contacts table foreign keys | Join contacts with | on | | --- | --- | | [admins](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#admins) | ```
contacts.id = admins.id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#users) | ```
contacts.id = users.id
```

```
contacts.companies.id = users.companies.id
```

```
contacts.segments.segments.id = users.segments.segments.id
```

```
contacts.tags.tags.id = users.tags.tags.id
``` | | [conversations](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#conversations) | ```
contacts.id = conversations.conversation_parts.author.id
```

```
contacts.id = conversations.user.id
```

```
contacts.tags.tags.id = conversations.tags.tags.id
```

```
contacts.id = conversations.customers.id
``` | | [companies](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#companies) | ```
contacts.companies.id = companies.id
```

```
contacts.segments.segments.id = companies.segments.segments.id
```

```
contacts.tags.tags.id = companies.tags.tags.id
``` | | [company_segments](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#company-segments) | ```
contacts.segments.id = company_segments.id
``` | | [segments](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#segments) | ```
contacts.segments.segments.id = segments.id
``` | | [tags](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#tags) | ```
contacts.tags.tags.id = tags.id
``` | contacts table schema | **avatar**

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 avatar

image_url

STRING

type

STRING

| | --- | | **companies**

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>.

Click to expand companies

companies

ARRAY

company_id

STRING

name

STRING

type

STRING

| | **created\_at**

DATE-TIME | | **email**

STRING | | **id**

STRING | | **last\_request\_at**

DATE-TIME | | **last\_seen\_ip**

STRING | | **location\_data**

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 location\_data

city_name

STRING

continent_code

STRING

country_code

STRING

country_name

STRING

latitude

INTEGER

longitude

INTEGER

postal_code

STRING

region_name

STRING

timezone

STRING

type

STRING

| | **name**

STRING | | **phone**

STRING | | **segments**

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>.

Click to expand segments

segments

ARRAY

STRING

type

STRING

| | **social\_profiles**

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>.

Click to expand social\_profiles

social_profiles

ARRAY

STRING

name

STRING

type

STRING

url

STRING

username

STRING

| | **tags**

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>.

Click to expand tags

tags

ARRAY

STRING

name

STRING

type

STRING

| | **unsubscribed\_from\_emails**

BOOLEAN | | **updated\_at**

DATE-TIME | | **user\_agent\_data**

STRING | | **user\_id**

STRING | ### conversations The `conversations` table contains info about user conversations, or conversations initiated by your end-users. #### Conversation Parts To reconstruct an entire conversation, use the `conversation_parts` associated with the conversation. These are the individual elements - actions, messages, and so on - that make up a conversation. If your destination doesn’t natively support nested data structures, a subtable named `conversations__conversation_parts` will be created. More info on this table can be found below. | **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)** | updated\_at | | **Useful links** | [Intercom documentation](https://developers.intercom.com/reference#conversations "Opens in new tab: Intercom documentation")

[Intercom API method](https://developers.intercom.io/docs/list-conversations "Opens in new tab: Intercom API method") | conversations table foreign keys | Join conversations with | on | | --- | --- | | [admins](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#admins) | ```
conversations.conversation_parts.assigned_to = admins.id
```

```
conversations.assignee.id = admins.id
```

```
conversations.conversation_parts.author.id = admins.id
``` | | [contacts](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#contacts) | ```
conversations.conversation_parts.author.id = contacts.id
```

```
conversations.user.id = contacts.id
```

```
conversations.tags.tags.id = contacts.tags.tags.id
```

```
conversations.customers.id = contacts.id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#users) | ```
conversations.conversation_parts.author.id = users.id
```

```
conversations.tags.tags.id = users.tags.tags.id
```

```
conversations.user.id = users.id
```

```
conversations.customers.id = users.id
``` | | [companies](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#companies) | ```
conversations.tags.tags.id = companies.tags.tags.id
``` | | [tags](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#tags) | ```
conversations.tags.tags.id = tags.id
``` | conversations table schema | **assignee**

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 assignee

STRING

type

STRING

| | --- | | **conversation\_message**

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 conversation\_message

attachments

ARRAY

content_type

STRING

filesize

INTEGER

height

INTEGER

name

STRING

type

STRING

url

STRING

width

INTEGER

author

OBJECT

STRING

type

STRING

body

STRING

subject

STRING

type

STRING

| | **conversation\_parts**

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>.

Click to expand conversation\_parts

assigned_to

STRING

attachments

ARRAY

content_type

STRING

filesize

INTEGER

height

INTEGER

name

STRING

type

STRING

url

STRING

width

INTEGER

author

OBJECT

STRING

type

STRING

body

STRING

created_at

DATE-TIME

STRING

part_type

STRING

updated_at

DATE-TIME

| | **created\_at**

DATE-TIME | | **customers**

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>.

Click to expand customers

STRING

type

STRING

| | **id**

STRING | | **open**

BOOLEAN | | **read**

BOOLEAN | | **snoozed\_until**

DATE-TIME | | **state**

STRING | | **tags**

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>.

Click to expand tags

tags

ARRAY

STRING

name

STRING

type

STRING

| | **total\_count**

INTEGER | | **type**

STRING | | **updated\_at**

DATE-TIME | | **user**

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 user

STRING

type

STRING

| | **waiting\_since**

DATE-TIME | ### segments The `segments` table contains info about the segments - or groups of users defined by a set of rules - in your Intercom 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)** | id | | **Useful links** | [Intercom documentation](https://developers.intercom.com/reference#segments "Opens in new tab: Intercom documentation")

[Intercom API method](https://developers.intercom.io/docs/list-segments "Opens in new tab: Intercom API method") | segments table foreign keys | Join segments with | on | | --- | --- | | [companies](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#companies) | ```
segments.id = companies.segments.segments.id
``` | | [contacts](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#contacts) | ```
segments.id = contacts.segments.segments.id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#users) | ```
segments.id = users.segments.segments.id
``` | segments table schema | **created\_at**

DATE-TIME | | --- | | **id**

STRING | | **name**

STRING | | **person\_type**

STRING | | **type**

STRING | | **updated\_at**

DATE-TIME | ### tags The `tags` table contains info about the tags in your Intercom 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)** | id | | **Useful links** | [Intercom documentation](https://developers.intercom.io/docs/tags "Opens in new tab: Intercom documentation")

[Intercom API method](https://developers.intercom.io/docs/list-tags "Opens in new tab: Intercom API method") | tags table foreign keys | Join tags with | on | | --- | --- | | [companies](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#companies) | ```
tags.id = companies.tags.tags.id
``` | | [contacts](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#contacts) | ```
tags.id = contacts.tags.tags.id
``` | | [conversations](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#conversations) | ```
tags.id = conversations.tags.tags.id
``` | | [users](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#users) | ```
tags.id = users.tags.tags.id
``` | tags table schema | **id**

STRING | | --- | | **name**

STRING | | **type**

STRING | ### users The `users` table contains info about the users in your Intercom account. #### Custom Attributes If applicable, Stitch will replicate custom fields related to `users` in Intercom. | **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)** | updated\_at | | **Useful links** | [Intercom documentation](https://developers.intercom.io/docs/users "Opens in new tab: Intercom documentation")

[Intercom API method](https://developers.intercom.com/intercom-api-reference/reference#list-users "Opens in new tab: Intercom API method") | users table foreign keys | Join users with | on | | --- | --- | | [admins](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#admins) | ```
users.id = admins.id
``` | | [contacts](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#contacts) | ```
users.id = contacts.id
```

```
users.companies.id = contacts.companies.id
```

```
users.segments.segments.id = contacts.segments.segments.id
```

```
users.tags.tags.id = contacts.tags.tags.id
``` | | [conversations](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#conversations) | ```
users.id = conversations.conversation_parts.author.id
```

```
users.tags.tags.id = conversations.tags.tags.id
```

```
users.id = conversations.user.id
```

```
users.id = conversations.customers.id
``` | | [companies](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#companies) | ```
users.companies.id = companies.id
```

```
users.segments.segments.id = companies.segments.segments.id
```

```
users.tags.tags.id = companies.tags.tags.id
``` | | [segments](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#segments) | ```
users.segments.segments.id = segments.id
``` | | [tags](https://help.qlik.com/en-US/stitch/integrations/saas/intercom/v02-02-2016#tags) | ```
users.tags.tags.id = tags.id
``` | users table schema | **anonymous**

BOOLEAN | | --- | | **avatar**

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 avatar

image_url

STRING

type

STRING

| | **companies**

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>.

Click to expand companies

companies

ARRAY

company_id

STRING

name

STRING

type

STRING

city_name

STRING

continent_code

STRING

country_code

STRING

country_name

STRING

latitude

INTEGER

longitude

INTEGER

postal_code

STRING

region_name

STRING

timezone

STRING

type

STRING

| | **name**

STRING | | **phone**

STRING | | **pseudonym**

STRING | | **segments**

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>.

Click to expand segments

segments

ARRAY

STRING

type

STRING

| | **session\_count**

INTEGER | | **signed\_up\_at**

DATE-TIME | | **social\_profiles**

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>.

Click to expand social\_profiles

social_profiles

ARRAY

STRING

name

STRING

type

STRING

url

STRING

username

STRING

tags

ARRAY

STRING

name

STRING

type

STRING