JDBC Driver for Zendesk

Build 20.0.7587

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 driver.
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.

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 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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587