Tanda Tables
The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.
Tanda Tables
| Name | Description |
| ActiveShifts | Returns a list of shifts that are taking place now. For each shift, returns the user ID, the shift ID, and the shift's current status, which could be either clocked_in or on_break. Shifts are returned if they have a start time and no finish time. |
| AdoptionMetrics | Provides a summary of adoption of key product features across the organisation. Number of weeks to aggregate data for is required to be specified in Where clause. |
| AvailableAwardTemplates | Returns a full list of award templates available in Tanda. |
| AwardTags | Returns award tags. |
| CognitiveCreatorConfigurations | Gets all your Cognitive Creator Configurations. |
| CurrentRoster | Returns information about the current roster. |
| CurrentTimesheets | Returns information about the current timesheets. |
| CurrentUser | Returns information about the current user. |
| CustomEvents | Returns a full list of custom events in a single request. |
| DatastreamJoins | Returns data stream joins. |
| DataStreamPredictedStoreStats | Returns predicted store stats for datastream. |
| DataStreams | Returns data streams. |
| DataStreamStoreStats | Returns store stats for datastream. |
| Departments | Returns information about all teams/departments. |
| DeviceClockIns | Returns clock ins for device. |
| Devices | Returns devices. |
| EmployeePersonalDetails | Returns employee's personal details. |
| EnabledAwardTemplates | Returns enabled award templates. |
| InactiveUsers | Returns information about inactive users. |
| LeaveBalances | Returns leave balances. |
| LeaveRequests | Returns a list of leave requests. |
| LocationPredictedStoreStats | Returns predicted store stats for a given location. |
| Locations | Returns information about locations. |
| Organisations | Returns organisations. |
| PersonalDetails | Returns the personal details of the currently authenticated user. |
| PlatformObjects | Returns all of your current platform objects. |
| PlatformRoles | Returns platform roles. |
| Qualifications | Returns qualifications. |
| RecommendedHours | Get the recommended hours of work for a department, for a given date range. |
| Schedules | Returns a list of schedules. |
| ScheduleSwapPlans | Returns a list of schedule swap plans. |
| ScheduleSwapProposals | Returns a list of schedule swap proposals. |
| ShiftBreaks | Returns shift's breaks. |
| ShiftDetails | Returns shift details. |
| ShiftLimits | Returns the first and last shifts (based on start date/time) out of all shifts owned by the given users. |
| ShiftReminders | Returns shift reminders. |
| Shifts | Returns a list of Shifts by specifying FromDate and ToDate or Id(s) or UserId(s). |
| StatTypes | Returns stat types. |
| TeamCognitiveCreatorConfigurations | Get Cognitive Creator Configuration for a team/department. |
| TimeClockQuestions | Returns timeclock questions. |
| TimesheetsOnDate | Returns information about the timesheets on a date. |
| Unavailabilities | Returns a list of unavailabilities. |
| UserClockIns | Returns clock ins for user. |
| UserCurrentTimesheets | Returns information about the current timesheets for a given user. |
| UserLeaveTypes | Returns leave request types with details for a user. |
| Users | Returns information about all visible users. |
| UserTimesheetsOnDate | Returns information about the timesheets for a given user on a date. |
| WageComparisons | Returns wage comparisons. |