Zendesk Connector
Documentation
Version: 9
Documentation

EndPoint Update Tickets (Bulk)


Name

put_tickets

Description

Update tickets in bulk (job is queued) and wait until done. This is faster than one request at a time [API reference]

Parameters

Parameter Label Required Options Description
There are no parameters

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
job_id DT_WSTR nvarchar(100) 100 False
message DT_WSTR nvarchar(2000) 2000 False
total DT_I4 int False
job_status DT_WSTR nvarchar(50) 50 False
url DT_WSTR nvarchar(500) 500 False
index DT_I4 int False
error DT_WSTR nvarchar(1000) 1000 False
details DT_WSTR nvarchar(4000) 4000 False
ticket_id DT_I8 bigint False
status DT_WSTR nvarchar(50) 50 False
success DT_BOOL bit False

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Raw Description
allow_attachments DT_BOOL bit False
allow_channelback DT_BOOL bit False
brand_id DT_I8 bigint False
followup_ids DT_WSTR nvarchar(1000) 1000 True
fields DT_WSTR nvarchar(1000) 1000 True
group_id DT_I8 bigint False
due_at DT_DBTIMESTAMP datetime False
collaborator_ids DT_WSTR nvarchar(1000) 1000 False
assignee_id DT_I8 bigint False
forum_topic_id DT_WSTR nvarchar(255) 255 False
email_cc_ids DT_WSTR nvarchar(1000) 1000 True
follower_ids DT_WSTR nvarchar(1000) 1000 True
id DT_I8 bigint False
sharing_agreement_ids DT_WSTR nvarchar(255) 255 True
organization_id DT_I8 bigint False
is_public DT_BOOL bit False
problem_id DT_WSTR nvarchar(255) 255 False
submitter_id DT_I8 bigint False
requester_email DT_WSTR nvarchar(255) 255 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
requester_id DT_I8 bigint False
comment_public DT_BOOL bit False
tags DT_WSTR nvarchar(1000) 1000 True
additional_tags DT_WSTR nvarchar(1000) 1000 True
remove_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
comment_author_id DT_I8 bigint False
subject DT_WSTR nvarchar(1012) 1012 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:

Update rows in Tickets (Bulk) table using API Destination

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

Zendesk
Tickets (Bulk)
Update
SSIS API Destination - Access table operation