CustomFieldsByDealId |
https://online-sql-editor.com/teamleader/eu/stable/Sql?appendSqlQuery=select+*%0D%0Afrom+++Teamleader.V2.CustomFieldsByDealId%0D%0Alimit++1000
Name: CustomFieldsByDealId
Catalog: Teamleader
Schema: V2
Primary Keys: id
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Select Service URL (OData-specific): deals.info
Insert Service URL (OData-specific): deals.info
Update Service URL (OData-specific): deals.info
Delete Service URL (OData-specific): deals.info
Field Selection Method (OData-specific): NotRequired
Base Path (OData-specific): custom_fields[*]
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
deal_id |
string |
Deal ID |
☑ |
|
definition_id |
string |
|
☑ |
|
definition_type |
string |
|
☑ |
|
value_as_array |
string |
|
☐ |
|
value_as_boolean |
boolean |
|
☐ |
|
value_as_number |
decimal |
|
☐ |
|
value_as_string |
string |
|
☐ |
|
value_object_id |
string |
|
☐ |
|
value_object_type |
string |
|
☐ |
|
10-09-2020 00:0920.1.206-BETA+2915