Talkdesk explore

Setting up the Talkdesk explore connector

No	Item	Required	Example	Notes
1	START DATE	Yes	2020-10-15T00:00:00	The date from which you'd like to replicate data for Talkdesk Explore API, in the format YYYY-MM-DDT00:00:00. All data generated after this date will be replicated.
2	TIMEZONE	No	Europe/London America/Los_Angeles	Timezone to use when generating reports. Only IANA timezones are supported (https://nodatime.org/TimeZones)
3	AUTH URL	Yes	https://xxxxxx.talkdeskid.com/oauth/token?grant_type=client_credentials	Talkdesk Auth URL. Only 'client_credentials' auth type supported at the moment.
4	API KEY	Yes		Talkdesk API key.

Tables in the Talkdesk explore connector

No	Table Name	Columns	Primary Keys	Read Mode	Inc. Sync Keys	API Info
1	ring_attempts	11
2	user_status	10	user_id	Full Refresh, Incremental	status_end_at
3	studio_flow_execution	13	flow_id	Full Refresh, Incremental	studio_flow_executions_aggregated.flow_execution_finished_time
4	calls	38	call_id	Full Refresh, Incremental	end_at
5	contacts	42	contact_id	Full Refresh, Incremental	finished_at

Table: ring_attempts

No	Column Name	Type	Notes
1	ring_attempt_duration	INTEGER
2	user_email	VARCHAR
3	user_name	VARCHAR
4	attempt_type	VARCHAR
5	ring_attempt_id	VARCHAR
6	ring_finished_at_time	VARCHAR
7	batch_ring_id	VARCHAR
8	interaction_id	VARCHAR
9	contact_id	VARCHAR
10	ring_started_at_time	VARCHAR
11	team_name	VARCHAR

Table: user_status

No	Column Name	Type	Notes
1	status_label	VARCHAR
2	user_email	VARCHAR
3	status_start_at	VARCHAR
4	user_id	VARCHAR	Primary Key
5	user_name	VARCHAR
6	status_end_at	VARCHAR	Incremental sync key
7	status_time	INTEGER
8	team_id	VARCHAR
9	is_user_active	BOOLEAN
10	team_name	VARCHAR

Table: studio_flow_execution

No	Column Name	Type	Notes
1	time_in_step	DOUBLE
2	origin_number	VARCHAR
3	destination_number	VARCHAR
4	step_execution_order	INTEGER
5	flow_name	VARCHAR
6	interaction_id	VARCHAR
7	exit	VARCHAR
8	component_title	VARCHAR
9	call_sid	VARCHAR
10	flow_id	VARCHAR	Primary Key
11	step_name	VARCHAR
12	studio_flow_executions_aggregated.flow_execution_finished_time	VARCHAR	Incremental sync key
13	timestamp	VARCHAR

Table: calls

No	Column Name	Type	Notes
1	talkdesk_phone_display_name	VARCHAR
2	end_at	VARCHAR	Incremental sync key
3	recording_url	VARCHAR
4	callsid	VARCHAR
5	notes	VARCHAR
6	handling_user_name	VARCHAR
7	mood	VARCHAR
8	user_name	VARCHAR
9	team_id	VARCHAR
10	type	VARCHAR
11	start_at	VARCHAR
12	is_if_no_answer	BOOLEAN
13	abandon_time	INTEGER
14	csat_survey_time	VARCHAR
15	total_time	INTEGER
16	is_mood_prompted	BOOLEAN
17	is_callback_from_queue	BOOLEAN
18	is_call_forwarding	BOOLEAN
19	csat_score	INTEGER
20	user_email	VARCHAR
21	wait_time	INTEGER
22	is_external_transfer	BOOLEAN
23	contact_phone_number	VARCHAR
24	user_voice_rating	INTEGER
25	ring_groups	VARCHAR
26	is_transfer	BOOLEAN
27	disposition_code	VARCHAR
28	hold_time	INTEGER
29	team_name	VARCHAR
30	call_id	VARCHAR	Primary Key
31	handling_user_email	VARCHAR
32	talkdesk_phone_number	VARCHAR
33	ivr_options	VARCHAR
34	handling_user_id	VARCHAR
35	user_id	VARCHAR
36	is_in_business_hours	BOOLEAN
37	talk_time	INTEGER
38	total_ringing_time	INTEGER

Table: contacts

No	Column Name	Type	Notes
1	handle_time	INTEGER
2	time_to_missed	INTEGER
3	finished_at	VARCHAR	Incremental sync key
4	direct_assignment_user	VARCHAR
5	user_name	VARCHAR
6	time_to_voicemail	INTEGER
7	ring_time	INTEGER
8	connected_at	VARCHAR
9	transfer_out_type	VARCHAR
10	team_id	VARCHAR
11	contact_id	VARCHAR	Primary Key
12	contact_person_number	VARCHAR
13	duration	INTEGER
14	abandon_time	INTEGER
15	contact_type	VARCHAR
16	after_call_work_time	INTEGER
17	within_service_level_threshold	VARCHAR
18	connect_time	INTEGER
19	phone_display_name	VARCHAR
20	direction	VARCHAR
21	short_abandon_time	INTEGER
22	handling_ring_groups	VARCHAR
23	hard_hold_time	INTEGER
24	wait_time	INTEGER
25	ring_groups	VARCHAR
26	transfer_in_type	VARCHAR
27	answered_at	VARCHAR
28	hold_time	INTEGER
29	interaction_id	VARCHAR
30	team_name	VARCHAR
31	direct_assignment_ids	VARCHAR
32	external_phone_number	VARCHAR
33	company_number	VARCHAR
34	inside_service_level	VARCHAR
35	user_id	VARCHAR
36	started_at	VARCHAR
37	soft_hold_time	INTEGER
38	inside_business_hours	VARCHAR
39	callback	VARCHAR
40	transfer_out	VARCHAR
41	talk_time	INTEGER
42	transfer_in	VARCHAR

External Resources

• Talkdesk Explore Api
• Calls Report
• User Status Report
• Studio Flow Execution Report
• Contacts Report
• Ring Attempts Report
• Executing A Report
• Getting Started With The Api

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.