Zendesk support

Tables in the Zendesk support connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	macros	10	id	Full Refresh, Incremental	updated_at	API Reference
2	tickets	36	id	Full Refresh, Incremental	generated_timestamp	API Reference
3	brands	16				API Reference
4	ticket_comments	15	id	Full Refresh, Incremental	created_at
5	groups	6	id	Full Refresh, Incremental	updated_at	API Reference
6	users	38	id	Full Refresh, Incremental	updated_at	API Reference
7	ticket_metric_events	6	id	Full Refresh, Incremental	time
8	satisfaction_ratings	12	id	Full Refresh, Incremental	updated_at
9	tags	2	name	Full Refresh		API Reference
10	ticket_fields	25	id	Full Refresh, Incremental	updated_at
11	ticket_audits	7	id	Full Refresh, Incremental	created_at
12	custom_roles	8
13	schedules	6	id	Full Refresh	``	API Reference
14	organizations	15	id	Full Refresh, Incremental	updated_at	API Reference
15	ticket_forms	15	id	Full Refresh, Incremental	updated_at
16	ticket_metrics	27	id	Full Refresh, Incremental	updated_at
17	sla_policies	9	id	Full Refresh
18	group_memberships	7	id	Full Refresh, Incremental	updated_at

Table: macros

No	Column Name	Type	Notes
1	updated_at	VARCHAR	Incremental sync key
2	restriction	VARCHAR
3	created_at	VARCHAR
4	description	VARCHAR
5	active	BOOLEAN
6	id	INTEGER	Primary Key
7	position	INTEGER
8	title	VARCHAR
9	actions	VARCHAR
10	url	VARCHAR

Table: tickets

No	Column Name	Type	Notes
1	subject	VARCHAR
2	email_cc_ids	VARCHAR
3	description	VARCHAR
4	created_at	VARCHAR
5	external_id	VARCHAR
6	type	VARCHAR
7	via	VARCHAR
8	allow_attachments	BOOLEAN
9	updated_at	VARCHAR
10	problem_id	INTEGER
11	follower_ids	VARCHAR
12	due_at	VARCHAR
13	id	INTEGER	Primary Key
14	generated_timestamp	INTEGER	Incremental sync key
15	assignee_id	INTEGER
16	raw_subject	VARCHAR
17	forum_topic_id	INTEGER
18	custom_fields	VARCHAR
19	allow_channelback	BOOLEAN
20	satisfaction_rating	VARCHAR
21	submitter_id	INTEGER
22	collaborator_ids	VARCHAR
23	priority	VARCHAR
24	url	VARCHAR
25	brand_id	INTEGER
26	tags	VARCHAR
27	ticket_form_id	INTEGER
28	sharing_agreement_ids	VARCHAR
29	group_id	INTEGER
30	organization_id	INTEGER
31	followup_ids	VARCHAR
32	is_public	BOOLEAN
33	recipient	VARCHAR
34	has_incidents	BOOLEAN
35	requester_id	INTEGER
36	status	VARCHAR

Table: brands

No	Column Name	Type	Notes
1	host_mapping	VARCHAR
2	ticket_form_ids	VARCHAR
3	active	BOOLEAN
4	created_at	VARCHAR
5	help_center_state	VARCHAR
6	url	VARCHAR
7	brand_url	VARCHAR
8	has_help_center	BOOLEAN
9	default	BOOLEAN
10	is_deleted	BOOLEAN
11	updated_at	VARCHAR
12	signature_template	VARCHAR
13	name	VARCHAR
14	logo	VARCHAR
15	subdomain	VARCHAR
16	id	INTEGER

Table: ticket_comments

No	Column Name	Type	Notes
1	metadata	VARCHAR
2	attachments	VARCHAR
3	html_body	VARCHAR
4	created_at	VARCHAR	Incremental sync key
5	plain_body	VARCHAR
6	body	VARCHAR
7	ticket_id	INTEGER
8	type	VARCHAR
9	via_reference_id	INTEGER
10	via	VARCHAR
11	audit_id	INTEGER
12	public	BOOLEAN
13	id	INTEGER	Primary Key
14	author_id	INTEGER
15	timestamp	INTEGER

Table: groups

No	Column Name	Type	Notes
1	deleted	BOOLEAN
2	updated_at	VARCHAR	Incremental sync key
3	name	VARCHAR
4	created_at	VARCHAR
5	id	INTEGER	Primary Key
6	url	VARCHAR

Table: users

No	Column Name	Type	Notes
1	shared	BOOLEAN
2	last_login_at	VARCHAR
3	role	VARCHAR
4	notes	VARCHAR
5	signature	VARCHAR
6	moderator	BOOLEAN
7	shared_agent	BOOLEAN
8	custom_role_id	INTEGER
9	created_at	VARCHAR
10	external_id	VARCHAR
11	locale	VARCHAR
12	default_group_id	INTEGER
13	locale_id	INTEGER
14	user_fields	VARCHAR
15	updated_at	VARCHAR	Incremental sync key
16	report_csv	BOOLEAN
17	alias	VARCHAR
18	details	VARCHAR
19	id	INTEGER	Primary Key
20	email	VARCHAR
21	restricted_agent	BOOLEAN
22	two_factor_auth_enabled	BOOLEAN
23	role_type	INTEGER
24	only_private_comments	BOOLEAN
25	shared_phone_number	BOOLEAN
26	verified	BOOLEAN
27	photo	VARCHAR
28	active	BOOLEAN
29	permanently_deleted	BOOLEAN
30	time_zone	VARCHAR
31	suspended	BOOLEAN
32	url	VARCHAR
33	tags	VARCHAR
34	phone	VARCHAR
35	organization_id	INTEGER
36	name	VARCHAR
37	chat_only	BOOLEAN
38	ticket_restriction	VARCHAR

Table: ticket_metric_events

No	Column Name	Type	Notes
1	instance_id	INTEGER
2	metric	VARCHAR
3	id	INTEGER	Primary Key
4	time	VARCHAR	Incremental sync key
5	ticket_id	INTEGER
6	type	VARCHAR

Table: satisfaction_ratings

No	Column Name	Type	Notes
1	score	VARCHAR
2	reason	VARCHAR
3	updated_at	VARCHAR	Incremental sync key
4	group_id	INTEGER
5	created_at	VARCHAR
6	comment	VARCHAR
7	id	INTEGER	Primary Key
8	ticket_id	INTEGER
9	url	VARCHAR
10	assignee_id	INTEGER
11	reason_id	INTEGER
12	requester_id	INTEGER

Table: tags

No	Column Name	Type	Notes
1	count	INTEGER
2	name	VARCHAR	Primary Key

Table: ticket_fields

No	Column Name	Type	Notes
1	raw_title	VARCHAR
2	custom_field_options	VARCHAR
3	visible_in_portal	BOOLEAN
4	created_at	VARCHAR
5	description	VARCHAR
6	title	VARCHAR
7	type	VARCHAR
8	required	BOOLEAN
9	editable_in_portal	BOOLEAN
10	updated_at	VARCHAR	Incremental sync key
11	system_field_options	VARCHAR
12	regexp_for_validation	VARCHAR
13	tag	VARCHAR
14	id	INTEGER	Primary Key
15	collapsed_for_agents	BOOLEAN
16	raw_title_in_portal	VARCHAR
17	active	BOOLEAN
18	agent_description	VARCHAR
19	raw_description	VARCHAR
20	url	VARCHAR
21	required_in_portal	BOOLEAN
22	removable	BOOLEAN
23	sub_type_id	INTEGER
24	position	INTEGER
25	title_in_portal	VARCHAR

Table: ticket_audits

No	Column Name	Type	Notes
1	metadata	VARCHAR
2	created_at	VARCHAR	Incremental sync key
3	id	INTEGER	Primary Key
4	author_id	INTEGER
5	ticket_id	INTEGER
6	events	VARCHAR
7	via	VARCHAR

Table: custom_roles

No	Column Name	Type	Notes
1	team_member_count	INTEGER
2	role_type	INTEGER
3	updated_at	VARCHAR
4	configuration	VARCHAR
5	name	VARCHAR
6	description	VARCHAR
7	created_at	VARCHAR
8	id	INTEGER

Table: schedules

No	Column Name	Type	Notes
1	intervals	VARCHAR
2	updated_at	VARCHAR
3	name	VARCHAR
4	created_at	VARCHAR
5	id	INTEGER	Primary Key
6	time_zone	VARCHAR

Table: organizations

No	Column Name	Type	Notes
1	shared_tickets	BOOLEAN
2	notes	VARCHAR
3	created_at	VARCHAR
4	external_id	VARCHAR
5	deleted_at	VARCHAR
6	url	VARCHAR
7	tags	VARCHAR
8	domain_names	VARCHAR
9	organization_fields	VARCHAR
10	updated_at	VARCHAR	Incremental sync key
11	group_id	INTEGER
12	name	VARCHAR
13	details	VARCHAR
14	id	INTEGER	Primary Key
15	shared_comments	BOOLEAN

Table: ticket_forms

No	Column Name	Type	Notes
1	raw_name	VARCHAR
2	in_all_brands	BOOLEAN
3	ticket_field_ids	VARCHAR
4	created_at	VARCHAR
5	active	BOOLEAN
6	raw_display_name	VARCHAR
7	display_name	VARCHAR
8	url	VARCHAR
9	default	BOOLEAN
10	updated_at	VARCHAR	Incremental sync key
11	end_user_visible	BOOLEAN
12	name	VARCHAR
13	position	INTEGER
14	id	INTEGER	Primary Key
15	restricted_brand_ids	VARCHAR

Table: ticket_metrics

No	Column Name	Type	Notes
1	group_stations	INTEGER
2	on_hold_time_in_minutes	VARCHAR
3	reply_time_in_minutes	VARCHAR
4	assignee_stations	INTEGER
5	created_at	VARCHAR
6	type	VARCHAR
7	initially_assigned_at	VARCHAR
8	updated_at	VARCHAR	Incremental sync key
9	assigned_at	VARCHAR
10	id	INTEGER	Primary Key
11	agent_wait_time_in_minutes	VARCHAR
12	full_resolution_time_in_minutes	VARCHAR
13	status_updated_at	VARCHAR
14	reopens	INTEGER
15	requester_updated_at	VARCHAR
16	ticket_id	INTEGER
17	url	VARCHAR
18	instance_id	INTEGER
19	latest_comment_added_at	VARCHAR
20	replies	INTEGER
21	metric	VARCHAR
22	solved_at	VARCHAR
23	time	VARCHAR
24	requester_wait_time_in_minutes	VARCHAR
25	first_resolution_time_in_minutes	VARCHAR
26	status	VARCHAR
27	assignee_updated_at	VARCHAR

Table: sla_policies

No	Column Name	Type	Notes
1	filter	VARCHAR
2	updated_at	VARCHAR
3	policy_metrics	VARCHAR
4	description	VARCHAR
5	created_at	VARCHAR
6	id	INTEGER	Primary Key
7	position	INTEGER
8	title	VARCHAR
9	url	VARCHAR

Table: group_memberships

No	Column Name	Type	Notes
1	default	BOOLEAN
2	updated_at	VARCHAR	Incremental sync key
3	user_id	INTEGER
4	group_id	INTEGER
5	created_at	VARCHAR
6	id	INTEGER	Primary Key
7	url	VARCHAR

External Resources

• Api Token
• Custom Roles
• Group Memberships
• Satisfaction Ratings
• Sla Policies
• Ticket Audits
• Ticket Comments
• Ticket Fields
• Ticket Forms
• Ticket Metrics
• Ticket Metric Events
• 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.