invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectById: Teamleader Focus Project by ID

read only REST

  • Catalog: Teamleader
  • Schema: V2
  • Primary Keys: id
  • Label: Project by ID

Can only retrieve data.

API Source

  • Endpoint: projects.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 ``

Table Columns

The columns of the table ProjectById 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 varchar2 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
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
purchase_order_number varchar2 Purchase Order Number filters on the platform, writable Purchase order number of the project.
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

Release Notes

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