TDV Adapter for Zendesk

Build 21.0.8137


Query and delete Suspended Tickets in Zendesk.

Table Specific Information


The following queries are processed server side while other filters are processed client side within the adapter.
SELECT * FROM SuspendedTickets

SELECT * FROM SuspendedTickets WHERE Id = '123'

SELECT * FROM SuspendedTickets Order By AuthorEmail

SELECT * FROM SuspendedTickets Order By Cause

SELECT * FROM SuspendedTickets Order By Subject

SELECT * FROM SuspendedTickets Order By CreatedAt

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any other search criteria will be ignored and an unfiltered response will be returned.


You must specify the Id of the suspended ticket to delete it. Allowed for unrestricted agents.

DELETE FROM SuspendedTickets WHERE Id='123'


Name Type ReadOnly References Description
Id [KEY] Long True

Automatically assigned when the ticket is created.

TicketId Integer True


The ticket ID this suspended email is associated with, if available.

MessageId String True

The ID of the email, if available.

BrandId Long True


The id of the brand this ticket is associated with - only applicable for enterprise accounts.

Recipient String True

The original recipient e-mail address of the ticket.

Subject String True

The value of the subject field for this ticket.

Content String True

The content that was flagged.

AuthorId Long True

The id of author.

AuthorName String True

The name of author.

AuthorEmail String True

The email of author.

Cause String True

Why the ticket was suspended.

CreatedAt Datetime True

When this record was created.

UpdatedAt Datetime True

When this record last got updated.

ViaChannel String True


ViaSourceFromId Long True


ViaSourceFromTitle String True


ViaSourceTo String True


ViaSourceRel String True


Url String True

The API url of this ticket.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137