invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectGroupsV2: Teamleader Focus Project Groups

read only REST

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

Can only retrieve data.

API Source

  • Endpoint: projects-v2/projectGroups.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
project_id ``

Table Columns

The columns of the table ProjectGroupsV2 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
amount_billed_amount decimal Amount Billed Amount filters on the platform, writable, amount_billed.amount
amount_billed_currency varchar2 Amount Billed Currency filters on the platform, writable, amount_billed.currency
billing_method varchar2 Billing Method filters on the platform, writable
billing_status varchar2 Billing Status filters on the platform, writable
calculated_price_amount decimal Calculated Price Amount filters on the platform, writable, calculated_price.amount
calculated_price_currency varchar2 Calculated Price Currency filters on the platform, writable, calculated_price.currency
color varchar2 Colour filters on the platform, writable
cost_amount decimal Cost Amount filters on the platform, writable, cost.amount
cost_currency varchar2 Cost Currency filters on the platform, writable, cost.currency
end_date datetime End Date filters on the platform, writable
external_budget_amount decimal External Budget Amount filters on the platform, writable, external_budget.amount
external_budget_currency varchar2 External Budget Currency filters on the platform, writable, external_budget.currency
external_budget_spent_amount decimal External Budget Spent Amount filters on the platform, writable, external_budget_spent.amount
external_budget_spent_currency varchar2 External Budget Spent Currency filters on the platform, writable, external_budget_spent.currency
fixed_amount_billed_amount decimal Fixed Amount Billed Amount filters on the platform, writable, fixed_amount_billed.amount
fixed_amount_billed_currency varchar2 Fixed Amount Billed Currency filters on the platform, writable, fixed_amount_billed.currency
fixed_price_amount decimal Fixed Price Amount filters on the platform, writable, fixed_price.amount
fixed_price_currency varchar2 Fixed Price Currency filters on the platform, writable, fixed_price.currency
id varchar2 ID filters on the platform, writable
internal_budget_amount decimal Internal Budget Amount filters on the platform, writable, internal_budget.amount
internal_budget_currency varchar2 Internal Budget Currency filters on the platform, writable, internal_budget.currency
margin_amount decimal Margin Amount filters on the platform, writable, margin.amount
margin_currency varchar2 Margin Currency filters on the platform, writable, margin.currency
margin_percentage decimal Margin Percentage filters on the platform, writable Null if the user does not have access to "Costs on projects".
price_amount decimal Price Amount filters on the platform, writable, price.amount
price_currency varchar2 Price Currency filters on the platform, writable, price.currency
project_id varchar2 Project ID filters on the platform, writable, project.id
project_type varchar2 Project Type filters on the platform, writable, project.id
start_date datetime Start Date filters on the platform, writable
time_estimated_unit varchar2 Time Estimated Unit filters on the platform, writable, time_estimated.unit
time_estimated_value decimal Time Estimated Value filters on the platform, writable, time_estimated.value
time_tracked_unit varchar2 Time Tracked Unit filters on the platform, writable, time_tracked.unit
time_tracked_value decimal Time Tracked Value filters on the platform, writable, time_tracked.value
title varchar2 Title filters on the platform, writable

Keys

Key Column Refers to Kind Description
ProjectGroupsV2_project_id_fk project_id ProjectsV2.id Key

Referenced By

Release Notes

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