Create, Update, Delete and Query Group SLA Policies in Zendesk.

Table Specific Information

Select

The following queries are processed server side while other filters are processed client side within the connector.

SELECT * FROM GroupSlaPolicies

SELECT * FROM GroupSlaPolicies WHERE Id = '01HXV0PT0DMK4MTFNK9Y6ENFJA'

Insert

The Title and Filter fields are required to insert. Allowed for admins.

INSERT INTO GroupSlaPolicies (Title, Description, Position, Filter) VALUES('Title test', 'desc' ,3, '{"all":[{"field":"group_id","operator":"includes","value":[9634300495132]}]}

Update

You must specify the Id of the GroupSlaPolicy to update. Allowed for admins.

UPDATE GroupSlaPolicies SET Title = 'Updated title' WHERE Id = '01HXV6JCGCDZGJ851VPQZWMG1E'

Delete

You must specify the Id of the GroupSlaPolicy to delete it. Allowed for admins.

DELETE FROM GroupSlaPolicies WHERE Id = '01HXV6JCGCDZGJ851VPQZWMG1E'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	String	True		Automatically assigned when created.
Title	String	False		The title of the Group SLA policy.
Position	Integer	False		Position of the Group SLA policy. This position determines the order in which policies are matched to tickets. If not specified, the Group SLA policy is added at the last position.
Description	String	False		The description of the Group SLA policy.
PolicyMetrics	String	False		Array of policy metric objects.
CreatedAt	Datetime	True		The time the Group SLA policy was created.
UpdatedAt	Datetime	True		The time of the last update of the Group SLA policy.
Filter	String	False		An object that describes the conditions a ticket must match for a Group SLA policy to be applied to the ticket.
Url	String	True		URL of the Group SLA policy record.