JDBC Driver for Zendesk

Build 22.0.8462

Schedules

Create, update, delete and query Schedules 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 Schedules

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

Insert

The Name and TimeZone fields are required to insert. Allowed for admins.

INSERT INTO Schedules (Name,TimeZone) VALUES('test','Eastern Time (US & Canada)')

Update

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

UPDATE Schedules SET Name='EMEA', TimeZone='London' WHERE Id = '123'

You can update the intervals of a Schedule by issuing a separate Update statement.

UPDATE Schedules SET Intervals='[{\"start_time\": 3420, \"end_time\": 3900}]' WHERE Id = '123'

Delete

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

DELETE FROM Schedules WHERE Id = '123'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Automatically assigned upon creation.

Name String False

Name of the schedule.

TimeZone String False

Time zone of the schedule.

Intervals String False

Array of intervals for the schedule.

CreatedAt Datetime True

Time the schedule was created.

UpdatedAt Datetime True

Time the schedule was last updated.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462