xMsg javascript has not been loaded.
Fetches all projects
Catalog: Simplicate
Schema: Projects
This is a read-only table function. The Simplicate API may not support changing the data or the Invantive SQL driver for Simplicate does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Simplicate API.
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[*].custom_fields[*]
Select Simplicate API Operation: get /projects/project
The columns of the table function ProjectCustomFields are shown below. Each column has an SQL data type.
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 |
☐ |
|
custom_field_group_id |
string |
|
☐ |
|
custom_field_group_model_id |
string |
|
☐ |
|
custom_field_group_model_label |
string |
|
☐ |
|
custom_field_group_name |
string |
|
☐ |
|
custom_field_group_position |
string |
|
☐ |
|
custom_field_group_type |
string |
|
☐ |
|
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 |
☐ |
|
filterable |
boolean |
|
☐ |
|
hours_rate_type |
string |
|
☐ |
|
id_1 |
string |
|
☐ |
|
id |
string |
ID |
☐ |
|
invoice_reference |
string |
|
☐ |
|
is_invoice_approval |
boolean |
|
☐ |
|
is_reverse_billing |
boolean |
|
☐ |
|
label |
string |
Label |
☐ |
|
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_1 |
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 |
☐ |
|
position |
int64 |
|
☐ |
|
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 |
|
☐ |
|
render_type |
string |
|
☐ |
|
searchable |
boolean |
Searchable |
☐ |
|
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 |
|
☐ |
|
type |
string |
Type |
☐ |
|
updated_at |
string |
Updated at |
☐ |
|
value_type |
string |
Value Type |
☐ |
|
value |
string |
Value |
☐ |
|
06-04-2021 14:59 Version 20.1.393-BETA+3152