Teamleader API Data Model
deals: Deals |
https://online-sql-editor.com/teamleader/eu/stable/Sql?appendSqlQuery=select+*%0D%0Afrom+++Teamleader.V1.deals%0D%0Alimit++1000
Name: deals
Catalog: Teamleader
Schema: V1
Primary Keys: id
Label: Deals
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Select Service URL (OData-specific): getDeals.php
Insert Service URL (OData-specific): getDeals.php
Update Service URL (OData-specific): getDeals.php
Delete Service URL (OData-specific): getDeals.php
Field Selection Method (OData-specific): NotRequired
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
close_date |
datetime |
Close Date |
☐ |
|
close_date_formatted |
string(20) |
Close Date (Formatted) |
☐ |
|
date_lost |
datetime |
Date Lost |
☐ |
|
date_lost_formatted |
string(20) |
Date Lost (Formatted) |
☐ |
|
entry_date |
datetime |
Entry Date |
☐ |
|
entry_date_formatted |
string(20) |
Entry Date (Formatted) |
☐ |
|
for |
string |
Concerns |
☐ |
|
for_id |
int32 |
ID of Concerns |
☐ |
|
id |
int32 |
ID |
☑ |
|
latest_activity_date |
datetime |
Latest Activity Date |
☐ |
|
latest_activity_date_formatted |
string(20) |
Latest Activity Date (Formatted) |
☐ |
|
phase_id |
int32 |
Phase ID |
☐ |
|
probability |
int32 |
Probability |
☐ |
|
quotation_nr |
int32 |
Quotation Number |
☐ |
|
reason_refused |
string |
Reason Refused |
☐ |
|
responsible_user_id |
int32 |
Responsible User ID |
☐ |
|
source_id |
int32 |
Source ID |
☐ |
|
title |
string(80) |
Title |
☐ |
|
total_price_excl_vat |
decimal |
Total Price excl. VAT |
☐ |
|
10-09-2020 00:0920.1.206-BETA+2915
