Intercom

Tables in the Intercom connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	companies	18	id	Full Refresh, Incremental	updated_at	API Reference
2	teams	4	name	Full Refresh		API Reference
3	conversation_parts	16	id	Full Refresh, Incremental	updated_at
4	company_attributes	15	name	Full Refresh
5	conversations	29	id	Full Refresh, Incremental	updated_at	API Reference
6	contact_attributes	15	name	Full Refresh
7	company_segments	7	id	Full Refresh, Incremental	updated_at
8	admins	11	id	Full Refresh		API Reference
9	contacts	47	id	Full Refresh, Incremental	updated_at	API Reference
10	segments	7	id	Full Refresh, Incremental	updated_at	API Reference
11	tags	3	name	Full Refresh		API Reference

Table: companies

No	Column Name	Type	Notes
1	website	VARCHAR
2	company_id	VARCHAR
3	created_at	INTEGER
4	industry	VARCHAR
5	type	VARCHAR
6	tags	VARCHAR
7	segments	VARCHAR
8	custom_attributes	VARCHAR
9	monthly_spend	DOUBLE
10	updated_at	INTEGER	Incremental sync key
11	user_count	INTEGER
12	size	INTEGER
13	session_count	INTEGER
14	name	VARCHAR
15	id	VARCHAR	Primary Key
16	remote_created_at	INTEGER
17	app_id	VARCHAR
18	plan	VARCHAR

Table: teams

No	Column Name	Type	Notes
1	name	VARCHAR	Primary Key
2	admin_ids	VARCHAR
3	id	VARCHAR
4	type	VARCHAR

Table: conversation_parts

No	Column Name	Type	Notes
1	attachments	VARCHAR
2	redacted	BOOLEAN
3	author	VARCHAR
4	conversation_total_parts	INTEGER
5	created_at	INTEGER
6	external_id	VARCHAR
7	part_type	VARCHAR
8	body	VARCHAR
9	conversation_created_at	INTEGER
10	type	VARCHAR
11	updated_at	INTEGER	Incremental sync key
12	conversation_id	VARCHAR
13	conversation_updated_at	INTEGER
14	id	VARCHAR	Primary Key
15	notified_at	INTEGER
16	assigned_to	VARCHAR

Table: company_attributes

No	Column Name	Type	Notes
1	custom	BOOLEAN
2	created_at	INTEGER
3	description	VARCHAR
4	label	VARCHAR
5	type	VARCHAR
6	archived	BOOLEAN
7	ui_writable	BOOLEAN
8	full_name	VARCHAR
9	api_writable	BOOLEAN
10	updated_at	INTEGER
11	admin_id	VARCHAR
12	data_type	VARCHAR
13	name	VARCHAR	Primary Key
14	options	VARCHAR
15	model	VARCHAR

Table: conversations

No	Column Name	Type	Notes
1	redacted	BOOLEAN
2	created_at	INTEGER
3	conversation_message	VARCHAR
4	source	VARCHAR
5	conversation_rating	VARCHAR
6	snoozed_until	INTEGER
7	sla_applied	VARCHAR
8	type	VARCHAR
9	title	VARCHAR
10	custom_attributes	VARCHAR
11	customer_first_reply	VARCHAR
12	teammates	VARCHAR
13	admin_assignee_id	INTEGER
14	updated_at	INTEGER	Incremental sync key
15	team_assignee_id	INTEGER
16	customers	VARCHAR
17	id	VARCHAR	Primary Key
18	state	VARCHAR
19	read	BOOLEAN
20	waiting_since	INTEGER
21	priority	VARCHAR
22	tags	VARCHAR
23	sent_at	INTEGER
24	first_contact_reply	VARCHAR
25	assignee	VARCHAR
26	user	VARCHAR
27	contacts	VARCHAR
28	open	BOOLEAN
29	statistics	VARCHAR

Table: contact_attributes

No	Column Name	Type	Notes
1	custom	BOOLEAN
2	description	VARCHAR
3	created_at	INTEGER
4	label	VARCHAR
5	type	VARCHAR
6	archived	BOOLEAN
7	ui_writable	BOOLEAN
8	full_name	VARCHAR
9	api_writable	BOOLEAN
10	updated_at	INTEGER
11	admin_id	VARCHAR
12	name	VARCHAR	Primary Key
13	data_type	VARCHAR
14	options	VARCHAR
15	model	VARCHAR

Table: company_segments

No	Column Name	Type	Notes
1	updated_at	INTEGER	Incremental sync key
2	person_type	VARCHAR
3	count	INTEGER
4	name	VARCHAR
5	created_at	INTEGER
6	id	VARCHAR	Primary Key
7	type	VARCHAR

Table: admins

No	Column Name	Type	Notes
1	team_ids	VARCHAR
2	away_mode_enabled	BOOLEAN
3	away_mode_reassign	BOOLEAN
4	name	VARCHAR
5	admin_ids	VARCHAR
6	avatar	VARCHAR
7	id	VARCHAR	Primary Key
8	has_inbox_seat	BOOLEAN
9	type	VARCHAR
10	job_title	VARCHAR
11	email	VARCHAR

Table: contacts

No	Column Name	Type	Notes
1	last_email_clicked_at	INTEGER
2	role	VARCHAR
3	notes	VARCHAR
4	android_last_seen_at	VARCHAR
5	ios_device	VARCHAR
6	owner_id	INTEGER
7	created_at	INTEGER
8	external_id	VARCHAR
9	type	VARCHAR
10	android_sdk_version	VARCHAR
11	language_override	VARCHAR
12	custom_attributes	VARCHAR
13	workspace_id	VARCHAR
14	companies	VARCHAR
15	unsubscribed_from_emails	BOOLEAN
16	last_email_opened_at	INTEGER
17	updated_at	INTEGER	Incremental sync key
18	last_replied_at	INTEGER
19	browser	VARCHAR
20	ios_app_name	VARCHAR
21	id	VARCHAR	Primary Key
22	browser_version	VARCHAR
23	browser_language	VARCHAR
24	ios_sdk_version	VARCHAR
25	email	VARCHAR
26	opted_out_subscription_types	VARCHAR
27	signed_up_at	INTEGER
28	ios_os_version	VARCHAR
29	has_hard_bounced	BOOLEAN
30	os	VARCHAR
31	ios_app_version	VARCHAR
32	unsubscribed_from_sms	BOOLEAN
33	last_contacted_at	INTEGER
34	android_device	VARCHAR
35	ios_last_seen_at	INTEGER
36	avatar	VARCHAR
37	android_app_version	VARCHAR
38	tags	VARCHAR
39	sms_consent	BOOLEAN
40	social_profiles	VARCHAR
41	marked_email_as_spam	BOOLEAN
42	android_app_name	VARCHAR
43	android_os_version	VARCHAR
44	phone	VARCHAR
45	name	VARCHAR
46	location	VARCHAR
47	last_seen_at	INTEGER

Table: segments

No	Column Name	Type	Notes
1	updated_at	INTEGER	Incremental sync key
2	person_type	VARCHAR
3	count	INTEGER
4	name	VARCHAR
5	created_at	INTEGER
6	id	VARCHAR	Primary Key
7	type	VARCHAR

Table: tags

No	Column Name	Type	Notes
1	name	VARCHAR	Primary Key
2	id	VARCHAR
3	type	VARCHAR

External Resources

• Access Token
• Company Segments
• Conversation Parts
• Data Attributes
• Customer Attributes
• Company Attributes
• Requests Limitation

Zipstack Cloud features a powerful SQL querying engine on top of many types of connectors, including those from Trino, some custom connectors and connectors from the open source Airbyte project. Some Zipstack cloud connectors are designed to utilize and expand upon Airbyte's connector protocol, but they do not use Airbyte's EL core. Additionally, some parts of the documentation for these connectors have been adapted from the connector documentation found in Airbyte's open source project.