API Data Provider - Online Help

ClickTime 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.

ClickTime Tables

Name Description
Allocations Get allocations.
Clients Get clients.
Company Get your company.
CurrentUser Get the current user.
CustomMessages Get custom messages.
Divisions Get divisions.
EmploymentTypes Get Employment Types.
HolidayEntries Get holiday entries.
Jobs Get jobs.
ManagedDivisions Get managed divisions.
ManagedTimesheetActions Get available actions for a managed timesheet.
ManagedTimesheetHistory Get a managed timesheet's status history.
ManagedTimesheetHolidayEntries Get holiday entries for a timesheet for which you are the approver.
ManagedTimesheets Get managed timesheets.
ManagedTimesheetsByDate Get a user's timesheet by date. If the timesheet does not exist it will be created.
ManagedTimesheetsHolidayEntries Get holiday entries for users whose timesheets you approve.
ManagedTimesheetsTimeEntries Get managed time entries.
ManagedTimesheetsTimeOff Get time off entries for managed timesheets.
ManagedTimesheetTimeOff Get time off entries for a managed timesheet.
ManagedUsers Get the users managed by current user.
MyClients Get my clients.
MyExpenseItems Get my expense items.
MyExpenseSheetActions Get my expense sheet actions.
MyExpenseSheets Get my expense sheets.
MyHolidayEntries Get my holiday entries.
MyJobs Get my jobs.
MyJobsTasks Get a list of jobs and available tasks I have access to.
MyTasks Get my tasks.
MyTimeEntries Get my time entries.
MyTimeOff Get my time off entries.
MyTimeOffTypes Get my time off types.
MyTimesheetActions Get available Actions for my Timesheet by ID
MyTimesheetHistory Get my Timesheet's status history.
MyTimesheets Get my timesheets.
MyTimesheetsActions Get available Actions for my Timesheet by date
MyTimesheetsByDate Get my timesheets by date.
Reports Get time entry reporting.
Tasks Get tasks.
TimeEntries Get time entries. This table is intended for smaller data set, for example when you're retrieving time entries for a single timesheet period. For larger datasets please use Reports table.
TimeOff Get time off entries.
TimeOffTypes Get time off types.
TimesheetActions Get available actions for a timesheet.
TimesheetHistory Get a timesheet's status history.
TimesheetHolidayEntries Get holiday entries for a timesheet.
Timesheets Get timesheets.
TimesheetTimeEntries Get a Timesheet's Time Entries.
TimesheetTimeOff Get a Timesheet's Time Off entries.
Users Get users.
UserTimesheetsByDate Get a User's Timesheet by date. If the timesheet does not exist it will be created.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060.0