Error itgendoc001X
xMsg javascript has not been loaded.
Simplicate API Data ModelFetches all services
Catalog: Simplicate
Schema: Projects
Can retrieve data and change data using insert, update and delete.
Select Simplicate API URL: /projects/service
Insert Simplicate API URL: /projects/service
Update Simplicate API URL: /projects/service
Delete Simplicate API URL: /projects/service
Field Selection Method: NotRequired
Base Path: data[*]
Select Simplicate API Operation: get /projects/service
Insert Simplicate API Operation: post /projects/service
Update Simplicate API Operation: put /projects/service/{id}
Delete Simplicate API Operation: delete /projects/service/{id}
Table Function Columns
The columns of the table function ProjectServices are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert or update.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
amount |
float |
|
☐ |
|
budget_financial_hours |
string |
|
☐ |
|
budget |
float |
|
☐ |
|
created_at |
string |
Created at |
☐ |
|
default_service_id |
string |
|
☐ |
|
end_date |
string |
End Date |
☐ |
|
expected_invoice_date |
string |
|
☐ |
|
id |
string |
ID |
☐ |
|
invoice_date |
string |
|
☐ |
|
invoice_in_installments |
boolean |
|
☐ |
|
invoice_method |
string |
|
☐ |
|
name |
string |
Name |
☐ |
|
price |
float |
|
☐ |
|
project_id |
string |
Project ID |
☐ |
|
related_service_id |
string |
|
☐ |
|
revenue_group_id |
string |
|
☐ |
|
revenue_group_label |
string |
|
☐ |
|
start_date |
string |
Start Date |
☐ |
|
status |
string |
|
☐ |
|
subscription_cycle |
string |
|
☐ |
|
track_cost |
boolean |
|
☐ |
|
track_hours |
boolean |
|
☐ |
|
updated_at |
string |
Updated at |
☐ |
|
vat_class_code |
string |
|
☐ |
|
vat_class_id |
string |
|
☐ |
|
vat_class_label |
string |
|
☐ |
|
vat_class_name |
string |
|
☐ |
|
vat_class_percentage |
float |
|
☐ |
|
write_hours_end_date |
string |
|
☐ |
|
write_hours_start_date |
string |
|
☐ |
|
06-04-2021 14:59 Version 20.1.393-BETA+3152
