Schema Information- Zendesk Chat
Discover the key aspects of schema information and zendesk chat strategies in this informative article, providing you with valuable insights on how to optimize your data organization and streamline your chat analysis process.
Schema Information- Zendesk Chat
Discover the key aspects of schema information and zendesk chat strategies in this informative article, providing you with valuable insights on how to optimize your data organization and streamline your chat analysis process.
Tables/APIs
The following tables are associated with the Zendesk Chat connector:
Agents
Purpose: This lists all the agents for your account.
Source API Documentation: API DOC
Replication: Key-Based Replication
Replication Key: created_date
Fields
Name |
Datatype |
enabled_departments |
STRING |
| last_name | STRING |
| departments | STRING |
first_name |
STRING |
display_name |
STRING |
role_id |
NUMERIC |
email |
STRING |
enabled |
BOOLEAN |
id |
NUMERIC |
create_date |
TIMESTAMP |
| last_login | TIMESTAMP |
login_count |
NUMERIC |
roles |
RECORD |
| skills | STRING |
Departments
Purpose: Lists all the departments for your account.
Source API Documentation: API DOC
Replication: Full Replication
Replication Key: NA
Fields
Name |
Datatype |
id |
NUMERIC |
name |
STRING |
description |
STRING |
enabled |
BOOLEAN |
members |
STRING |
settings |
RECORD |
Shortcuts
Purpose: Fetches all the shortcuts for your account.
Source API Documentation: API DOC
Replication: Full Replication
Replication Key: NA
Fields
Name |
Datatype
|
id |
STRING |
name |
STRING |
scope |
STRING |
agents |
STRING |
options |
STRING |
message |
STRING |
tags |
STRING |
Triggers
Purpose: Lists all the triggers of an account.
Source API Documentation: API DOC
Replication: Full Replication
Replication Key: NA
Fields
Name |
Datatype |
id |
NUMERIC |
name |
STRING |
enabled |
BOOLEAN |
description |
STRING |
| definition | RECORD |
Chats
Purpose: Allows an account owner/administrator to list all the chats for the account.
Source API Documentation: API DOC
Replication: Key-Based Replication
Replication Key: timestamp
Fields
Name |
Datatype |
id |
STRING |
visitor |
RECORD |
started_by |
STRING |
session |
RECORD |
webpath |
RECORD |
timestamp |
TIMESTAMP |
| count | RECORD |
| duration | NUMERIC |
| response_time | RECORD |
| agent_names | STRING |
| agent_ids | STRING |
| triggered | BOOLEAN |
| unread | BOOLEAN |
| missed | BOOLEAN |
| type | STRING |
| history | RECORD |
| referrer_search_engine | STRING |
| referrer_search_terms | STRING |
| end_timestamp | TIMESTAMP |
| zendesk_ticket_id | NUMERIC |
| rating | STRING |