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.
To establish a connection to Intercom, you need to sign in to Intercom via OAuth 2.0.
To connect to Intercom, perform the following steps:
Click Sign In with Intercom.
In the opened window, enter email and password used when signing up to Intercom.
Click Authorize access.
Additional Connection Parameters
Suppress 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:
|Articles||Statistics_Type, Statistics_Views, Statistics_Conversations, Statistics_Reactions, Statistics_HappyReactionPercentage, Statistics_NeutralReactionPercentage, Statistics_SadReactionPercentage|
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.
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.
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 Support
|INSERT, UPDATE, DELETE||Articles, Collections, Companies, Contacts, Sections, Tags|
|INSERT||ContactCompanies, DataAttribute, 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.
Skyvia supports all the common actions for Intercom.