API Data Provider - Online Help
ClickTime Profile
Connecting to ClickTime
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
Allocations
Clients
Company
CurrentUser
CustomMessages
Divisions
EmploymentTypes
HolidayEntries
Jobs
ManagedDivisions
ManagedTimesheetActions
ManagedTimesheetHistory
ManagedTimesheetHolidayEntries
ManagedTimesheets
ManagedTimesheetsByDate
ManagedTimesheetsHolidayEntries
ManagedTimesheetsTimeEntries
ManagedTimesheetsTimeOff
ManagedTimesheetTimeOff
ManagedUsers
MyClients
MyExpenseItems
MyExpenseSheetActions
MyExpenseSheets
MyHolidayEntries
MyJobs
MyJobsTasks
MyTasks
MyTimeEntries
MyTimeOff
MyTimeOffTypes
MyTimesheetActions
MyTimesheetHistory
MyTimesheets
MyTimesheetsActions
MyTimesheetsByDate
Reports
Tasks
TimeEntries
TimeOff
TimeOffTypes
TimesheetActions
TimesheetHistory
TimesheetHolidayEntries
Timesheets
TimesheetTimeEntries
TimesheetTimeOff
Users
UserTimesheetsByDate
MyJobsTasks
Get a list of jobs and available tasks I have access to.
Columns
Name
Type
References
JobId
String
TaskId
String