Zendesk Chat
Zendesk Chat ETL connector for data replication
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 | |
- 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
- 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
Agents
Purpose: This lists all the agents for your account.
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.
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.
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.
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.
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.
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.
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 modified 4yr ago