-png.png?width=670&height=328&name=Screenshot%20(1279)-png.png)
Overview
DataBlend supports the following data targets for creating and modifying records in Procore.
- Budget Change
- Contract Payment
- Create WBS Code
- Cost Code
- Cost Type
- Direct Cost
- Project
- Project User
- Project Vendor
- Purchase Order Contract
- Requisition (Subcontractor Invoices)
- Segment
- Timesheet
- Update WBS Code
- User
Configuration
|
Setting |
Required/ Optional |
Description |
|---|---|---|
|
Type |
Required |
Procore |
|
Query |
Required |
Select the query that will generate the data for this target. |
|
Query Mode |
Required |
Choose New unless you have a reason for choosing Latest or Specific. |
|
Credential |
Required |
Select a Procore Credential from the list. |
|
Target Type |
Required |
Choose the Procore collector type from the drop-down menu. |
|
Procore Data Target Type |
Required |
Select from the pre-populated drop-down menu. |
|
Company |
Required |
Select the company name from the drop-down menu to AutoUpsert, Create, or Update a desired company. |
|
Action |
Optional |
Select AutoUpsert, Create, or Update a desired company from the drop-down menu. |
|
Continue on Error |
Optional |
Enable or disable the continue on error toggle to continue sending data if an error occurs. |
History Retention
History Retention (Days) allows users to decide how long they want the information from their data targets to be stored. This field is optional.
Timeout (seconds)
The Timeout section allows users to determine if they would like to timeout collections taking longer than a set number of seconds to collect data.
Skip If No Records Found
The “Skip if No Records Found” button is used to eliminate sending information to Data Targets unnecessarily. Simply enable the “Skip if No Records Found” toggle. The use of this toggle is optional.
Agent
The Agent drop-down for users to select any agent they have established. This is optional.
Run As
Run As allows users to select from a drop-down list of users to run the Workflow. This is optional. Please note that Run As is only available to Admin users. If a user is set as the Run As and then demoted to a Member, the user which demoted the Run As user will instead be set as the Run As.
Object Type: Direct Cost
To update line items for the Direct Cost Object Type, select Direct Cost Line Item for Type field.
You can link the line item to a header by using the invoicenumber and vendorid fields when using DirectCostItem.
Field Names
| Field Name | Required | Note |
| DirectCostItem | Use if sending with header. | |
| id | Update | |
| projectid | ||
| attachments | ||
| description | ||
| directcostdate | ||
| employeeid | ||
| invoicenumber | Create | Used to link to header if sent with header. |
| origindata | ||
| originid | ||
| paymentdate | ||
| receiveddate | ||
| status | ||
| terms | ||
| vendorid | Create | Used to link to header if sent with header. |
| directcosttype | Create | |
| manualamount | ||
| wbscodeid | Create | |
| description | ||
| directcostid | ||
| origindata | ||
| originid | ||
| quantity | ||
| ref | ||
| unitcost | ||
| uom | ||
| DirectCostLineItem | Use if not sending with header. | |
| id | Update | |
| directcostid | Always | Used to determine which header the line item belongs to. |
| projectid | Always | |
| amount | ||
| wbscodeid | ||
| costcodeid | ||
| description | ||
| directcostid | ||
| extendedtype | ||
| quantity | ||
| lineitemtypeid | ||
| origindata | ||
| originid | ||
| unitcost | ||
| uom |