Intercom

Intercom ETL connector for data replication

Snapshot

Features

Details

Release Status

Released

Source API Version

v1.2

Table Selection

Yes

Column Selection

Yes

Edit Integration

Yes

Replication Type Selection

No

Authentication Parameters

Intercom account email Intercom account password

Replication Type

Full Replication Key Based Incremental

Replication Key

Date

Suggested Replication Frequency

24 hrs

Tables/APIs Supported

UserList

CustomerDataAttributes

CompanyDataAttributes

Leads

Companies

Admins

Teams

Tags

Segments

Counts

Conversations

Integrate Intercom with Daton

  1. Signin to Daton

  2. Select Intercom from Integrations page

  3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

  4. You will be redirected to Intercom login for authorizing Daton to extract data periodically

  5. Post successful authentication, you will be prompted to choose from the list of available tables

  6. Then select all required fields for each table

  7. Submit the integration

Workflow

  1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

  2. Users would be able to edit/pause/re-activate/delete integration anytime

  3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

Intercom Data

UserList

Purpose: To fetch a list of users

Source API Documentation https://developers.intercom.com/intercom-api-reference/reference#list-users

Replication: Key-Based Replication

Replication Key: updated_at

Fields

Name

Target Datatype

type

STRING

id

STRING

user_id

STRING

email

STRING

phone

STRING

name

STRING

updated_at

INTEGER

last_request_at

NUMERIC

signed_up_at

NUMERIC

created_at

INTEGER

session_count

NUMERIC

custom_attributes

RECORD

location_data

RECORD

social_profiles

RECORD

CustomerDataAttributes

Purpose: You can fetch a list of data attributes belonging to customers. Customer attributes describe attributes belonging to users, leads and visitors. Data Attributes are a type of metadata used to describe your customer.

Source API Documentation https://developers.intercom.com/intercom-api-reference/reference#list-customer-data-attributes

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

type

STRING

name

STRING

full_name

STRING

label

STRING

description

STRING

data_type

STRING

api_writable

BOOLEAN

ui_writable

BOOLEAN

custom

BOOLEAN

archived

BOOLEAN

CompanyDataAttributes

Purpose: You can fetch a list of all the company data attributes. Data Attributes are a type of metadata used to describe your customer and company models.

Source API Documentation https://developers.intercom.com/intercom-api-reference/reference#list-company-data-attributes

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

type

STRING

name

STRING

full_name

STRING

label

STRING

description

STRING

data_type

STRING

api_writable

BOOLEAN

ui_writable

BOOLEAN

custom

BOOLEAN

archived

BOOLEAN

Leads

Purpose: You can fetch a list of all leads. Leads are useful for representing logged-out users of your application. Leads were previously known as 'Contacts'.

Source API Documentation https://developers.intercom.com/intercom-api-reference/reference#list-leads

Replication: Key-Based Replication

Replication Key: updated_at

Fields

Name

Target Datatype

type

STRING

app_id

STRING

id

STRING

user_id

STRING

email

STRING

phone

STRING

name

STRING

updated_at

INTEGER

last_request_at

NUMERIC

signed_up_at

NUMERIC

created_at

INTEGER

session_count

NUMERIC

custom_attributes

RECORD

pseudonym

STRING

has_hard_bounced

BOOLEAN

last_seen_ip

STRING

location_data

RECORD

social_profiles

RECORD

Companies

Purpose: You can fetch a list of companies. Companies allow you to represent commercial organizations using your product. Each company will have its own description and be associated with users.

Source API Documentation https://developers.intercom.com/intercom-api-reference/reference#list-companies

Replication: Key-Based Replication

Replication Key: updated_at

Fields

Name

Target Datatype

type

STRING

id

STRING

company_id

STRING

plan

STRING

website

STRING

industry

STRING

name

STRING

updated_at

INTEGER

remote_created_at

INTEGER

size

NUMERIC

created_at

INTEGER

monthly_spend

NUMERIC

custom_attributes

RECORD

session_count

NUMERIC

user_count

NUMERIC

Admins

Purpose: Admins are how you can view your teammates within Intercom.

Source API Documentation https://developers.intercom.com/intercom-api-reference/reference#admins

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

type

STRING

email

STRING

id

STRING

name

STRING

away_mode_enabled

BOOLEAN

away_mode_reassign

BOOLEAN

team_ids

STRING

Teams

Purpose: Teams are how you can view your teams within Intercom.

Source API Documentation https://developers.intercom.com/intercom-api-reference/reference#list-teams

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

type

STRING

id

STRING

admin_ids

STRING

name

STRING

Tags

Purpose: A tag allows you to label your users and companies and list them using that tag. It also describes how users and companies can be tagged or untagged individually or in bulk.

Source API Documentation https://developers.intercom.com/intercom-api-reference/reference#tags

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

type

STRING

id

STRING

name

STRING

Segments

Purpose: A segment is a group of your users defined by rules that you set. Users are automatically added to the segment every time the user updates to match those rules. Segments are different to tags, in that users need to be added to tags manually and tag members are not automatically managed.

Source API Documentation https://developers.intercom.com/intercom-api-reference/reference#segments

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

type

STRING

id

STRING

name

STRING

created_at

INTEGER

updated_at

INTEGER

person_type

STRING

Counts

Purpose: You can use the API to get counts of users and companies filtered by certain criteria.

Source API Documentation https://developers.intercom.com/intercom-api-reference/reference#counts

Replication: Full Replication

Replication Key: NA

Fields

Name

Target Datatype

type

STRING

company

RECORD

user

RECORD

lead

RECORD

tag

RECORD

segment

RECORD

Conversations

Purpose: To fetch a list of all conversations. Conversation are how you can communicate with users in Intercom.

Source API Documentation https://developers.intercom.com/intercom-api-reference/reference#list-conversations

Key-Based Replication

Replication Key: updated_at

Fields

Name

Target Datatype

assignee

RECORD

conversation_message

RECORD

customer_first_reply

RECORD

created_at

INTEGER

customers

RECORD

user

RECORD

id

STRING

open

BOOLEAN

read

BOOLEAN

sent_at

NUMERIC

snoozed_until

NUMERIC

state

STRING

type

STRING

updated_at

INTEGER

waiting_since

NUMERIC