Procore Collectors
Overview
DataBlend collects the following objects from Procore:
- Budgets
- Budget Details
- Budget Views
- Budget View Summary Rows
- Companies
- Company Inactive People
- Company Inactive Users
- Company Inactive Vendors
- Company People
- Company Permission Template
- Company Trades
- Company Users
- Company Vendors (List)
- Company Vendors (Show)
- Contract Payments
- Cost Codes
- Cost Types
- Direct Costs
- Payment Applications Owner Invoices
- Projects
- Project Templates
- Project WBS Codes
- Project WBS Segments
- Purchase Order Contracts
- Requisition Change Order Items
- Requisitions
- Requisition (Subcontract) Invoices
- Timesheets
- Work Order Contracts
|
Setting |
Required/ Optional |
Comments |
|---|---|---|
|
Type |
Required |
Procore |
|
Name |
Required |
Free text descriptive name for the collector |
|
Data Source |
Required |
DataBlend data source for the collected report |
|
Credential |
Required |
Procore Credential |
|
Schema Name |
Required |
DataBlend schema for the collected report. |
|
Procore Collector Type |
Required |
Select the Collector Type from the drop-down menu. |
Company Vendor Views
Company Vendors (List) displays all vendors. Company Vendors (Show) allows selecting a single vendor. Below is a list of available View selections and the table lists the fields included in each.
- Compact
- Normal
- ERP
- Extended (default if View field is left blank)
- Directory
- Summary
|
Compact |
Normal |
ERP |
Extended (Default) |
Directory |
Summary |
|
id |
id |
id |
id |
id |
id |
|
name |
abbreviated_name |
abbreviated_name |
abbreviated_name |
abbreviated_name |
active_users_count |
|
|
address |
address |
address |
address |
bids_count |
|
attachments |
attachments |
attachments |
attachments |
business_id |
|
|
authorized_bidder |
authorized_bidder |
authorized_bidder |
authorized_bidder |
company_vendor |
|
|
business_id |
business_id |
bidding |
bidding |
connected_to_company_id |
|
|
business_phone |
business_phone |
bidding_distribution |
bidding_distribution |
is_connected |
|
|
business_register |
business_register |
business_id |
business |
name |
|
|
city |
city |
business_phone |
business_id |
open_bids_count |
|
|
company |
company |
business_register |
business_phone |
projects_count |
|
|
company_vendor |
company_vendor |
children_count |
business_register |
synced_to_erp |
|
|
connected_to_company_id |
connected_to_company_id |
city |
city |
|
|
|
contact_count |
contact_count |
company |
company_vendor |
||
|
country_code |
country_code |
company_vendor |
connected_to_company_id |
||
|
created_at |
created_at |
connected_to_company_id |
contract_signer |
||
|
email_address |
email_address |
contact_count |
country_name |
||
|
fax_number |
erp_custom_fields |
country_code |
created_at |
||
|
is_active |
fax_number |
created_at |
email_address |
||
|
is_connected |
is_active |
email_address |
fax_number |
||
|
labor_union |
is_connected |
fax_number |
invoice_contacts |
||
|
license_number |
labor_union |
is_active |
is_connected |
||
|
logo |
license_number |
is_connected |
labor_union |
||
|
mobile_phone |
logo |
labor_union |
legal_name |
||
|
name |
mobile_phone |
legal_name |
license_number |
||
|
non_union_prevailing_wage |
name |
license_number |
logo |
||
|
notes |
non_union_prevailing_wage |
logo |
mobile_phone |
||
|
origin_code |
notes |
mobile_phone |
name |
||
|
origin_data |
origin_code |
name |
non_union_prevailing_wage |
||
|
origin_id |
origin_custom_fields |
non_union_prevailing_wage |
notes |
||
|
prequalified |
origin_data |
notes |
prequalified |
||
|
primary_contact |
origin_id |
origin_code |
primary_contact |
||
|
state_code |
prequalified |
origin_data |
standard_cost_codes |
||
|
synced_to_erp |
primary_contact |
origin_id |
state_code |
||
|
trade_name |
state_code |
parent |
state_name |
||
|
union_member |
synced_to_erp |
prequalified |
trade_name |
||
|
updated_at |
trade_name |
primary_contact |
trades |
||
|
vendor_group |
union_member |
project_ids |
union_member |
||
|
website |
updated_at |
standard_cost_codes |
updated_at |
||
|
zip |
vendor_group |
state_code |
website |
||
|
|
website |
synced_to_erp |
zip |
||
|
zip |
trade_name |
|
|||
|
|
trades |
||||
|
union_member |
|||||
|
updated_at |
|||||
|
vendor_group |
|||||
|
website |
|||||
|
zip |