invantive documentation
Invantive Support ForumsLog In / Sign Up

OrderById: Teamleader Focus Order by ID

read only REST

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

Can only retrieve data.

API Source

  • Endpoint: orders.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 OrderById 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
assignee_id varchar2 Assignee ID filters on the platform, writable, assignee.id
assignee_type varchar2 Assignee Type filters on the platform, writable, assignee.type
deal_id varchar2 Deal ID filters on the platform, writable, deal.id
deal_type varchar2 Deal Type filters on the platform, writable, deal.type
delivery_date datetime Delivery Date filters on the platform, writable
department_id varchar2 Department ID filters on the platform, writable, department.id
department_type varchar2 Department Type filters on the platform, writable, department.type
id varchar2 ID filters on the platform, writable
name varchar2 Name filters on the platform, writable
order_date datetime Order Date filters on the platform, writable
payment_term_days int64 Payment Term (days) filters on the platform, writable, payment_term.days
payment_term_type varchar2 Payment Term Type filters on the platform, writable, payment_term.type
project_id varchar2 Project ID filters on the platform, writable, project.id
project_type varchar2 Project Type filters on the platform, writable, project.type
status varchar2 Status filters on the platform, writable
supplier_id varchar2 Supplier ID filters on the platform, writable, supplier.id
supplier_type varchar2 Supplier Type filters on the platform, writable, supplier.type
total_purchase_price_tax_exclusive_amount decimal Total Purchase Price Tax Exclusive Amount filters on the platform, writable, total.purchase_price_tax_exclusive.amount
total_purchase_price_tax_exclusive_currency varchar2 Total Purchase Price Tax Exclusive Currency filters on the platform, writable, total.purchase_price_tax_exclusive.currency
total_purchase_price_tax_inclusive_amount decimal Total Purchase Price Tax Inclusive Amount filters on the platform, writable, total.purchase_price_tax_inclusive.amount
total_purchase_price_tax_inclusive_currency varchar2 Total Purchase Price Tax Inclusive Currency filters on the platform, writable, total.purchase_price_tax_inclusive.currency
total_tax_exclusive_amount decimal Total Amount excluding Taxes filters on the platform, writable, total.tax_exclusive.amount
total_tax_exclusive_currency varchar2 Currency of Total Amount excluding Taxes filters on the platform, writable, total.tax_exclusive.currency
total_tax_inclusive_amount decimal Total Amount including Taxes filters on the platform, writable, total.tax_inclusive.amount
total_tax_inclusive_currency varchar2 Currency of Total Amount including Taxes filters on the platform, writable, total.tax_inclusive.currency
web_url varchar2 Web (URL) filters on the platform, writable

Release Notes

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