invantive documentation
Invantive Support ForumsLog In / Sign Up

Projects: Teamleader Focus Projects

read only REST

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

Can only retrieve data.

API Source

  • Endpoint: projects.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
participant_id ``
term `` Search for term in title and description.
updated_since date

Table Columns

The columns of the table Projects 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
actuals_billable_amount_amount decimal Actuals Billable Amount Amount filters on the platform, writable, actuals.billable_amount.amount
actuals_billable_amount_currency varchar2 Actuals Billable Amount Currency filters on the platform, writable, actuals.billable_amount.currency
actuals_costs_amount decimal Actuals Costs Amount filters on the platform, writable, actuals.costs.amount
actuals_costs_currency varchar2 Actuals Costs Currency filters on the platform, writable, actuals.costs.currency
actuals_profit_percentage decimal Actuals Profit Percentage filters on the platform, writable, actuals.profit_percentage
actuals_result_amount decimal Actuals Result Amount filters on the platform, writable, actuals.result.amount
actuals_result_currency varchar2 Actuals Result Currency filters on the platform, writable, actuals.result.currency
budget_allocated_amount decimal Budget Allocated Amount filters on the platform, writable, budget.allocated.amount
budget_allocated_currency varchar2 Budget Allocated Currency filters on the platform, writable, budget.allocated.currency
budget_forecasted_amount decimal Budget Forecasted Amount filters on the platform, writable, budget.forecasted.amount
budget_forecasted_currency varchar2 Budget Forecasted Currency filters on the platform, writable, budget.forecasted.currency
budget_provided_amount decimal Budget Provided Amount filters on the platform, writable, budget.provided.amount
budget_provided_currency varchar2 Budget Provided Currency filters on the platform, writable, budget.provided.currency
budget_remaining_amount decimal Budget Remaining Amount filters on the platform, writable, budget.remaining.amount
budget_remaining_currency varchar2 Budget Remaining Currency filters on the platform, writable, budget.remaining.currency
budget_spent_materials_amount decimal Budget Spent Materials Amount filters on the platform, writable, budget.spent.materials.amount
budget_spent_materials_currency varchar2 Budget Spent Materials Currency filters on the platform, writable, budget.spent.materials.currency
budget_spent_time_amount decimal Budget Spent Time Amount filters on the platform, writable, budget.spent.time.amount
budget_spent_time_currency varchar2 Budget Spent Time Currency filters on the platform, writable, budget.spent.time.currency
budget_spent_total_amount decimal Budget Spent Total Amount filters on the platform, writable, budget.spent.total.amount
budget_spent_total_currency varchar2 Budget Spent Total Currency filters on the platform, writable, budget.spent.total.currency
c_betaling_project varchar2 itgen_teamleader_c_betaling_project filters on the platform, writable
c_budget_volgende_fase varchar2 itgen_teamleader_c_budget_volgende_fase filters on the platform, writable
c_dealnummer varchar2 itgen_teamleader_c_dealnummer filters on the platform, writable
c_fase varchar2 itgen_teamleader_c_fase filters on the platform, writable
created_at datetime Created at filters on the platform, writable
customer_id varchar2 Customer ID filters on the platform, writable, customer.id
customer_type varchar2 Customer Type filters on the platform, writable, customer.type
description varchar2 Description filters on the platform, writable
due_on datetime Due on filters on the platform, writable
id varchar2 ID filters on the platform, writable
reference varchar2 Reference filters on the platform, writable
source_id varchar2 Source ID filters on the platform, writable, source.id
source_type varchar2 Source Type filters on the platform, writable, source.type
starts_on datetime Starts on filters on the platform, writable
status varchar2 Status filters on the platform, writable
title varchar2 Title filters on the platform, writable

Sample Queries

--
-- List of projects. Fast, but excludes custom fields value and some detail columns.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/teamleader-data-model/webhelp/invantive-teamleader-provider-teamleader-v2-projects.html
--
-- Related forum post: https://forums.invantive.eu/t/most-popular-teamleader-focus-tables-for-2022/2569
--
select *
from   Teamleader.V2.Projects@tlr
limit  100

Release Notes

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