Zendesk talk

Prerequisites

• Zendesk API Token or Zendesk OAuth Client
• Zendesk Email (For API Token authentication)
• Zendesk Subdomain

Setting up the Zendesk talk connector

No	Item	Required	Example	Notes
1	Subdomain	Yes		This is your Zendesk subdomain that can be found in your account URL. For example, in https://{MY_SUBDOMAIN}.zendesk.com/, where MY_SUBDOMAIN is the value of your subdomain.
2	Authentication	Yes		Zendesk service provides two authentication methods. Choose between: OAuth2.0 or API token. Refer to the documentation in the form while using the connector API Token OAuth2.0
3	Start Date	Yes	2020-10-15T00:00:00Z	The date from which you'd like to replicate data for Zendesk Talk API, in the format YYYY-MM-DDT00:00:00Z. All data generated after this date will be replicated.

Tables in the Zendesk talk connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	addresses	9	id	Full Refresh		API Reference
2	call_legs	25	id	Full Refresh, Incremental	updated_at
3	account_overview	23	current_timestamp	Full Refresh
4	greeting_categories	2	id	Full Refresh
5	agents_overview	22	current_timestamp	Full Refresh
6	greetings	13	id	Full Refresh		API Reference
7	current_queue_activity	7	current_timestamp	Full Refresh
8	phone_numbers	30	id	Full Refresh
9	ivr_menus	5	id	Full Refresh
10	agents_activity	25	agent_id	Full Refresh
11	calls	40	id	Full Refresh, Incremental	updated_at	API Reference
12	ivr_routes	9	id	Full Refresh
13	ivrs	5	id	Full Refresh		API Reference

Table: addresses

No	Column Name	Type	Notes
1	zip	VARCHAR
2	country_code	VARCHAR
3	province	VARCHAR
4	city	VARCHAR
5	street	VARCHAR
6	provider_reference	VARCHAR
7	name	VARCHAR
8	id	INTEGER	Primary Key
9	state	VARCHAR

Table: call_legs

No	Column Name	Type	Notes
1	agent_id	INTEGER
2	forwarded_to	VARCHAR
3	transferred_to	INTEGER
4	created_at	VARCHAR
5	conference_time	INTEGER
6	type	VARCHAR
7	duration	INTEGER
8	conference_to	INTEGER
9	consultation_from	INTEGER
10	updated_at	VARCHAR	Incremental sync key
11	completion_status	VARCHAR
12	id	INTEGER	Primary Key
13	call_charge	VARCHAR
14	minutes_billed	INTEGER
15	hold_time	INTEGER
16	transferred_from	INTEGER
17	call_id	INTEGER
18	quality_issues	VARCHAR
19	available_via	VARCHAR
20	consultation_to	INTEGER
21	wrap_up_time	INTEGER
22	user_id	INTEGER
23	consultation_time	INTEGER
24	conference_from	INTEGER
25	talk_time	INTEGER

Table: account_overview

No	Column Name	Type	Notes
1	max_calls_waiting	INTEGER
2	total_wrap_up_time	INTEGER
3	total_callback_calls	INTEGER
4	average_hold_time	INTEGER
5	total_outbound_calls	INTEGER
6	total_voicemails	INTEGER
7	total_inbound_calls	INTEGER
8	average_time_to_answer	INTEGER
9	average_queue_wait_time	INTEGER
10	total_calls_abandoned_in_queue	INTEGER
11	total_calls	INTEGER
12	total_calls_with_requested_voicemail	INTEGER
13	max_queue_wait_time	INTEGER
14	total_hold_time	INTEGER
15	current_timestamp	INTEGER	Primary Key
16	average_call_duration	INTEGER
17	total_calls_with_exceeded_queue_wait_time	INTEGER
18	total_call_duration	INTEGER
19	total_embeddable_callback_calls	INTEGER
20	average_callback_wait_time	INTEGER
21	average_wrap_up_time	INTEGER
22	total_calls_outside_business_hours	INTEGER
23	total_textback_requests	INTEGER

Table: greeting_categories

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

Table: agents_overview

No	Column Name	Type	Notes
1	total_calls_accepted	INTEGER
2	total_calls_denied	INTEGER
3	total_wrap_up_time	INTEGER
4	average_started_transfers	INTEGER
5	average_calls_missed	INTEGER
6	total_accepted_transfers	INTEGER
7	average_hold_time	INTEGER
8	average_calls_denied	INTEGER
9	total_calls_put_on_hold	INTEGER
10	average_accepted_transfers	INTEGER
11	average_available_time	INTEGER
12	average_calls_accepted	INTEGER
13	average_calls_put_on_hold	INTEGER
14	total_hold_time	INTEGER
15	current_timestamp	INTEGER	Primary Key
16	average_away_time	INTEGER
17	total_calls_missed	INTEGER
18	average_online_time	INTEGER
19	total_talk_time	INTEGER
20	average_talk_time	INTEGER
21	total_started_transfers	INTEGER
22	average_wrap_up_time	INTEGER

Table: greetings

No	Column Name	Type	Notes
1	audio_name	VARCHAR
2	upload_id	INTEGER
3	ivr_ids	VARCHAR
4	pending	BOOLEAN
5	active	BOOLEAN
6	default	BOOLEAN
7	category_id	INTEGER
8	default_lang	BOOLEAN
9	phone_number_ids	VARCHAR
10	name	VARCHAR
11	has_sub_settings	BOOLEAN
12	audio_url	VARCHAR
13	id	VARCHAR	Primary Key

Table: current_queue_activity

No	Column Name	Type	Notes
1	longest_wait_time	INTEGER
2	current_timestamp	INTEGER	Primary Key
3	callbacks_waiting	INTEGER
4	agents_online	INTEGER
5	calls_waiting	INTEGER
6	average_wait_time	INTEGER
7	embeddable_callbacks_waiting	INTEGER

Table: phone_numbers

No	Column Name	Type	Notes
1	failover_number	VARCHAR
2	transcription	BOOLEAN
3	sms_enabled	BOOLEAN
4	created_at	VARCHAR
5	voice_enabled	BOOLEAN
6	toll_free	BOOLEAN
7	default_group_id	INTEGER
8	number	VARCHAR
9	ivr_id	INTEGER
10	outbound_enabled	BOOLEAN
11	line_type	VARCHAR
12	group_ids	VARCHAR
13	nickname	VARCHAR
14	id	INTEGER	Primary Key
15	capabilities	VARCHAR
16	categorised_greetings	VARCHAR
17	default_greeting_ids	VARCHAR
18	priority	INTEGER
19	recorded	BOOLEAN
20	token	VARCHAR
21	country_code	VARCHAR
22	external	BOOLEAN
23	categorised_greetings_with_sub_settings	VARCHAR
24	name	VARCHAR
25	display_number	VARCHAR
26	location	VARCHAR
27	greeting_ids	VARCHAR
28	schedule_id	INTEGER
29	call_recording_consent	VARCHAR
30	sms_group_id	INTEGER

Table: ivr_menus

No	Column Name	Type	Notes
1	default	BOOLEAN
2	ivr_id	INTEGER
3	name	VARCHAR
4	id	INTEGER	Primary Key
5	greeting_id	INTEGER

Table: agents_activity

No	Column Name	Type	Notes
1	calls_put_on_hold	INTEGER
2	agent_id	INTEGER	Primary Key
3	average_hold_time	INTEGER
4	calls_missed	INTEGER
5	via	VARCHAR
6	available_time	INTEGER
7	call_status	VARCHAR
8	online_time	INTEGER
9	accepted_transfers	INTEGER
10	calls_accepted	INTEGER
11	average_talk_time	INTEGER
12	average_wrap_up_time	INTEGER
13	total_wrap_up_time	INTEGER
14	forwarding_number	VARCHAR
15	started_transfers	INTEGER
16	avatar_url	VARCHAR
17	total_hold_time	INTEGER
18	calls_denied	INTEGER
19	total_call_duration	INTEGER
20	agent_state	VARCHAR
21	name	VARCHAR
22	started_third_party_conferences	INTEGER
23	total_talk_time	INTEGER
24	accepted_third_party_conferences	INTEGER
25	away_time	INTEGER

Table: calls

No	Column Name	Type	Notes
1	ivr_action	VARCHAR
2	agent_id	INTEGER
3	callback_source	VARCHAR
4	customer_requested_voicemail	BOOLEAN
5	created_at	VARCHAR
6	ivr_hops	INTEGER
7	default_group	BOOLEAN
8	duration	INTEGER
9	phone_number_id	INTEGER
10	updated_at	VARCHAR	Incremental sync key
11	overflowed	BOOLEAN
12	outside_business_hours	BOOLEAN
13	completion_status	VARCHAR
14	ivr_routed_to	VARCHAR
15	call_group_id	INTEGER
16	id	INTEGER	Primary Key
17	call_charge	VARCHAR
18	call_recording_consent_keypress	VARCHAR
19	ivr_time_spent	INTEGER
20	minutes_billed	INTEGER
21	ivr_destination_group_name	VARCHAR
22	not_recording_time	INTEGER
23	direction	VARCHAR
24	overflowed_to	VARCHAR
25	voicemail	BOOLEAN
26	wait_time	INTEGER
27	recording_time	INTEGER
28	time_to_answer	INTEGER
29	exceeded_queue_time	BOOLEAN
30	hold_time	INTEGER
31	ticket_id	INTEGER
32	quality_issues	VARCHAR
33	wrap_up_time	INTEGER
34	recording_control_interactions	INTEGER
35	call_recording_consent_action	VARCHAR
36	callback	BOOLEAN
37	consultation_time	INTEGER
38	phone_number	VARCHAR
39	talk_time	INTEGER
40	call_recording_consent	VARCHAR

Table: ivr_routes

No	Column Name	Type	Notes
1	ivr_menu_id	INTEGER
2	ivr_id	INTEGER
3	option_text	VARCHAR
4	greeting	VARCHAR
5	options	VARCHAR
6	action	VARCHAR
7	keypress	VARCHAR
8	id	INTEGER	Primary Key
9	overflow_options	VARCHAR

Table: ivrs

No	Column Name	Type	Notes
1	phone_number_names	VARCHAR
2	phone_number_ids	VARCHAR
3	name	VARCHAR
4	id	INTEGER	Primary Key
5	menus	VARCHAR

External Resources

• Zendesk Docs
• Account Overview
• Agents Activity
• Agents Overview
• Call Legs
• Current Queue Activity
• Greeting Categories
• Ivr Menus
• Ivr Routes
• Phone Numbers
• 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.