ScheduleCalendars
Retrieves a list of schedule calendars associated with your employees or company.
Table Specific Information
Select
Query the ScheduleCalendars table. The connector will use the TSheets API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the connector.
- Id field supports the '=' and IN operators.
- LastModified field supports the <=,<,>=,>,= operators.
For example, the following queries are processed server side:
SELECT * FROM ScheduleCalendars WHERE Id IN (72595, 72597) SELECT * FROM ScheduleCalendars WHERE LastModified < '2019-01-01 18:30'
Columns
| Name | Type | Description |
| Id [KEY] | Integer | Id of the schedule calendar. |
| Name | String | The name of the schedule calendar. |
| Created | Datetime | Date/time when this schedule calendar was created |
| LastModified | Datetime | Date/time when this schedule calendar was last modified. |