EndPoint Create Tickets (Bulk)

Name

post_tickets

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

Parameter	Label	Required	Options	Description
There are no parameters

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
job_id	`DT_WSTR`	`nvarchar(100)`	100	`False`
message	`DT_WSTR`	`nvarchar(2000)`	2000	`False`
total	`DT_I4`	`int`		`False`
status	`DT_WSTR`	`nvarchar(50)`	50	`False`
url	`DT_WSTR`	`nvarchar(500)`	500	`False`
account_id	`DT_I8`	`bigint`		`False`
ticket_id	`DT_I8`	`bigint`		`False`
index	`DT_I4`	`int`		`False`

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
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`
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`
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.

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

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)

Insert