invantive documentation
Invantive Support ForumsLog In / Sign Up

TimeTrackingMaterialsByTimeTrackingId: Teamleader Focus Time Tracking Materials By Time Tracking ID

read only REST

  • Catalog: Teamleader
  • Schema: V2
  • Primary Keys: id
  • Label: Time Tracking Materials By Time Tracking ID

Can only retrieve data.

API Source

  • Endpoint: timeTracking.info

Performance Characteristics

Characteristic Value
Average access latency (ms) 39

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
id ``
includes `` materials When materials, the response will include materials.

Table Columns

The columns of the table TimeTrackingMaterialsByTimeTrackingId 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
description varchar2 Description filters on the platform, writable
product_id varchar2 Product ID filters on the platform, writable, product.id
quantity decimal Quantity filters on the platform, writable
time_billing_info_invoice_id varchar2 Time Billing Info Invoice ID filters on the platform, writable, ::ancestor.billing_info.invoice.id
time_billing_info_invoice_type varchar2 Time Billing Info Invoice Type filters on the platform, writable, ::ancestor.billing_info.invoice.type
time_billing_info_type varchar2 Time Billing Info Type filters on the platform, writable, ::ancestor.billing_info.type
time_description varchar2 Time Description filters on the platform, writable, ::ancestor.description
time_duration int64 Time Duration filters on the platform, writable, ::ancestor.duration Duration in seconds.
time_ended_at datetime Time Ended at filters on the platform, writable, ::ancestor.ended_at
time_id varchar2 Time ID filters on the platform, writable, ::ancestor.id
time_invoiceable char Time Invoiceable filters on the platform, writable, ::ancestor.invoiceable
time_locked char Time Locked filters on the platform, writable, ::ancestor.locked If true, the freeze time window has passed since creating it.
time_started_at datetime Time Started at filters on the platform, writable, ::ancestor.started_at
time_started_on datetime Time Started on filters on the platform, writable, ::ancestor.started_on
time_subject_id varchar2 Time Subject ID filters on the platform, writable, ::ancestor.subject.id
time_subject_type varchar2 Time Subject Type filters on the platform, writable, ::ancestor.subject.type
time_user_id varchar2 Time User ID filters on the platform, writable, ::ancestor.user.id
time_user_type varchar2 Time User Type filters on the platform, writable, ::ancestor.user.type
time_work_type_id varchar2 Time Work Type ID filters on the platform, writable, ::ancestor.work_type.id
time_work_type_type varchar2 Time Work Type Type filters on the platform, writable, ::ancestor.work_type.type
unit_price_amount decimal Unit Price Amount filters on the platform, writable, unit_price.amount
unit_price_currency varchar2 Unit Price Currency filters on the platform, writable, unit_price.currency

Release Notes

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