API Data Provider - Online Help
Tanda Profile
Connecting to Tanda
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
ActiveShifts
AdoptionMetrics
AvailableAwardTemplates
AwardTags
CognitiveCreatorConfigurations
CurrentRoster
CurrentTimesheets
CurrentUser
CustomEvents
DatastreamJoins
DataStreamPredictedStoreStats
DataStreams
DataStreamStoreStats
Departments
DeviceClockIns
Devices
EmployeePersonalDetails
EnabledAwardTemplates
InactiveUsers
LeaveBalances
LeaveRequests
LocationPredictedStoreStats
Locations
Organisations
PersonalDetails
PlatformObjects
PlatformRoles
Qualifications
RecommendedHours
Schedules
ScheduleSwapPlans
ScheduleSwapProposals
ShiftBreaks
ShiftDetails
ShiftLimits
ShiftReminders
Shifts
StatTypes
TeamCognitiveCreatorConfigurations
TimeClockQuestions
TimesheetsOnDate
Unavailabilities
UserClockIns
UserCurrentTimesheets
UserLeaveTypes
Users
UserTimesheetsOnDate
WageComparisons
ShiftDetails
Returns shift details.
Columns
Name
Type
References
Id [KEY]
Integer
Name
String
DepartmentId
Integer