SuspendedTickets
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 add-in.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
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. |