Project - Procore Data Target Requirements
DataBlend supports the API calls to Create and Update Project records within Procore leveraging the Procore API.
| DataBlend Query Field Example | Procore Object (API) | Required | Notes |
| 3461 | company_id | Yes | Procore company the project belongs to. |
| 89025 | id | Yes, for update | Procore project ID. Leave blank on Create. |
| Project F | name | Yes, for create | Name of the project. |
| 3456 | accounting_project_number | No | The accounting project number for the project. |
| TRUE | active | No | Boolean. Active status of the project. Defaults to true on Create. |
| 500 Construction Way | address | No | Street address for the project. |
| Carpinteria | city | No | City in which the project is located. |
| ABC | code | No | Project code. Accepted by the Procore API on Create only. |
| 5/15/2015 | completion_date | No | Date all parties agree the project meets substantial completion. Format: YYYY-MM-DD |
| US | country_code | No | Country code in ISO-3166 Alpha-2 format (e.g. US, GB). |
| Santa Barbara County | county | No | County in which the project is located. Accepted by the Procore API on Update only. |
| USD | currency_iso_code | No | Initializes the project currency configuration on Create. Must be a currency available in the company exchange-rates list. Accepted by the Procore API on Create only. |
| custom field value | custom_field_%{custom_field_definition_id} | No | Custom field value. Value must match the data type of the custom field definition. Accepted by the Procore API on Update only. Requires a Procore plugin release later than 2.14.1. |
| design_build_db | delivery_method | No | Delivery method of the project |
| 1|2|3 | department_ids | No | Pipe-separated list of department IDs (e.g. 1|2|3). The list must represent all departments for the project; IDs omitted from the list are removed. |
| A description of the project | description | No | Description of the project. |
| Southeast | designated_market_area | No | The designated market area the project is located in. |
| TRUE | enable_copy_of_standard_cost_codes | No | Boolean. When true, copies default standard cost codes during project creation. Accepted by the Procore API on Create only. |
| TRUE | erp_integrated | No | Boolean. Marks the project as ERP integrated. |
| 1500000 | estimated_budget | No | Decimal. Estimated budget for the project. Accepted by the Procore API on Create only. |
| 5/31/2015 | estimated_completion_date | No | |
| 5/15/2015 | estimated_start_date | No | |
| 10000 | estimated_value | No | Decimal. |
| 1.5 | exchange_rate_override | No | Decimal. Fixed initial project-to-company exchange rate. Accepted by the Procore API on Create only. |
| 310-555-5555 | fax | No | Fax number. Accepted by the Procore API on Update only. |
| Yellow | flag | No | Project flag color. |
| 10 | image_id | No | Identifier of the project image. |
| 34.385 | latitude | No | Decimal. Geographic latitude coordinate. Accepted by the Procore API on Create only. |
| en-GB | locale | No | Locale for the project. See the Procore API reference for the full list. |
| -119.4908 | longitude | No | Decimal. Geographic longitude coordinate. Accepted by the Procore API on Create only. |
| 3610 | office_id | No | ID of the office associated with the project. |
| Code 123 | origin_code | No | An external third-party code associated with the project. |
| AC-1234 | origin_data | No | An external third-party data string associated with the project. |
| 657 | origin_id | No | An external third-party identifier for the project. |
| 5/31/2015 | override_end_date | No | Date the project will be finished, displayed on the portfolio page. Format: YYYY-MM-DD. Accepted by the Procore API on Create only. |
| TRUE | override_end_date_check | No | Boolean. Accepted by the Procore API on Create only. |
| 5/15/2015 | override_start_date | No | Date the project started, displayed on the portfolio page. Format: YYYY-MM-DD. Accepted by the Procore API on Create only. |
| TRUE | override_start_date_check | No | Boolean. Accepted by the Procore API on Create only. |
| 2 | parent_job_id | No | Unique identifier for the parent job. |
| 310-555-5555 | phone | No | Telephone number for the project. |
| high | priority | No | Priority of the project. Allowed values: low, medium, high. Accepted by the Procore API on Create only. |
| 5 | program_id | No | ID of the program to associate with the project. |
| 2 | project_bid_type_id | No | Identifier for the project bid type. |
| A-2 | project_number | No | Project number. |
| 8 | project_owner_type_id | No | Identifier for the project owner type. |
| 22 | project_region_id | No | Project region ID. |
| 1 | project_sector_id | No | ID of the project sector associated with the project. |
| 1 | project_stage_id | No | Identifier for the project stage. |
| 99 | project_template_id | No | ID of the project template used to create this project. Must reference a project defined as a template. |
| 5 | project_type_id | No | Identifier for the project type. |
| Notes | public_notes | No | Public notes for the project. |
| commercial | sector | No | Sector of the project (e.g. commercial, residential, industrial. See the Procore API reference for the full list of allowed values. |
| 5000 | square_feet | No | Total square footage for the project. Whole number. |
| 1 | standard_cost_code_list_id | No | Identifier for the Standard Cost Code List. Accepted by the Procore API on Update only. |
| 5/15/2015 | start_date | No | Date the contract for the project is signed. Format: YYYY-MM-DD. |
| CA | state_code | No | State code in ISO-3166 Alpha-2 format (e.g. CA, NY). |
| 3 | store_number | No | Store number for the project. |
| US/Pacific | time_zone | No | Timezone for the project (e.g. US/Pacific, US/Eastern). |
| 10000 | total_value | No | Total amount of construction work performed, planned, or put in place. Whole number — DataBlend sends this as an integer, so decimals are not supported. |
| 6/10/2016 | warranty_end_date | No | End date for the project warranty. Format: YYYY-MM-DD. |
| 5/16/2015 | warranty_start_date | No | Start date for the project warranty. Format: YYYY-MM-DD. |
| new_construction | work_scope | No | Work scope of the project. Allowed values: new_construction, renovation_alteration, maintenance_service. |
| 93110 | zip | No | Postal/zip code for the project. |
More questions about Procore API requirements? Please visit the Procore API site https://developers.procore.com/reference/rest/projects?version=latest.