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_ |
`` | |||
milestone_ |
`` | |||
scheduled |
`` | |||
term |
`` | Search for term in description. | ||
user_ |
`` | 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_ |
datetime |
Added At | filters on the platform, writable | ||
assignee_ |
varchar2 |
Assignee ID | filters on the platform, writable, assignee. |
||
assignee_ |
varchar2 |
Assignee Type | filters on the platform, writable, assignee. |
||
c_ |
int32 |
itgen_teamleader_c_autoincrement | filters on the platform, writable | ||
c_ |
guid |
itgen_teamleader_c_company | filters on the platform, writable | ||
c_date |
datetime |
itgen_teamleader_c_date | filters on the platform, writable | ||
c_ |
varchar2 |
itgen_teamleader_c_emailaddress | filters on the platform, writable | ||
c_ |
int32 |
itgen_teamleader_c_integer | filters on the platform, writable | ||
c_ |
decimal |
itgen_teamleader_c_maximale_waarde | filters on the platform, writable | ||
c_ |
decimal |
itgen_teamleader_c_number | filters on the platform, writable | ||
c_ |
varchar2 |
itgen_teamleader_c_phonenumber | filters on the platform, writable | ||
c_ |
varchar2 |
itgen_teamleader_c_singlelinetext | filters on the platform, writable | ||
c_ |
varchar2 |
itgen_teamleader_c_singleselection | filters on the platform, writable | ||
c_url |
varchar2 |
itgen_teamleader_c_url | filters on the platform, writable | ||
c_ |
char |
itgen_teamleader_c_yesno | filters on the platform, writable | ||
completed |
char |
Completed | filters on the platform, writable | ||
completed_ |
datetime |
Completed at | filters on the platform, writable | ||
customer_ |
varchar2 |
Customer ID | filters on the platform, writable, customer. |
||
customer_ |
varchar2 |
Customer Type | filters on the platform, writable, customer. |
||
deal_ |
varchar2 |
Deal ID | filters on the platform, writable, deal. |
||
deal_ |
varchar2 |
Deal Type | filters on the platform, writable, deal. |
||
description |
varchar2 |
Description | filters on the platform, writable | ||
due_on |
datetime |
Due on | filters on the platform, writable | ||
estimated_ |
varchar2 |
Estimated Duration Unit | filters on the platform, writable, estimated_ |
||
estimated_ |
decimal |
Estimated Duration Value | filters on the platform, writable, estimated_ |
||
id |
varchar2 |
ID | filters on the platform, writable | ||
milestone_ |
varchar2 |
Milestone ID | filters on the platform, writable, milestone. |
||
milestone_ |
varchar2 |
Milestone Type | filters on the platform, writable, milestone. |
||
priority |
varchar2 |
Priority | filters on the platform, writable | ||
project_ |
varchar2 |
Project ID | filters on the platform, writable, project. |
||
project_ |
varchar2 |
Project Type | filters on the platform, writable, project. |
||
ticket_ |
varchar2 |
Ticket ID | filters on the platform, writable, ticket. |
||
title |
varchar2 |
Title | filters on the platform, writable | ||
work_ |
varchar2 |
Work Type ID | filters on the platform, writable, work_ |
||
work_ |
varchar2 |
Work Type Type | filters on the platform, writable, work_ |
Keys
| Key | Column | Refers to | Kind | Description |
|---|---|---|---|---|
Tasks_ |
assignee_ |
Users.id |
Textual | The id of a row of Users, when assignee_type is 'user'. |
Tasks_ |
customer_ |
Companies.id |
Textual | The id of a row of Companies, when customer_type is 'company'. |
Tasks_ |
customer_ |
Contacts.id |
Textual | The id of a row of Contacts, when customer_type is 'contact'. |
Tasks_ |
project_ |
ProjectsV2.id |
Textual | The id of a row of ProjectsV2, when project_type is 'nextgenProject'. |
Referenced By
- Events
task_id(Key) - TimeTracking
subject_id(Textual)
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: