Zendesk Chat

Zendesk Chat ETL connector for data replication

Snapshot

Features	Details
Release Status	Released
Source API Version
Table Selection	Yes
Column Selection	Yes
Edit Integration	Yes
Replication Type Selection	No
Authentication Parameters	ZendeskChat Subdomain ZendeskChat LoginId ZendeskChat Password
Replication Type	Key Based Replication Full Replication
Replication Key	Date
Suggested Replication Frequency	24 hrs

Tables/APIs Supported
Agents	Departments
Goals	Shortcuts
Triggers	Bans
Chats

Integrate ZendeskChat with Daton

1. Signin to Daton

2. Select ZendeskChat from Integrations page

3. Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later

4. Provide ZendeskChat Subdomain, LoginId, and Password to authorize Daton to periodically extract data from ZendeskChat

5. Post successful authentication, you will be prompted to choose from the list of available tables

6. Then select all required fields for each table

7. Submit the integration

Workflow

1. Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse

2. Users would be able to edit/pause/re-activate/delete integration anytime

3. Users can view job status and process logs from the integration details page by clicking on the integration name from the active list

ZendeskChat Data

Agents

Purpose: This lists all the agents for your account.

Source API Documentation https://developer.zendesk.com/rest_api/docs/chat/agents#get-all-agents

Replication: Key-Based Replication

Replication Key: created_date

Fields

Name	Target Datatype
id	INTEGER
last_login	DATETIME
last_name	STRING
display_name	STRING
create_date	DATETIME
email	STRING
roles	RECORD
role_id	INTEGER
login_count	INTEGER
first_name	STRING
enabled	BOOLEAN
departments	STRING
skills	STRING

Departments

Purpose: Lists all the departments for your account.

Source API Documentation https://developer.zendesk.com/rest_api/docs/chat/departments

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
id	INTEGER
name	STRING
description	STRING
enabled	INTEGER
members	STRING
settings	STRING

Goals

Purpose: This lists all the goals for your account.

Source API Documentation https://developer.zendesk.com/rest_api/docs/chat/goals

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
id	INTEGER
name	STRING
description	STRING
enabled	INTEGER
attribution_model	STRING
attribution_period	INTEGER
settings	RECORD

Shortcuts

Purpose: Fetches all the shortcuts for your account.

Source API Documentation https://developer.zendesk.com/rest_api/docs/chat/shortcuts

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
id	INTEGER
name	STRING
scope	STRING
agents	STRING
departments	STRING
options	INTEGER
message	STRING
tags	STRING

Triggers

Purpose: Lists all the triggers of an account.

Source API Documentation https://developer.zendesk.com/rest_api/docs/chat/triggers

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
id	INTEGER
name	STRING
enabled	INTEGER
description	STRING

Bans

Purpose: Lists the bans for the account.

Source API Documentation https://developer.zendesk.com/rest_api/docs/chat/bans

Replication: Full Replication

Replication Key: NA

Fields

Name	Target Datatype
visitor	RECORD
ip_address	RECORD

Chats

Purpose: Allows an account owner/administrator to list all the chats for the account.

Source API Documentation https://developer.zendesk.com/rest_api/docs/chat/chats

Replication: Key-Based Replication

Replication Key: timestamp

Fields

Name	Target Datatype
department_id	INTEGER
comment	STRING
missed	BOOLEAN
rating	STRING
conversions	RECORD
type	STRING
webpath	RECORD
triggered	BOOLEAN
message	STRING
referrer_search_terms	STRING
referrer_search_engine	STRING
zendesk_ticket_id	INTEGER
unread	STRING
timestamp	STRING
end_timestamp	DATETIME
session	RECORD
history	RECORD
response_time	DATETIME
agent_names	STRING
visitor	RECORD
started_by	STRING
triggered_response	BOOLEAN
id	STRING
count	RECORD
agent_ids	STRING
department_name	STRING
duration	INTEGER