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
