Query and delete Suspended Tickets in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the connector.

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.

Delete

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

DELETE FROM SuspendedTickets WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when the ticket is created.
TicketId	Integer	True	Tickets.Id	The ticket ID this suspended email is associated with, if available.
MessageId	String	True		The ID of the email, if available.
BrandId	Long	True	Brands.Id	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.