Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Teamleader API Data Model

Navigation: Schema: V1Flat > Tables

TasksAll: Teamleader Tasks

Contents Previous Home Next More

Catalog: Teamleader

Schema: V1Flat

Label: Tasks

This is a read-only view. The Teamleader API may not support changing the data or the Invantive SQL driver for Teamleader does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Teamleader API.

View Columns

The columns of the view TasksAll are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

c_autoincrement_counter

int32

 

 

c_company_company_id

int32

 

 

c_date_date

datetime

 

 

c_emailaddress_email

string

 

 

c_integer_number

int32

 

 

c_maximale_waarde_amount

decimal

 

 

c_number_number

decimal

 

 

c_phonenumber_phone

string

 

 

c_singlelinetext

string

 

 

c_singleselection_id

int32

 

 

c_singleselection_value

string

 

 

c_url_url

string

 

 

c_yesno_flag

boolean

 

 

client_id

int32

Client ID

 

client_name

string

Client Name

 

client_type

string

Client Type

 

creator_name

string

Creator Name

 

date_finished

datetime

Date Finished

 

date_finished_formatted

string(20)

Date Finished (Formatted)

 

deleted

boolean

Deleted

 

description

string

Description

 

due_date

datetime

Due Date

 

due_date_formatted

string(20)

Due Date (Formatted)

 

estimated_time_required

int32

Estimated Time Required

 

estimated_time_used

int32

Estimated Time Used

 

finished

boolean

Finished

 

milestone_name

string

Milestone Name

 

priority

string

Priority

 

project_id

int32

Project ID

 

project_name

string

Project Name

 

related_ticket_id

int32

Related Ticket ID

 

responsible_users_team_id

int32

Responsible Users Team ID

 

responsible_users_users

string

Responsible Users

 

task_id

int32

ID

 

type_id

int32

Type ID

 

 

12-12-2020 19:52 Version 20.1.301-BETA+3023