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. 1.
    Signin to Daton
  2. 2.
    Select Intercom from Integrations page
  3. 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. 4.
    You will be redirected to Intercom login for authorizing Daton to extract data periodically
  5. 5.
    Post successful authentication, you will be prompted to choose from the list of available tables
  6. 6.
    Then select all required fields for each table
  7. 7.
    Submit the integration

Workflow

  1. 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. 2.
    Users would be able to edit/pause/re-activate/delete integration anytime
  3. 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
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.
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.
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'.
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.
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.
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.
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.
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.
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.
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.
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
Last modified 1yr ago