Zendesk Chat
Zendesk Chat ETL connector for data replication
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
- Signin to Daton
- Select ZendeskChat from Integrations page
- Provide Integration Name, Replication Frequency, and History. Integration name would be used in creating tables for the integration and cannot be changed later
- Provide ZendeskChat Subdomain, LoginId, and Password to authorize Daton to periodically extract data from ZendeskChat
- Post successful authentication, you will be prompted to choose from the list of available tables
- Then select all required fields for each table
- Submit the integration
Workflow
- 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
- Users would be able to edit/pause/re-activate/delete integration anytime
- 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 |