EndPoint Create Tickets (Bulk)

Contents

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.