TimeTracking: Teamleader Focus Time Tracking
popular read only REST
- Catalog:
Teamleader - Schema:
V2 - Primary Keys:
id - Label: Time Tracking
Can only retrieve data.
API Source
- Endpoint:
timeTracking.list
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 39 |
The result can be cached on the client.
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
ended_ |
`` | Start of the period for which to return time tracking. This includes time tracking that ended at the date provided. | ||
ended_ |
`` | End of the period for which to return time tracking. This includes time tracking that ended at the date provided. | ||
started_ |
`` | Start of the period for which to return time tracking. This includes time tracking that started on the date provided. | ||
started_ |
`` | End of the period for which to return time tracking. This includes time tracking that started on the date provided. | ||
user_ |
`` |
Table Columns
The columns of the table TimeTracking are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
billing_ |
varchar2 |
Billing Info Invoice ID | filters on the platform, writable, billing_ |
||
description |
varchar2 |
Description | filters on the platform, writable | ||
duration |
int64 |
Duration | filters on the platform, writable | Duration in seconds. | |
ended_ |
datetime |
Ended at | filters on the platform, writable | ||
hourly_ |
decimal |
Hourly Rate Amount | filters on the platform, writable, hourly_ |
||
hourly_ |
varchar2 |
Hourly Rate Currency | filters on the platform, writable, hourly_ |
||
id |
varchar2 |
ID | filters on the platform, writable | ||
invoiceable |
char |
Invoiceable | filters on the platform, writable | ||
started_ |
datetime |
Started at | filters on the platform, writable | ||
started_ |
datetime |
Started on | filters on the platform, writable | ||
subject_ |
varchar2 |
Subject ID | filters on the platform, writable, subject. |
||
subject_ |
varchar2 |
Subject Type | filters on the platform, writable, subject. |
||
user_ |
varchar2 |
User ID | filters on the platform, writable, user. |
||
user_ |
varchar2 |
User Type | filters on the platform, writable, user. |
||
work_ |
varchar2 |
Work Type ID | filters on the platform, writable, work_ |
||
work_ |
varchar2 |
Work Type Type | filters on the platform, writable, work_ |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Time |
billing_ |
Invoices.id |
Key | |
Time |
subject_ |
Companies.id |
Textual | The id of a row of Companies, when subject_type is 'company'. |
Time |
subject_ |
Tasks.id |
Textual | The id of a row of Tasks, when subject_type is 'todo'. |
Time |
user_ |
Users.id |
Key | |
Time |
work_ |
WorkTypes.id |
Key |
Referenced By
- TimeTrackingMaterials
time_id(Key)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: