invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectItemsByProjectId: Teamleader Focus Project Items

read only REST

  • Catalog: Teamleader
  • Schema: V2
  • Primary Keys: id
  • Label: Project Items

Can only retrieve data.

API Source

  • Endpoint: projectItems.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
activity_type_id ``
milestone_id ``
participant_id ``
project_id ``
tracked_time `` Choose from 'tracked_time', 'external_cost_item' or 'time_tracking_product'.
work_type_id ``

Table Columns

The columns of the table ProjectItemsByProjectId 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
activity_type_id varchar2 Activity Type ID filters on the platform, writable, activity_type.id
activity_type_type varchar2 Activity Type Type filters on the platform, writable, activity_type.type
added_at datetime Added At filters on the platform, writable
billable_price_per_unit_amount decimal Billable Price Amount per Unit filters on the platform, writable, total.billable_price.amount
billable_price_per_unit_currency varchar2 Billable Price Currency per Unit filters on the platform, writable, total.billable_price.currency
description varchar2 Description filters on the platform, writable
id varchar2 ID filters on the platform, writable
internal_cost_per_unit decimal Internal Cost per Unit filters on the platform, writable
milestone_id varchar2 Milestone ID filters on the platform, writable, milestone.id
milestone_type varchar2 Milestone Type filters on the platform, writable, milestone.type
occurred_at datetime Occurred at filters on the platform, writable
participant_id varchar2 Participant ID filters on the platform, writable, participant.id
participant_type varchar2 Participant Type filters on the platform, writable, participant.type
product_id varchar2 Product ID filters on the platform, writable, product.id
product_type varchar2 Product Type filters on the platform, writable, product.type
project_id varchar2 Project ID filters on the platform, writable, project.id
project_type varchar2 Project Type filters on the platform, writable, project.type
quantity decimal Quantity filters on the platform, writable
total_billable_price_amount decimal Total Billable Price Amount filters on the platform, writable, total.billable_price.amount
total_billable_price_currency varchar2 Total Billable Price Currency filters on the platform, writable, total.billable_price.currency
total_internal_cost decimal Total Internal Cost filters on the platform, writable, total.internal_cost
tracked_time varchar2 Tracked Time filters on the platform, writable, tracked_time
unit varchar2 Unit filters on the platform, writable
updated_at datetime Updated At filters on the platform, writable
worktype_id varchar2 Worktype ID filters on the platform, writable, work_type.id
worktype_type varchar2 Worktype Type filters on the platform, writable, work_type.type

Release Notes

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