BizTalk Adapter for Zendesk

Build 20.0.7587

SlaPolicies

Query SlaPolicies 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 SlaPolicies

SELECT * FROM SlaPolicies WHERE Id = '123'

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.
Title String The title of the SLA policy.
Description String The description of the SLA policy.
CreatedAt Datetime When this locale was created.
UpdatedAt Datetime When this locale last got updated.
Position Integer Position of the SLA policy, determines the order they will be matched. If not specified, SLA Policy is added as the last position.
FilterAll String An object that describes the conditions that a ticket must match in order for an SLA policy to be applied to that ticket.
FilterAny String An object that describes the conditions that a ticket must match in order for an SLA policy to be applied to that ticket.
PolicyMetrics String An object that describes the metric targets for each value of the priority field.

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