BizTalk Adapter for Zendesk

Build 20.0.7654


Query TicketMetricEvents in Zendesk.

Table Specific Information


To query all ticket metric events, use the following query:

SELECT * FROM TicketMetricEvents

To query ticket metric events, starting from a given time, use the following example:

SELECT * FROM TicketMetricEvents WHERE StartTime = '2017-02-05'

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.


Name Type References Description
Id [KEY] Long Automatically assigned when the record is created.
TicketId Integer


Id of the associated ticket.
Metric String One of the following: agent_work_time, pausable_update_time, periodic_update_time, reply_time, requester_wait_time, or resolution_time.
InstanceId Long The instance of the metric associated with the event.
Type String When this locale last got updated.
Time Datetime The time the event occurred.
Sla String Available if type is apply_sla. The SLA policy and target being enforced on the ticket and metric in question, if any.
Status String Available if type is update_status. Minutes since the metric has been open. See status.
Deleted Boolean Available if type is breach. In general, you can ignore any breach event when deleted is true.

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