Delete Ticket

Parameters

Output Columns

Input Columns

Examples

SSIS

Use Zendesk Connector in API Source component to read data or in API Destination component to read/write data:

Delete rows from Tickets (Row by Row) table using API Destination

This Endpoint belongs to Tickets (Row by Row) table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Zendesk

Tickets (Row by Row)

Delete

ODBC application

Use these SQL queries in your ODBC application data source:

Delete ticket

SELECT * FROM delete_ticket
WITH
(
    "id" = 'abcd-1234-id'
)

Delete a ticket by Id

DELETE FROM Tickets WHERE Id=111

SQL Server

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

Delete ticket

DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM delete_ticket
WITH
(
    "id" = ''abcd-1234-id''
)';

EXEC (@MyQuery) AT [LS_TO_ZENDESK_IN_GATEWAY];

Delete a ticket by Id

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

EXEC (@MyQuery) AT [LS_TO_ZENDESK_IN_GATEWAY];