BizTalk Adapter for Zendesk

Build 20.0.7587

TicketAudits

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

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587