Create, update, delete, and query Schedules in Zendesk.
Table Specific Information
SelectThe following queries are processed server side while other filters are processed client side within the adapter.
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.
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')
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'
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'
Automatically assigned upon creation.
Id of the schedule the holiday belongs to.
Name of the holiday.
Time when the holiday starts.
Time when the holiday ends.