Intercom

Intercom is a complete customer communications platform with bots, apps, product tours, etc. that enables targeted communication with customers on the website, inside the web, mobile apps, etc.

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

Backup: Skyvia Backup does not support Intercom backup.

Query: Skyvia Query supports Intercom.

Establishing Connection

To establish a connection to Intercom, you need to sign in to Intercom via OAuth 2.0.

Creating Connection

To connect to Intercom, perform the following steps:

  1. Click Sign In with Intercom.

    Connection Editor window

  2. In the opened window, enter email and password used when signing up to Intercom.

    Connection Editor window

  3. Click Authorize access.

Additional Connection Parameters

Suppressing Extended Requests

Intercom API returns only part of the fields for some objects when querying multiple records. To query the values of additional fields, Skyvia performs additional extended requests for each record of such an object. However, this can decrease performance and significantly increase the number of API calls.

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

The list of such additional fields is the following:

Object Field
Articles Statistics_Type, Statistics_Views, Statistics_Conversations, Statistics_Reactions, Statistics_HappyReactionPercentage, Statistics_NeutralReactionPercentage, Statistics_SadReactionPercentage

Connector Specifics

Object Peculiarities

Contacts

When performing Insert and Update operations against the Contacts object, Skyvia searches the corresponding target record by id, email, or user_id. If no match is found, a new record is inserted, and if a match is found, the record is updated regardless of the operation. Thus, Insert and Update operations can both insert new records and update the existing ones, if any present.

Companies

When performing Insert and Update operations against the Companies object, Skyvia searches the corresponding target record by company_id. If no match is found, a new record is inserted, and if a match is found, the record is updated regardless of the operation. Thus, Insert and Update operations can both insert new records and update the existing ones, if any present.

Conversations

By inserting data to the Conversations object, you create a new conversation.

  • In the From_Type field, you have to specify one of the following values: User or Lead.
  • In the From_Id field, you need to enter Id of the corresponding contact.
  • In the Body field, you enter a text message.

By updating data in the Conversations object, you send a message to an already existing conversation (perform a Reply to a conversation). You can perform a Reply on behalf of a user or on behalf of an admin. Depending on the specified From_Type value, you need to set the value for the column — From_AdminId or From_UserId.

DML Operations Supports

Operation Object
INSERT, UPDATE, DELETE Articles, Collections, Companies, Contacts, Sections, Tags
INSERT, UPDATE Conversations
INSERT DataAttributes, Notes

Incremental Replication and Synchronization

Synchronization is supported for the following objects: Articles, Companies, Collections, Contacts, Conversations, Sections.

Replication with Incremental Updates is supported for the following objects: Articles, Companies, Collections, CompanySegments, Contacts, ContactSegments, ContactCompanies, Conversations, Events, Notes, Sections, Segments.

Supported Actions

Skyvia supports all the common actions for Intercom.