invantive documentation
Invantive Support ForumsLog In / Sign Up

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_id varchar2 Account ID filters on the platform, writable, account.id
account_type varchar2 Account Type filters on the platform, writable, account.type
email varchar2 Email filters on the platform, writable
email_verification_status varchar2 Email Verification Status filters on the platform, writable
first_name varchar2 First Name filters on the platform, writable
function varchar2 Function filters on the platform, writable
historic_time_tracking_limit_unit varchar2 Historic Time Tracking Limit Unit filters on the platform, writable, preferences.historic_time_tracking_limit.unit
historic_time_tracking_limit_value decimal Historic Time Tracking Limit Value filters on the platform, writable, preferences.historic_time_tracking_limit.value
id varchar2 ID filters on the platform, writable
invoiceable char Invoiceable filters on the platform, writable, preferences.invoiceable
language varchar2 Language filters on the platform, writable
last_name varchar2 Last Name filters on the platform, writable
time_zone varchar2 Time Zone filters on the platform, writable
whitelabeling char Whitelabeling filters on the platform, writable, preferences.whitelabeling

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: