BizTalk Adapter for Zendesk

Build 20.0.7587

TicketMetricEvents

Query TicketMetricEvents in Zendesk.

Table Specific Information

Select

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.

Columns

Name Type 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.7587