Teamleader API Data Model
Projects: Projects |
https://online-sql-editor.com/teamleader/eu/stable/Sql?appendSqlQuery=select+*%0D%0Afrom+++Teamleader.V2.Projects%0D%0Alimit++1000
Name: Projects
Catalog: Teamleader
Schema: V2
Primary Keys: id
Label: Projects
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Select Service URL (OData-specific): projects.list
Insert Service URL (OData-specific): projects.list
Update Service URL (OData-specific): projects.list
Delete Service URL (OData-specific): projects.list
Field Selection Method (OData-specific): NotRequired
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
actuals_billable_amount_amount |
decimal |
|
☐ |
|
actuals_billable_amount_currency |
string |
|
☐ |
|
actuals_costs_amount |
string |
|
☐ |
|
actuals_costs_currency |
string |
|
☐ |
|
actuals_profit_percentage |
string |
|
☐ |
|
actuals_result_amount |
string |
|
☐ |
|
actuals_result_currency |
string |
|
☐ |
|
budget_allocated_amount |
decimal |
|
☐ |
|
budget_allocated_currency |
string |
|
☐ |
|
budget_forecasted_amount |
decimal |
|
☐ |
|
budget_forecasted_currency |
string |
|
☐ |
|
budget_provided_amount |
decimal |
|
☐ |
|
budget_provided_currency |
string |
|
☐ |
|
budget_remaining_amount |
decimal |
|
☐ |
|
budget_remaining_currency |
string |
|
☐ |
|
budget_spent_materials_amount |
decimal |
|
☐ |
|
budget_spent_materials_currency |
string |
|
☐ |
|
budget_spent_time_amount |
decimal |
|
☐ |
|
budget_spent_time_currency |
string |
|
☐ |
|
budget_spent_total_amount |
decimal |
|
☐ |
|
budget_spent_total_currency |
string |
|
☐ |
|
customer_id |
string |
Customer ID |
☐ |
|
customer_type |
string |
Customer Type |
☐ |
|
description |
string |
Description |
☐ |
|
due_on |
datetime |
Due on |
☑ |
|
id |
string |
ID |
☑ |
|
reference |
string |
Reference |
☑ |
|
source_id |
string |
Source ID |
☐ |
|
source_type |
string |
Source Type |
☐ |
|
starts_on |
datetime |
Starts on |
☑ |
|
status |
string |
Status |
☑ |
|
title |
string |
Title |
☑ |
|
10-09-2020 00:0920.1.206-BETA+2915
