Google BigQuery and HDCC ACC Connector integration | Workato

Market leaders run on Workato

Build Powerful Workflows, fast

Triggers

When this happens…

Google BigQuery

New job completed
New job completed in BigQuery
New row
New row in a table in BigQuery
New rows Batch
New batch of rows in a table in BigQuery
Scheduled query Batch
New scheduled query using custom SQL in BigQuery

Any other trigger you can think up

HDCC ACC Connector

New event in a project Real-time
New event in a project in Autodesk Construction Cloud
Fetch Budgets in a project Batch
Fetch ACC projects for budget syncing
Fetch Contracts in a project Batch
Fetch ACC projects for contract syncing
New or updated object in a project
New or updated object in a project in Autodesk Construction Cloud
New or updated RFI and Submittal in a project Batch
New or updated RFIs or Submittals in Autodesk Construction Cloud project

Any other trigger you can think up

Actions

Do this…

Google BigQuery

Custom action
Custom action in Google BigQuery (Custom)
Get batch of rows by Job ID Batch
Get batch of rows from query result in BigQuery
Insert row
Insert a row in table in BigQuery
Insert rows Batch
Insert rows in table in BigQuery
Load data into BigQuery
Load data into table on BigQuery
Load data from Google Cloud Storage into BigQuery
Load data from Google Cloud Storage into table on BigQuery
Run custom SQL in BigQuery
Run custom SQL in BigQuery
Select rows (Old) Batch
Select rows asynchronously in a table in BigQuery
Select rows Batch
Select rows in a table in BigQuery
Select rows using custom SQL (Old) Batch
Select rows asynchronously using custom SQL in BigQuery
Select rows using custom SQL Batch
Select rows using custom SQL in BigQuery
Select rows using custom SQL and insert into table Batch
Select rows using custom SQL and insert into table in BigQuery

Any other action you can think up

HDCC ACC Connector

Create a Budget in a project
Create a single Budget in Autodesk Construction Cloud Cost Management
Upsert Folder
Creates a new folder in ACC Docs under a specified parent folder. If a folder with the same name already exists, returns the existing folder instead.
Create object in a project
Create object in a project in Autodesk Construction Cloud
Create Multiple RFIs in a project
Create multiple RFIs in a project in Autodesk Construction Cloud
Custom action
Custom action in Autodesk Construction Cloud
Download object in a project
Download object in Autodesk Construction Cloud
Get attachment Links for RFI in a project
Get attachment Links for RFI in a project in Autodesk Construction Cloud
Get object in a project
Get object in Autodesk Construction Cloud
Get Multiple users in a project
Get users in a project in Autodesk Construction Cloud
Pick account (hub)
Pick account (hub) in HDC c autodesk construction cloud
Search for objects in a project
Search for object in a project in Autodesk Construction Cloud
Update object in a project
Update object in a project in Autodesk Construction Cloud
Update Multiple RFIs in a project
Update multiple RFIs in a project in Autodesk Construction Cloud
Upload file to a project
Uploads a new file to a specified folder in ACC Docs and creates the corresponding item
Upload File or New Version
Smart upload action. Provide Item URN to push a new version onto an existing file. Leave it blank to create a brand-new file in the given folder.
Upload object to a project
Upload object to a project in Autodesk Construction Cloud

Any other action you can think up

One platform

Power
Agility
Speed
Innovation