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 |
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 |
Last updated