API Data Provider - Online Help

Schedules

Scheduled shifts and related schedule data for an employee over a date range. One row per query (per employee/date-range read), with each part of the response exposed as its own aggregate column: Shifts, PayCodeEdits, LeaveEdits, Availabilities, Holidays, DayLocks, Employees, OpenShiftsList, ScheduleDayList, ExpandedJobs, ScheduleTags. No HyperFind support - reads one employee at a time by PersonId.

Columns

Name Type References
PersonId [KEY] Long

Employees.PersonId

Shifts String
PayCodeEdits String
LeaveEdits String
Availabilities String
Holidays String
DayLocks String
Employees String
OpenShiftsList String
ScheduleDayList String
ExpandedJobs String
ScheduleTags String

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770.0