ACC Data Schema Descriptions
The following are the service groups included in this release of the Data Connector. Browse to the schema below for details on the schema design.
-
activities:
(html
-
json)
- Activities Data Set Description: admin (html - json)
- Activities Data Set Description: assets (html - json)
- Activities Data Set Description: cost (html - json)
- Activities Data Set Description: docs (html - json)
- Activities Data Set Description: issues (html - json)
- Activities Data Set Description: rfis (html - json)
- Activities Data Set Description: sheets (html - json)
- Activities Data Set Description: submittals (html - json)
-
Notes:
- While some Activity Data Sets may include BIM 360 project data, only ACC project data is guaranteed to be delivered
- The activities service group supports Date Range Extractions - Maximum Date Range Allowed: 31 days - Default Date Range: YESTERDAY
- admin: (html - json)
- assets: (html - json)
- changes: (html - json)
- checklists: (html - json)
- clashes: (html - json)
- cost: (html - json)
- dailylogs: (html - json)
- forms: (html - json)
- iq: (html - json)
- issues: (html - json)
- issuesbim360: (html - json)
- locations: (html - json)
- markups: (html - json)
- meetingminutes: (html - json)
- packages: (html - json)
- photos: (html - json)
- relationships: (html - json)
- reviews: (html - json)
- rfis: (html - json)
- schedule: (html - json)
- sheets: (html - json)
- submittals: (html - json)
- submittalsacc: (html - json)
- transmittals: (html - json)
Column Definition Types
The ACC Data Schema tables are often delivered in a "lowest common denominator" format (i.e. CSV) and as a result the column type definitions are limited to the following:- boolean
- date: string
- enum: string
- number
- string
- string: UUID (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)
- string: null
- timestamp: SQL (YYYY-MM-DD HH:MM:SS.mmm) (UTC)
ACC Data Schema Changes
The following link details changes made to the ACC Data Schema definitions.