Query TicketAudits in Zendesk.

Table Specific Information

Select

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

SELECT * FROM TicketAudits

SELECT * FROM TicketAudits WHERE TicketId = '123'

SELECT * FROM TicketAudits WHERE TicketId = '123' AND Id = '456'

You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Columns

Name	Type	References	Description
Id [KEY]	Long		Automatically assigned when creating audits.
TicketId	Integer	Tickets.Id	The ID of the associated ticket.
AuthorId	Long	Users.Id	The user who created the audit.
CreatedAt	Datetime		The time the audit was created.
Metadata	String		Metadata for the audit, custom and system data.
ViaChannel	String		This object explains how this audit was created. This does not update on every request.
ViaSource	String		This object explains how this audit was created. This does not update on every request.
Events	String		The Array of Events that happened in this Audit.