Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard. To find out more about tables and stored procedures, please navigate to their corresponding entries in this help document.
CData FireDAC Components for TSheets Views
| Name | Description |
| CurrentTotalsReport | Report for the current totals (shift and day) along with additional information provided for those who are currently on the clock. |
| Files | This table contains a list of file objects. |
| GeneralSettings | Retrieves a list of all effective settings associated with a single user. |
| GeofenceConfigs | Retrieves a list of all geofence configs. |
| GeoLocations | Retrieves a list of all geofence configs. |
| Groups | This table contains a list of all groups associated with your company. |
| JobcodeAssignments | Returns a list of all jobcode assignments associated with users. |
| JobCodes | This table contains a list of jobcodes associated with your company |
| LastModifiedTimestamps | Retrieves a list of last_modified timestamps associated with each requested API endpoint. |
| LocationMaps | Retrieves a list of all locations maps associated with your company. |
| Locations | Retrieves a list of all locations associated with your company. |
| ManagedClients | Retrieves a list of managed clients available from your account. |
| Notifications | Retrieves a list of notifications associated with your company. |
| PayrollReport | Payroll Report associated with a timeframe. |
| PayrollReportByJobCode | Payroll Report broken down by jobcode |
| ProjectReport | Retrieves a project report. |
| Reminders | Retrieves a list of reminders associated with your employees or company. |
| ScheduleCalendars | Retrieves a list of schedule calendars associated with your employees or company. |
| ScheduleEvents | Retrieves a list of schedule events associated with your employees or company. |
| Timesheets | This table contains a list of file objects. |
| UserPermissions | The rights assignable to an individual user. |
| Users | Retrieves a list of all users associated with your company. |