xMsg javascript has not been loaded.
Fetches all projects
Catalog: Simplicate
Schema: Projects
Label: Projects
Can retrieve data and change data using insert, update and delete.
Select Simplicate API URL: /projects/project
Insert Simplicate API URL: /projects/project
Update Simplicate API URL: /projects/project
Delete Simplicate API URL: /projects/project
Field Selection Method: NotRequired
Base Path: data[*]
Select Simplicate API Operation: get /projects/project
Insert Simplicate API Operation: post /projects/project
Update Simplicate API Operation: put /projects/project/{id}
Delete Simplicate API Operation: delete /projects/project/{id}
The columns of the table function Projects 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 |
---|---|---|---|---|
abnormal_address |
boolean |
|
☐ |
|
abnormal_contact_id |
string |
|
☐ |
|
abnormal_organization_id |
string |
|
☐ |
|
abnormal_person_id |
string |
|
☐ |
|
billable |
boolean |
|
☐ |
|
budget_costs_value_budget |
float |
|
☐ |
|
budget_costs_value_spent |
float |
|
☐ |
|
budget_hours_amount_budget |
float |
|
☐ |
|
budget_hours_amount_spent |
float |
|
☐ |
|
budget_hours_value_budget |
float |
|
☐ |
|
budget_hours_value_spent |
float |
|
☐ |
|
budget_total_value_budget |
float |
|
☐ |
|
budget_total_value_invoiced |
float |
|
☐ |
|
budget_total_value_spent |
float |
|
☐ |
|
can_register_mileage |
boolean |
|
☐ |
|
contact_id_1 |
string |
|
☐ |
|
contact_id |
string |
|
☐ |
|
contact_organization_id |
string |
|
☐ |
|
contact_organization_name |
string |
|
☐ |
|
contact_person_full_name |
string |
|
☐ |
|
contact_person_id |
string |
|
☐ |
|
created_at |
string |
Created at |
☐ |
|
created |
string |
Created |
☐ |
|
divergent_payment_term_days |
int64 |
|
☐ |
|
divergent_payment_term_id |
string |
|
☐ |
|
divergent_payment_term_method |
string |
|
☐ |
|
divergent_payment_term_name |
string |
|
☐ |
|
end_date |
string |
End Date |
☐ |
|
hours_rate_type |
string |
|
☐ |
|
id |
string |
ID |
☐ |
|
invoice_reference |
string |
|
☐ |
|
is_invoice_approval |
boolean |
|
☐ |
|
is_reverse_billing |
boolean |
|
☐ |
|
modified |
string |
Modified |
☐ |
|
my_organization_profile_id_1 |
string |
|
☐ |
|
my_organization_profile_id |
string |
|
☐ |
|
my_organization_profile_organization_id |
string |
|
☐ |
|
my_organization_profile_organization_name |
string |
|
☐ |
|
name |
string |
Name |
☐ |
|
note |
string |
Note |
☐ |
|
organization_id_1 |
string |
|
☐ |
|
organization_id |
string |
Organization ID |
☐ |
|
organization_name |
string |
Organization Name |
☐ |
|
person_full_name |
string |
|
☐ |
|
person_id_1 |
string |
|
☐ |
|
person_id |
string |
Person ID |
☐ |
|
project_manager_amount |
float |
|
☐ |
|
project_manager_declarable |
string |
|
☐ |
|
project_manager_employee_id |
string |
|
☐ |
|
project_manager_id |
string |
|
☐ |
|
project_manager_name |
string |
|
☐ |
|
project_manager_person_id |
string |
|
☐ |
|
project_manager_tariff |
float |
|
☐ |
|
project_number |
string |
|
☐ |
|
project_status_color |
string |
|
☐ |
|
project_status_id |
string |
|
☐ |
|
project_status_label |
string |
|
☐ |
|
separate_invoice_recipient_contact_id |
string |
|
☐ |
|
separate_invoice_recipient_contact_organization_id |
string |
|
☐ |
|
separate_invoice_recipient_contact_organization_name |
string |
|
☐ |
|
separate_invoice_recipient_contact_person_full_name |
string |
|
☐ |
|
separate_invoice_recipient_contact_person_id |
string |
|
☐ |
|
separate_invoice_recipient_is_separate_invoice_recipient |
boolean |
|
☐ |
|
separate_invoice_recipient_organization_id |
string |
|
☐ |
|
separate_invoice_recipient_organization_name |
string |
|
☐ |
|
separate_invoice_recipient_person_full_name |
string |
|
☐ |
|
separate_invoice_recipient_person_id |
string |
|
☐ |
|
simplicate_url |
string |
Simplicate URL |
☐ |
|
start_date |
string |
Start Date |
☐ |
|
timeline_email_address |
string |
|
☐ |
|
updated_at |
string |
Updated at |
☐ |
|
06-04-2021 14:59 Version 20.1.393-BETA+3152