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

SELECT * FROM Triggers WHERE Active = true

SELECT * FROM Triggers ORDER BY Position

SELECT * FROM Triggers ORDER BY CreatedAt

SELECT * FROM Triggers 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 Triggers (Title, ConditionsAll, Actions) VALUES ('Roger Wilco', '[{ \"field\": \"status\", \"operator\": \"is\", \"value\": \"open\" }, { \"field\": \"priority\", \"operator\": \"less_than\", \"value\": \"high\" }]', '[{ \"field\": \"group_id\", \"value\": \"20455932\" }]')

Update

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

UPDATE Triggers 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 Triggers WHERE Id = '123'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Long	True		Automatically assigned when created.
Title	String	False		The title of the trigger.
Active	Boolean	False		Whether the trigger is active.
Position	Integer	False		Position of the trigger, determines the order they will execute in.
ConditionsAll	String	False		An object that describes the conditions under which the trigger will execute.
ConditionsAny	String	False		An object that describes the conditions under which the trigger will execute.
Actions	String	False		An object describing what the trigger will do.
Description	String	False		The description of the trigger.
CreatedAt	Datetime	True		The time the trigger was created.
UpdatedAt	Datetime	True		The time of the last update of the trigger.