Reference

Endpoint Delete Ticket

Name

delete_ticket

Description

Delete ticket by id. [API reference]

Related Tables

Tickets (Row by Row)

Parameters

Parameter Required Options
Name: id

Label: Ticket ID for Delete

 YES

Output Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
Response DT_WSTR nvarchar(10) 10
If the column you are looking for is missing, consider customizing Zendesk Connector.

Input Columns

Label Data Type (SSIS) Data Type (SQL) Length Description
id DT_I8 bigint
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 Ticket
Required Parameters
Ticket ID for Delete Fill-in the parameter...
Optional Parameters
RawOutputDataRowTemplate {Response:'Deleted'}
EnableRawOutputModeSingleRow True
SSIS API Source - Read from table or endpoint

API Destination

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

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 (Row by Row)
Delete
Required Parameters
Ticket ID for Delete Fill-in the parameter...
Optional Parameters
RawOutputDataRowTemplate {Response:'Deleted'}
EnableRawOutputModeSingleRow True
SSIS API Destination - Access table operation

ODBC application

Use these SQL queries in your ODBC application data source:

Delete a ticket by Id 

DELETE FROM Tickets WHERE Id=111

delete_ticket endpoint belongs to Tickets 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 a ticket by Id 

DECLARE @MyQuery NVARCHAR(MAX) = 'DELETE FROM Tickets WHERE Id=111';

EXEC (@MyQuery) AT [LS_TO_ZENDESK_IN_GATEWAY];

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