Me: Teamleader Focus Me
read only REST
- Catalog:
Teamleader - Schema:
V2 - Primary Keys:
id - Label: Me
Can only retrieve data.
API Source
- Endpoint:
users.me
Performance Characteristics
| Characteristic | Value |
|---|---|
| Average access latency (ms) | 39 |
The result can be cached on the client.
Table Columns
The columns of the table Me 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 |
|---|---|---|---|---|---|
account_ |
varchar2 |
Account ID | filters on the platform, writable, account. |
||
account_ |
varchar2 |
Account Type | filters on the platform, writable, account. |
||
email |
varchar2 |
filters on the platform, writable | |||
email_ |
varchar2 |
Email Verification Status | filters on the platform, writable | ||
first_ |
varchar2 |
First Name | filters on the platform, writable | ||
function |
varchar2 |
Function | filters on the platform, writable | ||
historic_ |
varchar2 |
Historic Time Tracking Limit Unit | filters on the platform, writable, preferences. |
||
historic_ |
decimal |
Historic Time Tracking Limit Value | filters on the platform, writable, preferences. |
||
id |
varchar2 |
ID | filters on the platform, writable | ||
invoiceable |
char |
Invoiceable | filters on the platform, writable, preferences. |
||
language |
varchar2 |
Language | filters on the platform, writable | ||
last_ |
varchar2 |
Last Name | filters on the platform, writable | ||
time_ |
varchar2 |
Time Zone | filters on the platform, writable | ||
whitelabeling |
char |
Whitelabeling | filters on the platform, writable, preferences. |
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
--
-- List of projects. Fast, but excludes custom fields value and some detail columns.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/teamleader-data-model/webhelp/invantive-teamleader-provider-teamleader-v2-projects.html
--
-- Related forum post: https://forums.invantive.eu/t/most-popular-teamleader-focus-tables-for-2022/2569
--
select *
from Teamleader.V2.Projects@tlr
limit 100
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: