ticket_message: Ticket Message |
https://online-sql-editor.com/teamleader/eu/stable/Sql?appendSqlQuery=select+*%0D%0Afrom+++Teamleader.V1.ticket_message%0D%0Alimit++1000
Name: ticket_message
Catalog: Teamleader
Schema: V1
Primary Keys: id
Label: Ticket Message
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Select Service URL (OData-specific): getTicketMessage.php
Insert Service URL (OData-specific): getTicketMessage.php
Update Service URL (OData-specific): getTicketMessage.php
Delete Service URL (OData-specific): getTicketMessage.php
Field Selection Method (OData-specific): NotRequired
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
date |
datetime |
Date |
☐ |
|
date_formatted |
string(20) |
Date (Formatted) |
☐ |
|
from |
string |
From |
☐ |
|
from_id |
int32 |
From ID |
☐ |
|
id |
int32 |
ID |
☑ |
|
internal_message |
boolean |
Internal Message |
☑ |
|
message |
string |
Message |
☐ |
|
message_raw |
string |
Message (Raw) |
☐ |
|
ticket_id |
int32 |
Ticket ID |
☐ |
|
10-09-2020 00:0920.1.206-BETA+2915