Zendesk Connector
Documentation
Version: 9
Documentation
Endpoint

Read Tickets (All)

Name

get_tickets

Description

Get a list of all tickets in your account [API reference]

Related Tables

Tickets (Row by Row) , Tickets (Bulk)

Parameters

Parameter Label Required Options Description
sort_by Sort By NO
Option Value
id id
assignee assignee
assignee.name assignee.name
created_at created_at
group group
locale locale
requester requester
requester.name requester.name
status status
subject subject
updated_at updated_at
Sort By field
sort_order Sort Order NO
Option Value
desc desc
asc asc
Sort order
include Extra Columns to Include NO
Option Value
Default
comment_count comment_count
external_id External ID for Ticket NO
PageSize Records Per Page (Max 100) NO

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
id DT_I8 bigint False
recipient DT_WSTR nvarchar(255) 255 False
subject DT_WSTR nvarchar(1000) 1000 False
status DT_WSTR nvarchar(28) 28 False
type DT_WSTR nvarchar(255) 255 False
priority DT_WSTR nvarchar(24) 24 False
description DT_NTEXT nvarchar(MAX) False
external_id DT_WSTR nvarchar(255) 255 False
created_at DT_DBTIMESTAMP datetime False
updated_at DT_DBTIMESTAMP datetime False
raw_subject DT_WSTR nvarchar(1000) 1000 False
url DT_WSTR nvarchar(500) 500 False
comment_count DT_I8 bigint False
requester_id DT_I8 bigint False
submitter_id DT_I8 bigint False
assignee_id DT_I8 bigint False
organization_id DT_I8 bigint False
group_id DT_I8 bigint False
collaborator_ids DT_WSTR nvarchar(1000) 1000 False
collaborator_ids_1 DT_WSTR nvarchar(20) 20 False
collaborator_ids_2 DT_WSTR nvarchar(20) 20 False
collaborator_ids_3 DT_WSTR nvarchar(20) 20 False
follower_ids DT_WSTR nvarchar(1000) 1000 False
follower_ids_1 DT_WSTR nvarchar(20) 20 False
follower_ids_2 DT_WSTR nvarchar(20) 20 False
follower_ids_3 DT_WSTR nvarchar(20) 20 False
email_cc_ids DT_WSTR nvarchar(1000) 1000 False
email_cc_ids_1 DT_WSTR nvarchar(20) 20 False
email_cc_ids_2 DT_WSTR nvarchar(20) 20 False
email_cc_ids_3 DT_WSTR nvarchar(20) 20 False
forum_topic_id DT_WSTR nvarchar(255) 255 False
problem_id DT_WSTR nvarchar(255) 255 False
has_incidents DT_BOOL bit False
is_public DT_BOOL bit False
due_at DT_DBTIMESTAMP datetime False
tags DT_WSTR nvarchar(1000) 1000 False
tags_1 DT_WSTR nvarchar(50) 50 False
tags_2 DT_WSTR nvarchar(50) 50 False
tags_3 DT_WSTR nvarchar(50) 50 False
tags_4 DT_WSTR nvarchar(50) 50 False
tags_5 DT_WSTR nvarchar(50) 50 False
custom_fields DT_WSTR nvarchar(1000) 1000 False
custom_fields_1_id DT_WSTR nvarchar(20) 20 False
custom_fields_1_value DT_WSTR nvarchar(1000) 1000 False
custom_fields_2_id DT_WSTR nvarchar(20) 20 False
custom_fields_2_value DT_WSTR nvarchar(1000) 1000 False
custom_fields_3_id DT_WSTR nvarchar(20) 20 False
custom_fields_3_value DT_WSTR nvarchar(1000) 1000 False
custom_fields_4_id DT_WSTR nvarchar(20) 20 False
custom_fields_4_value DT_WSTR nvarchar(1000) 1000 False
custom_fields_5_id DT_WSTR nvarchar(20) 20 False
custom_fields_5_value DT_WSTR nvarchar(1000) 1000 False
via_followup_source_id DT_I8 bigint False
satisfaction_rating_id DT_I8 bigint False
satisfaction_rating_score DT_WSTR nvarchar(20) 20 False
satisfaction_rating_comment DT_WSTR nvarchar(1000) 1000 False
sharing_agreement_ids DT_WSTR nvarchar(255) 255 False
fields DT_WSTR nvarchar(1000) 1000 False
followup_ids DT_WSTR nvarchar(1000) 1000 False
brand_id DT_I8 bigint False
allow_channelback DT_BOOL bit False
allow_attachments DT_BOOL bit False
via_channel DT_WSTR nvarchar(100) 100 False
via_source_rel DT_WSTR nvarchar(255) 255 False
via_source_from_address DT_WSTR nvarchar(500) 500 False
via_source_from_name DT_WSTR nvarchar(500) 500 False
via_source_to_name DT_WSTR nvarchar(500) 500 False
via_source_to_address DT_WSTR nvarchar(500) 500 False
via_source_from_ticket_id DT_I8 bigint False
via_source_from_subject DT_WSTR nvarchar(1000) 1000 False
via_source_from_channel DT_WSTR nvarchar(50) 50 False
custom_field_[$parent.id$] DT_WSTR nvarchar(4000) 4000 False
If the column you are looking for is missing, consider customizing Zendesk Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
subject DT_WSTR nvarchar(1012) 1012 False
recipient DT_WSTR nvarchar(255) 255 False
status DT_WSTR nvarchar(28) 28 False
type DT_WSTR nvarchar(255) 255 False
priority DT_WSTR nvarchar(24) 24 False
comment_body DT_NTEXT nvarchar(MAX) False
comment_body_html DT_NTEXT nvarchar(MAX) False
comment_public DT_BOOL bit False
comment_author_id DT_I8 bigint False
tags DT_WSTR nvarchar(1000) 1000 True
custom_fields DT_WSTR nvarchar(1000) 1000 True
external_id DT_WSTR nvarchar(255) 255 False
requester_name DT_WSTR nvarchar(255) 255 False
requester_email DT_WSTR nvarchar(255) 255 False
requester_id DT_I8 bigint False
submitter_id DT_I8 bigint False
assignee_id DT_I8 bigint False
organization_id DT_I8 bigint False
group_id DT_I8 bigint False
collaborator_ids DT_WSTR nvarchar(1000) 1000 False
follower_ids DT_WSTR nvarchar(1000) 1000 True
email_cc_ids DT_WSTR nvarchar(1000) 1000 True
forum_topic_id DT_WSTR nvarchar(255) 255 False
problem_id DT_WSTR nvarchar(255) 255 False
is_public DT_BOOL bit False
due_at DT_DBTIMESTAMP datetime False
sharing_agreement_ids DT_WSTR nvarchar(255) 255 True
fields DT_WSTR nvarchar(1000) 1000 True
followup_ids DT_WSTR nvarchar(1000) 1000 True
brand_id DT_I8 bigint False
allow_channelback DT_BOOL bit False
allow_attachments DT_BOOL bit False
Required columns that you need to supply are bolded.

Examples

SSIS

Use Zendesk Connector in API Source component to read data or in API Destination component to read/write data:

Read from Tickets (Row by Row) table using API Destination

This Endpoint belongs to Tickets (Row by Row) table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Zendesk
Tickets (Row by Row)
Select
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Read tickets 

SELECT * FROM get_tickets

Get all Tickets

Read all tickets from Zendesk 

SELECT * FROM Tickets

get_tickets endpoint belongs to Tickets , Tickets_Bulk table(s), and can therefore be used via those table(s).

SQL Server

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

Read tickets 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_tickets';

EXEC (@MyQuery) AT [LS_TO_ZENDESK_IN_GATEWAY];

Get all Tickets

Read all tickets from Zendesk 

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM Tickets';

EXEC (@MyQuery) AT [LS_TO_ZENDESK_IN_GATEWAY];

get_tickets endpoint belongs to Tickets , Tickets_Bulk table(s), and can therefore be used via those table(s).