invantive documentation
Invantive Support ForumsLog In / Sign Up

Teamleader Focus Data Model

Teamleader Focus is a cloud solution for customer management. Teamleader includes CRM as well as project and tickets. Teamleader can be extended by defining custom fields on several core concepts.

Alternative Name Teamleader Focus is also popular by the former name Teamleader. Authentication Authentication for the Teamleader Focus API can be done using one of the following two alternatives:

  1. Using the user log on code and password also used on the Teamleader website.
  2. Using an API group and API secret. Authentication using user log on code and password is recommended for general use of the API through the Invantive tables. The user must have access to all functionality since by default all so-called 'scopes' of the API are requested. The API scopes can be manually entered to be able to log in with a restricted accounts. Please provide a space-separated list chosen from companies contacts deals departments events invoices products projects quotations subscriptions tickets todos users. The API group and secret can be found on https://app.teamleader.eu/apiwebhooks.php?show_key.

Usage Limits Invantive SQL executes API calls to retrieve and upload data from the Teamleader Focus API in JSON format. The V2 API allows 200 calls per minute. Invantive SQL ensures that within your session the number of calls allowed per timewindow is not exceeded. To get an impression of how Invantive SQL translates into API calls, please query the data dictionary view 'sessionios', such as with 'select * from sessionios@datadictionary'.

Custom Fields Custom fields for which one value can be entered on an object are added to the table representing the object. For instance, a custom field 'needsaudit' on 'project', will be added as a column 'c_needsaudit' on the 'project' table. The name of the additional column directly derives from the custom field name. Almost all changes, including adding numbers or reading characters, will result in the data model being changed. Custom fields which can have no, one or multiple values ('set' custom fields) are reflected in the data model by tables with a name constructed of the object name, an underscore plus the name of the custom field. For example, a custom field named 'Multiple Selection' on 'Task' will add a table 'task_multipleselection' to the data model. Custom fields are unique to each Teamleader Focus environment. When the existence of specific custom field is not guaranteed, please use generic solutions like the tables 'CustomFieldDefinitions', 'custom_fields', 'custom_field_options', 'custom_field', 'Custom_Fields_All', 'Custom_Field_Types' and their object-specific custom field value tables like 'ticket_custom_field_values_by_id'.

Set up this platform in Invantive Cloud: https://cloud.invantive.com/teamleader

Text comparisons on this platform are case sensitive.

Platform

  • Used from: Invantive Cloud and the Invantive products on your own computer or server.
  • Kind: an application reached over its API.
  • The data is partitioned, such as per company or administration.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.teamleader.eu/.
  • Language of its user community: Dutch.

Figures

Figure Count
Tables 220
Columns 4,352
Tables with insert 1
Tables with update 0
Tables with delete 0
Tables documented 4

Tables

Teamleader.CodeValues

Teamleader.Native

Teamleader.V2

Teamleader.V2Flat

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

Attributes

The attributes of this platform are on the page Attributes.

Release Notes

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