Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Teamleader API Data Model

Navigation: Schema: V1Flat > Tables

TicketsAll: Teamleader Tickets

Contents Previous Home Next More

Catalog: Teamleader

Schema: V1Flat

Label: Tickets

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 TicketsAll are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

background_info_html

string

Background Information (HTML)

 

c_escalatie_flag

boolean

 

 

date_closed

datetime

Date Closed

 

date_created

datetime

Date Created

 

deleted

boolean

Deleted

 

for

string

Concerns

 

for_id

int32

ID of Concerns

 

id

int32

ID

 

optional_company_id

int32

Optional Company ID

 

responsible_user_id

int32

Responsible User ID

 

status

string(150)

Status

 

subject

string(500)

Subject

 

 

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