BizTalk Adapter for Zendesk

Build 20.0.7587

Automations

Create, update, delete, and query Automations 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 Automations WHERE Id = '123'

SELECT * FROM Automations Order By Position 

SELECT * FROM Automations Order By CreatedAt  

SELECT * FROM Automations Order By UpdatedAt

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.

Insert

The Title, ConditionsAll, and Actions fields are required to insert. Allowed for agents.

INSERT INTO Automations(Title, ConditionsAll, Actions) VALUES('Roger Wilco II', '[{ \"field\": \"status\", \"operator\": \"is\",\"value\": \"open\" }, {\"field\": \"priority\", \"operator\": \"less_than\", \"value\": \"high\" }]', '[{\"field\": \"status\", \"value": \"solved\"}]')

Update

You must specify the Id of the automation to update. Title is required. Active and Position are optional. Updating an action updates the containing array, clearing the other actions. Include all your actions when updating any action. Allowed for agents.

UPDATE Automations SET Title='Roger Wilco III' WHERE Id = '123'

Delete

You must specify the Id of the automation to delete it. Allowed for agents.

DELETE FROM Automations WHERE Id = '123'

Columns

Name Type ReadOnly Description
Id [KEY] Long True

Automatically assigned when created.

Title String False

The title of the automation.

Active Boolean False

Whether the automation is active.

Position Integer False

The position of the automation.

ConditionsAll String False

An object that describes the conditions under which the automation will execute.

ConditionsAny String False

An object that describes the conditions under which the automation will execute.

Actions String False

An object describing what the automation will do.

CreatedAt Datetime True

The time the automation was created.

UpdatedAt Datetime True

The time of the last update of the automation.

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