Query TicketAudits in Zendesk.
Table Specific Information
SelectThe 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.
|Id [KEY]||Long||Automatically assigned when creating audits.|
|TicketId||Integer||The ID of the associated ticket.|
|AuthorId||Long||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 user who created the audit.|