Zendesk Support is a cloud-based customer support platform.
|Custom data||check||We support custom fields for the
We support the custom table
We do not support Zendesk custom objects.
|Fivetran data models||check||Get the models: source / transform|
We capture deletes in the
TICKET_FIELD_HISTORYtables using the
|Zendesk Chat||Using our Zendesk Chat connector|
|Zendesk Gather||Only Posts and Comments|
|Zendesk Guide||Only Articles|
|Zendesk Talk||Only Call Metrics|
Follow our step-by-step Zendesk Support setup guide to connect Zendesk Support with your destination using Fivetran connectors.
The Zendesk Support connector supports multithreading. Fivetran uses multiple parallel API requests to sync data from Zendesk systems to your destination. The connector’s sync speed depends on your Zendesk API quota.
This schema applies to all Zendesk Support connections created after 12/7/2017.
To display some information about ticket deletion, we artificially create a
TICKET_FIELD_HISTORY record when we detect a deleted ticket - it is not created from any audit event. This is because the source does not provide us event audit data for deleted tickets. Any ticket audit event indicating deletion of a ticket is added with a
null value in the
user_id column, and the
updated_at value is taken from the
updated_at value on the ticket that was deleted.
TICKET_FIELD_HISTORY.field_name is the custom field ID for custom fields. The
TICKET_CUSTOM_FIELD table contains the custom field title.
Schedule assignment for tickets is a Zendesk Enterprise feature. For all other accounts the default schedule applies to all tickets.
We sync the
SCHEDULE table only if you have created a schedule in Zendesk.
We sync the
TICKET_SCHEDULE table when you create a trigger with a set schedule action. Read Zendesk’s documentation for more information.
We exclude the
USER_VOTE tables from the sync by default because they can be large tables and may degrade performance. We also exclude the
AUDIT_LOG table from the sync by default. If you want to sync these tables, go to the Schema tab of your Fivetran dashboard and select the tables. Learn how in our connector schema documentation.
We sync the
TICKET_LINK table only if you have Administrator permissions and the Jira application is installed in your Zendesk Support account. For more information about setting up Zendesk Support for Jira integration, see Zendesk’s documentation.
Syncing empty tables and columnslink
The Zendesk Support connector doesn’t support the creation of empty tables and columns in your destination.
We create a table in the destination only if we can retrieve the table data from the source. If Zendesk doesn’t return data for the source table, we don’t create the table in your destination.