invantive documentation
Invantive Support ForumsLog In / Sign Up

Milestones: Teamleader Focus Milestones

read only REST

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

Can only retrieve data.

API Source

  • Endpoint: milestones.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
due_after ``
due_before ``
project_id ``
term `` Search for term in title.

Table Columns

The columns of the table Milestones 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_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_amount decimal Budget Spent Amount filters on the platform, writable, budget.spent.amount
budget_spent_currency varchar2 Budget Spent Currency filters on the platform, writable, budget.spent.currency
c_strategisch char itgen_teamleader_c_strategisch filters on the platform, writable
dependency_for_id varchar2 Dependency for ID filters on the platform, writable, dependency_for.id
dependency_for_type varchar2 Dependency for Type filters on the platform, writable, dependency_for.type
depends_on_id varchar2 Depends on ID filters on the platform, writable, depends_on.id
depends_on_type varchar2 Depends on Type filters on the platform, writable, depends_on.type
due_on datetime Due on filters on the platform, writable
id varchar2 ID filters on the platform, writable
invoicing_method varchar2 Invoicing Method filters on the platform, writable
name varchar2 Name filters on the platform, writable
project_id varchar2 Project ID filters on the platform, writable, project.id
project_type varchar2 Project Type filters on the platform, writable, project.type
responsible_user_id varchar2 Responsible User ID filters on the platform, writable, responsible_user.id
responsible_user_type varchar2 Responsible User Type filters on the platform, writable, responsible_user.type
starts_on datetime Starts on filters on the platform, writable
status varchar2 Status filters on the platform, writable

Keys

Key Column Refers to Kind Description
Milestones_responsible_user_id_fk responsible_user_id Users.id Key

Release Notes

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