JDBC Driver for Zendesk

Build 22.0.8462

Holidays

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 Holidays

SELECT * FROM Holidays WHERE ScheduleId = '123'

SELECT * FROM Holidays WHERE ScheduleId = '123' AND Id = '456'

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 ScheduleId, Name, StartDate and EndDate fields are required to insert. Allowed for admins.

INSERT INTO Holidays (ScheduleId, Name, StartDate,EndDate) VALUES('360000022454','Christmas','2016-12-25', '2016-12-25')

Update

You must specify the ScheduleId and Id of the holiday to update.Allowed for admins.

UPDATE Holidays SET Name='Christmas', StartDate='2018-12-25',EndDate='2018-12-25'  WHERE ScheduleId='123' AND Id = '456'

Delete

You must specify the ScheduleId and Id of the holiday to delete it. Allowed for admins.

DELETE FROM Holidays WHERE ScheduleId='123' AND Id = '456'

Columns

Name Type ReadOnly References Description
Id [KEY] Long True

Automatically assigned upon creation.

ScheduleId Long False

Schedules.Id

Id of the schedule the holiday belongs to.

Name String False

Name of the holiday.

StartDate Date False

Time when the holiday starts.

EndDate Date False

Time when the holiday ends.

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