Zendesk Batch Source
Plugin version: 1.2.0
This source reads objects from Zendesk. It extracts reportable data from the Zendesk objects. The Zendesk Batch Source plugin enables bulk data extraction from Zendesk. You can configure and execute bulk data transfers from Zendesk without any coding
Examples of objects are Article Comments, Post Comments, Requests Comments, Ticket Comments, Groups, Organizations, Satisfaction Ratings, Tags, Ticket Fields, Ticket Metrics, Ticket Metric Events, Tickets, Users. Tags object lists the 500 most popular tags in the last 60 days.
The data which should be read is specified using object and filters for that object.
Configuration
Property | Macro Enabled? | Description |
---|---|---|
Reference Name | No | Required. Name used to uniquely identify this source for lineage, annotating metadata. |
Use Connection (toggle yes/no) | No | Optional. Whether to use and existing connection. |
Browse Connections | Yes | Optional. The connection to add or import. |
Admin Email | Yes | Required. Zendesk admin email. |
API Token | Yes | Required. Zendesk API token. Can be obtained from the Zendesk Support Admin interface. For API Token generation, see the Zendesk documentation. |
Subdomains | Yes | Required. List of Zendesk Subdomains to read object from. |
Object to Pull | Yes | Optional. Objects to pull from Zendesk API. Default is Groups. |
Start Date | Yes | Optional. Â Filter data to include only records that have a Zendesk modified date that is greater than or equal to the specified date. The date must be provided in the date format: Format: Date, time, and time zone offset Format Syntax: YYYY-MM-DDThh:mm:ss+hh:mm Format Syntax: YYYY-MM-DDThh:mm:ss-hh:mm Format Syntax: YYYY-MM-DDThh:mm:ssZ Start Date is required for batch objects like: Ticket Comments, Organizations, Ticket Metric Events, Tickets, Users. |
End Date | Yes | Optional. Filter data to include only records that have a Zendesk modified date that is less than the specified date. The date must be provided in the date format: Format: Date, time, and time zone offset Format Syntax: YYYY-MM-DDThh:mm:ss+hh:mm Format Syntax: YYYY-MM-DDThh:mm:ss-hh:mm Format Syntax: YYYY-MM-DDThh:mm:ssZ If you enter an End Date and Start Date, the data is modified within a specific time window. If no value is provided, no upper bound is applied. |
Satisfaction Ratings Score | Yes | Filter Satisfaction Ratings object to include only records that have a Zendesk score equal to the specified score. Only applicable for the Satisfaction Rating object. Default is blank. |
Max Retry Count | Yes | Required. Maximum number of retry attempts. Default is 20. |
Connect Timeout | Yes | Required. Maximum time in seconds connection initialization can take. Default is 300. |
Read Timeout | Yes | Required. Maximum time in seconds fetching data from the server can take. Default is 300. |
Limitations
Zendesk plugin supports two types of pagination: offset and time-based pagination. Offset and Time-Based Pagination might result in data duplication.
Data Duplication issues with Zendesk APIs
This plugin can return duplicate records for offset and time-based exports as mentioned in Zendesk docs. Zendesk documentation
Objects that support offset and time-based exports: Users, Tickets, Ticket Metric Events, Organizations, and Ticket Comments.
To solve the duplication issue, add the Deduplicate plugin from the Analytics list after the Zendesk Batch Source in the pipeline.
Supported Zendesk Objects
Objects Name | Supported Pagination Type | Endpoint URI (https://{subDomain}.zendesk.com/api/v2/) |
---|---|---|
Users | Offset, Time-based | incremental/users.json |
Tickets | Offset, Time-based | incremental/tickets.json |
Ticket Metric Events | Offset, Time-based | incremental/ticket_metric_events.json |
Ticket Metrics | Offset | ticket_metrics.json |
Ticket Fields | Offset | ticket_fields.json |
Tags | Offset | tags.json |
Satisfaction Ratings | Offset | satisfaction_ratings.json |
Organizations | Offset, Time-based | incremental/organizations.json |
Groups | Offset | groups.json |
Ticket Comments | Offset, Time-based | incremental/ticket_events.json?include=comment_events |
Request Comments | Offset | requests/{requestId}/comments.json* |
Post Comments | Offset | community/users/{userId}/comments.json |
Article Comments | Offset | help_center/users/{userId}/comments.json |
The plugin retrieves the user and request lists, and the comments specific to a specific user and request.
Created in 2020 by Google Inc.