invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectCustomersV2: Teamleader Focus Project Customers

read only REST

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

Can only retrieve data.

API Source

  • Endpoint: projects-v2/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
status `` Either 'open', 'planned', 'running', 'over_budget', 'closed' or 'overdue'.
term `` Filters on the project number, title, customer names, assignee names and owner names. Terms are split on spaces and all terms need to match.

Table Columns

The columns of the table ProjectCustomersV2 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
id varchar2 ID filters on the platform, writable
project_id varchar2 Project ID filters on the platform, writable, ::ancestor.id
type varchar2 Type filters on the platform, writable

Keys

Key Column Refers to Kind Description
ProjectCustomersV2_id_Companies_txt id Companies.id Textual The id of a row of Companies, when type is 'company'.
ProjectCustomersV2_id_Contacts_txt id Contacts.id Textual The id of a row of Contacts, when type is 'contact'.
ProjectCustomersV2_project_id_fk project_id ProjectsV2.id Key

Release Notes

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