EndPoint Update Tickets (Bulk)

Contents

Name

put_tickets

Update 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
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

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