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