Companies: Teamleader Focus Companies
popular read only REST
- Catalog:
Teamleader - Schema:
V2 - Primary Keys:
id - Label: Companies
Can only retrieve data.
API Source
- Endpoint:
companies.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 |
|---|---|---|---|---|
company_ |
`` | |||
term |
`` | Filters on first_name, last_name, email and telephone. | ||
updated_ |
date |
|||
vat_ |
`` |
Table Columns
The columns of the table Companies 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 |
|---|---|---|---|---|---|
added_ |
datetime |
Added At | filters on the platform, writable | ||
bic |
varchar2 |
BIC Number | filters on the platform, writable | ||
business_ |
varchar2 |
Business Type ID | filters on the platform, writable, business_ |
||
business_ |
varchar2 |
Business Type | filters on the platform, writable, business_ |
||
c_ |
varchar2 |
itgen_teamleader_c_regio | filters on the platform, writable | ||
c_test |
varchar2 |
itgen_teamleader_c_test | filters on the platform, writable | ||
c_ |
int32 |
itgen_teamleader_c_transport_2020 | filters on the platform, writable | ||
iban |
varchar2 |
IBAN Number | filters on the platform, writable | ||
id |
varchar2 |
ID | filters on the platform, writable | ||
invoicing_ |
varchar2 |
Invoicing Preferences Electronic Invoicing Address | filters on the platform, writable, invoicing_ |
||
language |
varchar2 |
Language | filters on the platform, writable | ||
local_ |
varchar2 |
Local Business Number | filters on the platform, writable | Also known as Chamber of Commerce number in many countries. | |
name |
varchar2 |
Name | filters on the platform, writable | ||
national_ |
varchar2 |
National Identification Number | filters on the platform, writable | Also known as Chamber of Commerce number in many countries. | |
payment_ |
decimal |
Payment Term (days) | filters on the platform, writable, payment_ |
||
payment_ |
varchar2 |
Payment Term Type | filters on the platform, writable, payment_ |
||
preferred_ |
varchar2 |
Preferred Currency | filters on the platform, writable | ||
primary_ |
varchar2 |
Primary Address City | filters on the platform, writable, primary_ |
||
primary_ |
varchar2 |
Primary Address Country | filters on the platform, writable, primary_ |
||
primary_ |
varchar2 |
Primary Address Line 1 | filters on the platform, writable, primary_ |
||
primary_ |
varchar2 |
Primary Address Postal Code | filters on the platform, writable, primary_ |
||
responsible_ |
varchar2 |
Responsible User ID | filters on the platform, writable, responsible_ |
||
responsible_ |
varchar2 |
Responsible User Type | filters on the platform, writable, responsible_ |
||
status |
varchar2 |
Status | filters on the platform, writable | ||
updated_ |
datetime |
Updated At | filters on the platform, writable | ||
vat_ |
varchar2 |
VAT Number | filters on the platform, writable | VAT number. | |
web_ |
varchar2 |
Web (URL) | filters on the platform, writable | ||
website |
varchar2 |
Website | filters on the platform, writable |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Companies_ |
business_ |
BusinessTypes.id |
Key | |
Companies_ |
responsible_ |
Users.id |
Key |
Referenced By
- CompanyEmailAddresses
company_id(Key) - CompanyTags
company_id(Key) - CompanyTelephones
company_id(Key) - CreditNotes
invoicee_customer_id(Textual) - Deals
lead_customer_id(Textual) - EventLinks
id(Textual) - Expenses
supplier_id(Textual) - Invoices
invoicee_customer_id(Textual) - ProjectCustomersV2
id(Textual) - Subscriptions
invoicee_customer_id(Textual) - Tasks
customer_id(Textual) - TimeTracking
subject_id(Textual)
Sample Queries
--
-- List of companies with all detail and custom fields. Very slow, with solely 1 row per second over prolonged periods of time.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/teamleader-data-model/webhelp/teamleader-focus-connector-v2flat-companiesall.html
--
-- Related forum post: https://forums.invantive.eu/t/what-are-table-functions-and-table-function-parameters/1868
--
select *
from Teamleader.V2Flat.CompaniesAll@tlr
limit 100
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: