invantive documentation
Invantive Support ForumsLog In / Sign Up

TasksV2: Teamleader Focus Projects

read only REST

  • Catalog: Teamleader
  • Schema: V2
  • Primary Keys: id
  • Label: Projects

Can only retrieve data.

API Source

  • Endpoint: projects-v2/tasks.list

Performance Characteristics

Characteristic Value
Average access latency (ms) 39

The result can be cached on the client.

Table Columns

The columns of the table TasksV2 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
c_autoincrement int32 itgen_teamleader_c_autoincrement filters on the platform, writable
c_company guid itgen_teamleader_c_company filters on the platform, writable
c_date datetime itgen_teamleader_c_date filters on the platform, writable
c_emailaddress varchar2 itgen_teamleader_c_emailaddress filters on the platform, writable
c_integer int32 itgen_teamleader_c_integer filters on the platform, writable
c_maximale_waarde decimal itgen_teamleader_c_maximale_waarde filters on the platform, writable
c_number decimal itgen_teamleader_c_number filters on the platform, writable
c_phonenumber varchar2 itgen_teamleader_c_phonenumber filters on the platform, writable
c_singlelinetext varchar2 itgen_teamleader_c_singlelinetext filters on the platform, writable
c_singleselection varchar2 itgen_teamleader_c_singleselection filters on the platform, writable
c_url varchar2 itgen_teamleader_c_url filters on the platform, writable
c_yesno char itgen_teamleader_c_yesno 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
custom_rate_amount decimal Custom Rate Amount filters on the platform, writable, custom_rate.amount
custom_rate_currency varchar2 Custom Rate Currency filters on the platform, writable, custom_rate.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_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
group_id varchar2 Group ID filters on the platform, writable, group.id
group_type varchar2 Group Type filters on the platform, writable, group.type
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
status varchar2 Status filters on the platform, writable
task_type_id varchar2 itgen_teamleader_task_type_id filters on the platform, writable, task_type.id
task_type_type varchar2 itgen_teamleader_task_type_type filters on the platform, writable, task_type.type
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
unit_cost_amount decimal Unit Cost Amount filters on the platform, writable, unit_cost.amount
unit_cost_currency varchar2 Unit Cost Currency filters on the platform, writable, unit_cost.currency
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
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
TasksV2_group_id_fk group_id ProjectGroupsV2.id Key
TasksV2_project_id_fk project_id ProjectsV2.id Key
TasksV2_work_type_id_fk work_type_id WorkTypes.id Key

Release Notes

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