JDBC Driver for Zendesk

Build 20.0.7587

Triggers

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 driver.
SELECT * FROM Triggers

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 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.

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