invantive documentation
Invantive Support ForumsLog In / Sign Up

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_after `` Start of the period for which to return time tracking. This includes time tracking that ended at the date provided.
ended_before `` End of the period for which to return time tracking. This includes time tracking that ended at the date provided.
started_after `` Start of the period for which to return time tracking. This includes time tracking that started on the date provided.
started_before `` End of the period for which to return time tracking. This includes time tracking that started on the date provided.
user_id ``

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_info_invoice_id varchar2 Billing Info Invoice ID filters on the platform, writable, billing_info.invoice.id
description varchar2 Description filters on the platform, writable
duration int64 Duration filters on the platform, writable Duration in seconds.
ended_at datetime Ended at filters on the platform, writable
hourly_rate_amount decimal Hourly Rate Amount filters on the platform, writable, hourly_rate.amount
hourly_rate_currency varchar2 Hourly Rate Currency filters on the platform, writable, hourly_rate.currency
id varchar2 ID filters on the platform, writable
invoiceable char Invoiceable filters on the platform, writable
started_at datetime Started at filters on the platform, writable
started_on datetime Started on filters on the platform, writable
subject_id varchar2 Subject ID filters on the platform, writable, subject.id
subject_type varchar2 Subject Type filters on the platform, writable, subject.type
user_id varchar2 User ID filters on the platform, writable, user.id
user_type varchar2 User Type filters on the platform, writable, user.type
work_type_id varchar2 Work Type ID filters on the platform, writable, work_type.id
work_type_type varchar2 Work Type Type filters on the platform, writable, work_type.type

Keys

Key Column Refers to Kind Description
TimeTracking_billing_info_invoice_id_fk billing_info_invoice_id Invoices.id Key
TimeTracking_subject_id_Companies_txt subject_id Companies.id Textual The id of a row of Companies, when subject_type is 'company'.
TimeTracking_subject_id_Tasks_txt subject_id Tasks.id Textual The id of a row of Tasks, when subject_type is 'todo'.
TimeTracking_user_id_fk user_id Users.id Key
TimeTracking_work_type_id_fk work_type_id WorkTypes.id Key

Referenced By

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: