API Data Provider - Online Help
Procore Profile
Connecting to Procore
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
AccidentLogs
ActualProductionQuantities
AdminEquipmentLogs
BidBoardProjects
Bids
BillingPeriods
BudgetChangeAdjustmentLineItems
BudgetedProductionQuantities
CallLogs
Companies
CompanyFolders
CompanyInactivePeople
CompanyInactiveUsers
CompanyInactiveVendors
CompanyInsurances
CompanyOffices
CompanyPeople
CompanyPermissionTemplates
CompanyTimecardEntries
CompanyTimecardEntryChangeHistory
CompanyUsers
CompanyVendors
CostCatalogs
CostCodes
CostItems
Crews
DailyConstructionReportLogs
DelayLogs
Departments
DirectCosts
Equipment
EquipmentCategories
EquipmentMakes
EquipmentModels
EquipmentTypes
FieldProductionReport
Incidents
Injuries
Locations
MeetingDetails
Meetings
ObservationsAssigneeOptions
Programs
ProjectBidTypes
ProjectDocumentCustomTags
ProjectEquipment
ProjectInactivePeople
ProjectInactiveUsers
ProjectInactiveVendors
ProjectInsurances
ProjectOwnerTypes
ProjectPeople
ProjectPermissionTemplates
ProjectRegions
ProjectRoles
Projects
ProjectStages
ProjectTaskItems
ProjectTemplates
ProjectTimecardEntries
ProjectTools
ProjectTypes
ProjectUsers
ProjectVendors
PurchaseOrderContractLineItems
PurchaseOrderContracts
Requisitions
Roles
StandardCostCodeLists
StandardCostCodes
Subjobs
SubmittalStatuses
TaskItemsAssigneeOptions
Tasks
TimecardEntries
Timesheets
Trades
WorkflowActivityHistory
WorkflowInstances
WorkLogs
WorkOrderContractLineItems
WorkOrderContracts
Departments
Return a list of Departments.
Columns
Name
Type
References
Id [KEY]
Long
Name
String
OriginData
String
OriginId
String