Endpoint

Delete Tickets (Bulk)

Name

delete_tickets

Delete multiple tickets in a single request. This is faster than row by row operation. [API reference]

Parameter	Label	Required	Options	Description
ticket_ids	Ticket ID(S) - Use Comma for multiple (e.g. 111,222)	YES

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`
title	`DT_WSTR`	`nvarchar(255)`	255	`False`
errors	`DT_WSTR`	`nvarchar(1000)`	1000	`False`
ticket_id	`DT_I8`	`bigint`		`False`
status	`DT_WSTR`	`nvarchar(50)`	50	`False`
success	`DT_BOOL`	`bit`		`False`

If the column you are looking for is missing, consider customizing Zendesk Connector.

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
$$ticket_ids	`DT_WSTR`	`nvarchar(2000)`	2000	`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)

Delete

Use these SQL queries in your ODBC application data source:

SELECT * FROM delete_tickets
WHERE Id = 'abcd-1234-ticket_ids'

DELETE FROM Tickets_Bulk WHERE [$$ticket_ids]='111,222,333'

delete_tickets endpoint belongs to Tickets_Bulk table(s), and can therefore be used via those table(s).

Use these SQL queries in SQL Server after you create a data source in Data Gateway:

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM delete_tickets
WHERE Id = ''abcd-1234-ticket_ids''';

EXEC (@MyQuery) AT [LS_TO_ZENDESK_IN_GATEWAY];

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Tickets_Bulk WHERE [$$ticket_ids]=''111,222,333''';

EXEC (@MyQuery) AT [LS_TO_ZENDESK_IN_GATEWAY];

delete_tickets endpoint belongs to Tickets_Bulk table(s), and can therefore be used via those table(s).