invantive documentation
Invantive Support ForumsLog In / Sign Up

Tasks: Teamleader Focus Tasks

read only REST

  • Catalog: Teamleader
  • Schema: V2
  • Primary Keys: id
  • Label: Tasks

Can only retrieve data.

API Source

  • Endpoint: tasks.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
completed ``
due_by ``
due_from ``
milestone_id ``
scheduled ``
term `` Search for term in description.
user_id `` Returns tasks that are assigned to this user or to a team to which this user belongs. When passing null, it returns tasks that are unassigned.

Table Columns

The columns of the table Tasks 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_at datetime Added At filters on the platform, writable
assignee_id varchar2 Assignee ID filters on the platform, writable, assignee.id
assignee_type varchar2 Assignee Type filters on the platform, writable, assignee.type
c_autoincrement int32 itgen_teamleader_c_autoincrement filters on the platform, writable
c_company guid itgen_teamleader_c_company filters on the platform, writable
c_date datetime itgen_teamleader_c_date filters on the platform, writable
c_emailaddress varchar2 itgen_teamleader_c_emailaddress filters on the platform, writable
c_integer int32 itgen_teamleader_c_integer filters on the platform, writable
c_maximale_waarde decimal itgen_teamleader_c_maximale_waarde filters on the platform, writable
c_number decimal itgen_teamleader_c_number filters on the platform, writable
c_phonenumber varchar2 itgen_teamleader_c_phonenumber filters on the platform, writable
c_singlelinetext varchar2 itgen_teamleader_c_singlelinetext filters on the platform, writable
c_singleselection varchar2 itgen_teamleader_c_singleselection filters on the platform, writable
c_url varchar2 itgen_teamleader_c_url filters on the platform, writable
c_yesno char itgen_teamleader_c_yesno filters on the platform, writable
completed char Completed filters on the platform, writable
completed_at datetime Completed at filters on the platform, writable
customer_id varchar2 Customer ID filters on the platform, writable, customer.id
customer_type varchar2 Customer Type filters on the platform, writable, customer.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
description varchar2 Description filters on the platform, writable
due_on datetime Due on filters on the platform, writable
estimated_duration_unit varchar2 Estimated Duration Unit filters on the platform, writable, estimated_duration.unit
estimated_duration_value decimal Estimated Duration Value filters on the platform, writable, estimated_duration.value
id varchar2 ID filters on the platform, writable
milestone_id varchar2 Milestone ID filters on the platform, writable, milestone.id
milestone_type varchar2 Milestone Type filters on the platform, writable, milestone.type
priority varchar2 Priority filters on the platform, writable
project_id varchar2 Project ID filters on the platform, writable, project.id
project_type varchar2 Project Type filters on the platform, writable, project.type
ticket_id varchar2 Ticket ID filters on the platform, writable, ticket.id
title varchar2 Title filters on the platform, writable
work_type_id varchar2 Work Type ID filters on the platform, writable, work_type.id
work_type_type varchar2 Work Type Type filters on the platform, writable, work_type.type

Keys

Key Column Refers to Kind Description
Tasks_assignee_id_Users_txt assignee_id Users.id Textual The id of a row of Users, when assignee_type is 'user'.
Tasks_customer_id_Companies_txt customer_id Companies.id Textual The id of a row of Companies, when customer_type is 'company'.
Tasks_customer_id_Contacts_txt customer_id Contacts.id Textual The id of a row of Contacts, when customer_type is 'contact'.
Tasks_project_id_ProjectsV2_txt project_id ProjectsV2.id Textual The id of a row of ProjectsV2, when project_type is 'nextgenProject'.

Referenced By

Release Notes

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