Reference

Endpoint Delete Tickets (Bulk)

Name

delete_tickets

Description

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

Related Tables

Tickets (Bulk)

Parameters

Parameter Required Options
Name: ticket_ids

Label: Ticket ID(S) - Use Comma for multiple (e.g. 111,222)

 YES

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
job_id DT_WSTR nvarchar(100) 100
message DT_WSTR nvarchar(2000) 2000
total DT_I4 int
job_status DT_WSTR nvarchar(50) 50
url DT_WSTR nvarchar(500) 500
title DT_WSTR nvarchar(255) 255
errors DT_WSTR nvarchar(1000) 1000
ticket_id DT_I8 bigint
status DT_WSTR nvarchar(50) 50
success DT_BOOL bit
If the column you are looking for is missing, consider customizing Zendesk Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
$$ticket_ids DT_WSTR nvarchar(2000) 2000
Required columns that you need to supply are bolded.

Examples

SSIS

Use Zendesk Connector in API Source or in API Destination SSIS Data Flow components to read or write data.

API Source

API Source - Zendesk
Zendesk Connector can be used to integrate Zendesk REST API in your App / BI Tools. You can read/write data about Tickets, Activity, Users, Organizations and more.
Zendesk
Delete Tickets (Bulk)
Required Parameters
Ticket ID(S) - Use Comma for multiple (e.g. 111,222) Fill-in the parameter...
SSIS API Source - Read from table or endpoint

API Destination

This Endpoint belongs to the Tickets (Bulk) table, therefore it is better to use it, instead of accessing the endpoint directly. Use this table and table-operation pair to delete tickets:

API Destination - Zendesk
Zendesk Connector can be used to integrate Zendesk REST API in your App / BI Tools. You can read/write data about Tickets, Activity, Users, Organizations and more.
Zendesk
Tickets (Bulk)
Delete
Required Parameters
Ticket ID(S) - Use Comma for multiple (e.g. 111,222) Fill-in the parameter...
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Delete multiple by tickets by Id list - BULK (comma seperated - max 100 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).

SQL Server

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

Delete multiple by tickets by Id list - BULK (comma seperated - max 100 ids) 

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).