Zendesk sell

Tables in the Zendesk sell connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	loss_reasons	5	id	Full Refresh
2	visit_outcomes	5	id	Full Refresh
3	notes	10	id	Full Refresh
4	lead_conversions	7	id	Full Refresh
5	collaborations	7
6	call_outcomes	5	id	Full Refresh
7	users	18	id	Full Refresh
8	products	12	id	Full Refresh
9	tags	6	id	Full Refresh
10	lead_unqualified_reasons	5	id	Full Refresh
11	visits	11	id	Full Refresh
12	lead_sources	6	id	Full Refresh
13	pipelines	5	id	Full Refresh
14	text_messages	12	id	Full Refresh
15	calls	15
16	leads	25	id	Full Refresh, Incremental	updated_at
17	deals	24	id	Full Refresh, Incremental	updated_at
18	stages	9	id	Full Refresh
19	deal_unqualified_reasons	5	id	Full Refresh
20	orders	5	id	Full Refresh
21	deal_sources	6	id	Full Refresh
22	tasks	13	id	Full Refresh
23	contacts	30	id	Full Refresh, Incremental	updated_at

Table: loss_reasons

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	name	VARCHAR
3	creator_id	DOUBLE
4	created_at	VARCHAR
5	id	DOUBLE	Primary Key

Table: visit_outcomes

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	creator_id	DOUBLE
3	name	VARCHAR
4	created_at	VARCHAR
5	id	DOUBLE	Primary Key

Table: notes

No	Column Name	Type	Notes
1	is_important	BOOLEAN
2	updated_at	VARCHAR
3	creator_id	DOUBLE
4	resource_type	VARCHAR
5	resource_id	DOUBLE
6	created_at	VARCHAR
7	id	DOUBLE	Primary Key
8	type	VARCHAR
9	content	VARCHAR
10	tags	VARCHAR

Table: lead_conversions

No	Column Name	Type	Notes
1	organization_id	DOUBLE
2	creator_id	DOUBLE
3	created_at	VARCHAR
4	id	DOUBLE	Primary Key
5	deal_id	DOUBLE
6	lead_id	DOUBLE
7	individual_id	DOUBLE

Table: collaborations

No	Column Name	Type	Notes
1	collaborator_id	DOUBLE
2	updated_at	VARCHAR
3	creator_id	DOUBLE
4	resource_type	VARCHAR
5	resource_id	DOUBLE
6	created_at	VARCHAR
7	id	DOUBLE

Table: call_outcomes

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	creator_id	DOUBLE
3	name	VARCHAR
4	created_at	VARCHAR
5	id	DOUBLE	Primary Key

Table: users

No	Column Name	Type	Notes
1	role	VARCHAR
2	timezone	VARCHAR
3	roles	VARCHAR
4	invited	BOOLEAN
5	created_at	VARCHAR
6	confirmed	BOOLEAN
7	deleted_at	VARCHAR
8	team_name	VARCHAR
9	zendesk_user_id	VARCHAR
10	updated_at	VARCHAR
11	reports_to	DOUBLE
12	name	VARCHAR
13	phone_number	VARCHAR
14	id	DOUBLE	Primary Key
15	identity_type	VARCHAR
16	email	VARCHAR
17	status	VARCHAR
18	group	VARCHAR

Table: products

No	Column Name	Type	Notes
1	cost	DOUBLE
2	updated_at	VARCHAR
3	cost_currency	VARCHAR
4	name	VARCHAR
5	description	VARCHAR
6	active	BOOLEAN
7	max_discount	DOUBLE
8	created_at	VARCHAR
9	id	DOUBLE	Primary Key
10	sku	VARCHAR
11	prices	VARCHAR
12	max_markup	DOUBLE

Table: tags

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	creator_id	DOUBLE
3	name	VARCHAR
4	resource_type	VARCHAR
5	created_at	VARCHAR
6	id	DOUBLE	Primary Key

Table: lead_unqualified_reasons

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	name	VARCHAR
3	creator_id	DOUBLE
4	created_at	VARCHAR
5	id	DOUBLE	Primary Key

Table: visits

No	Column Name	Type	Notes
1	summary	VARCHAR
2	outcome_id	DOUBLE
3	rep_location_verification_status	VARCHAR
4	updated_at	VARCHAR
5	creator_id	DOUBLE
6	resource_type	VARCHAR
7	resource_id	DOUBLE
8	visited_at	VARCHAR
9	created_at	VARCHAR
10	id	DOUBLE	Primary Key
11	resource_address	VARCHAR

Table: lead_sources

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	creator_id	DOUBLE
3	name	VARCHAR
4	resource_type	VARCHAR
5	created_at	VARCHAR
6	id	DOUBLE	Primary Key

Table: pipelines

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	name	VARCHAR
3	created_at	VARCHAR
4	disabled	BOOLEAN
5	id	DOUBLE	Primary Key

Table: text_messages

No	Column Name	Type	Notes
1	sent_at	VARCHAR
2	incoming	BOOLEAN
3	user_phone_number	VARCHAR
4	updated_at	VARCHAR
5	associated_deal_ids	VARCHAR
6	user_id	DOUBLE
7	resource_type	VARCHAR
8	resource_phone_number	VARCHAR
9	created_at	VARCHAR
10	resource_id	DOUBLE
11	id	DOUBLE	Primary Key
12	content	VARCHAR

Table: calls

No	Column Name	Type	Notes
1	summary	VARCHAR
2	made_at	VARCHAR
3	outcome_id	DOUBLE
4	incoming	BOOLEAN
5	recording_url	VARCHAR
6	associated_deal_ids	VARCHAR
7	missed	BOOLEAN
8	resource_type	VARCHAR
9	created_at	VARCHAR
10	duration	DOUBLE
11	updated_at	VARCHAR
12	user_id	DOUBLE
13	resource_id	DOUBLE
14	phone_number	DOUBLE
15	id	DOUBLE

Table: leads

No	Column Name	Type	Notes
1	owner_id	DOUBLE
2	description	VARCHAR
3	created_at	VARCHAR
4	industry	VARCHAR
5	linkedin	VARCHAR
6	title	VARCHAR
7	skype	VARCHAR
8	twitter	VARCHAR
9	updated_at	VARCHAR	Incremental sync key
10	id	DOUBLE	Primary Key
11	fax	VARCHAR
12	first_name	VARCHAR
13	email	VARCHAR
14	website	VARCHAR
15	address	VARCHAR
16	custom_fields	VARCHAR
17	facebook	VARCHAR
18	mobile	VARCHAR
19	last_name	VARCHAR
20	organization_name	VARCHAR
21	tags	VARCHAR
22	phone	VARCHAR
23	creator_id	DOUBLE
24	source_id	DOUBLE
25	status	VARCHAR

Table: deals

No	Column Name	Type	Notes
1	unqualified_reason_id	DOUBLE
2	owner_id	DOUBLE
3	stage_id	DOUBLE
4	custom_fields	VARCHAR
5	created_at	VARCHAR
6	hot	BOOLEAN
7	contact_id	DOUBLE
8	estimated_close_date	VARCHAR
9	dropbox_email	VARCHAR
10	tags	VARCHAR
11	customized_win_likelihood	DOUBLE
12	added_at	VARCHAR
13	updated_at	VARCHAR	Incremental sync key
14	last_stage_change_by_id	DOUBLE
15	last_activity_at	VARCHAR
16	organization_id	DOUBLE
17	creator_id	DOUBLE
18	name	VARCHAR
19	last_stage_change_at	VARCHAR
20	currency	VARCHAR
21	id	DOUBLE	Primary Key
22	source_id	DOUBLE
23	value	DOUBLE
24	loss_reason_id	DOUBLE

Table: stages

No	Column Name	Type	Notes
1	likelihood	DOUBLE
2	updated_at	VARCHAR
3	name	VARCHAR
4	pipeline_id	DOUBLE
5	active	BOOLEAN
6	created_at	VARCHAR
7	id	DOUBLE	Primary Key
8	position	DOUBLE
9	category	VARCHAR

Table: deal_unqualified_reasons

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	creator_id	DOUBLE
3	name	VARCHAR
4	created_at	VARCHAR
5	id	DOUBLE	Primary Key

Table: orders

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	discount	DOUBLE
3	created_at	VARCHAR
4	id	DOUBLE	Primary Key
5	deal_id	DOUBLE

Table: deal_sources

No	Column Name	Type	Notes
1	updated_at	VARCHAR
2	creator_id	DOUBLE
3	name	VARCHAR
4	resource_type	VARCHAR
5	created_at	VARCHAR
6	id	DOUBLE	Primary Key

Table: tasks

No	Column Name	Type	Notes
1	owner_id	DOUBLE
2	resource_type	VARCHAR
3	due_date	VARCHAR
4	created_at	VARCHAR
5	completed	BOOLEAN
6	remind_at	VARCHAR
7	content	VARCHAR
8	completed_at	VARCHAR
9	overdue	BOOLEAN
10	updated_at	VARCHAR
11	creator_id	DOUBLE
12	resource_id	DOUBLE
13	id	DOUBLE	Primary Key

Table: contacts

No	Column Name	Type	Notes
1	owner_id	DOUBLE
2	parent_organization_id	DOUBLE
3	description	VARCHAR
4	created_at	VARCHAR
5	industry	VARCHAR
6	billing_address	VARCHAR
7	linkedin	VARCHAR
8	contact_id	DOUBLE
9	title	VARCHAR
10	skype	VARCHAR
11	twitter	VARCHAR
12	updated_at	VARCHAR	Incremental sync key
13	id	DOUBLE	Primary Key
14	shipping_address	VARCHAR
15	fax	VARCHAR
16	first_name	VARCHAR
17	email	VARCHAR
18	prospect_status	VARCHAR
19	website	VARCHAR
20	address	VARCHAR
21	custom_fields	VARCHAR
22	facebook	VARCHAR
23	mobile	VARCHAR
24	last_name	VARCHAR
25	is_organization	BOOLEAN
26	tags	VARCHAR
27	phone	VARCHAR
28	customer_status	VARCHAR
29	creator_id	DOUBLE
30	name	VARCHAR

External Resources

• Zendesk Sell Api
• Requests Limitation
• Guide
• Here

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.