Do everything in one place
Customize your Concur and Google BigQuery integration with the following
triggers and actions.
Triggers
When this happens…
Concur
- New expense report submissionNew expense report submission in Concur
- New expense reportNew expense report in Concur
- New or updated invoiceNew or updated invoice in Concur
- New or updated userNew or updated user in Concur
- New or updated expense reportNew or updated expense report in Concur
Any other trigger you can think up
Google BigQuery
- New job completedNew job completed in BigQuery
- New rowNew row in a table in BigQuery
- New rows BatchNew batch of rows in a table in BigQuery
- Scheduled query BatchNew scheduled query using custom SQL in BigQuery
Any other trigger you can think up
Actions
Do this…
Concur
- Custom actionCustom action in Concur (Custom)
- Upload receipt imageUpload receipt image in Concur
- Create list itemCreate list item in Concur
- Create userCreate user in Concur
- Create users BatchCreate users in Concur
- Create vendors BatchCreate vendors in Concur
- Delete list itemDelete list item in Concur
- Get all attendee types BatchGet all attendee types in Concur
- Get all expense group configurations BatchGet all expense group configurations in Concur
- Get all expense types BatchGet all expense types in Concur
- Get all lists BatchGet all lists in Concur
- Get all payment types BatchGet all payment types in Concur
- Search users BatchSearch users in Concur
- Get entry image URLGet entry image URL in Concur
- Get expense report detailsGet expense report details by report ID in Concur
- Get all list item BatchRetrieve first level list item in Concur
- Get invoice detailsGet invoice by ID in Concur
- Get userGet user profile in Concur
- Get user provisioning status detailsGet user provisioning status details in Concur
- Submit expense report through a workflowSubmit expense report through a workflow in Concur
- Search expense reports BatchSearch expense reports in Concur
- Search vendors BatchSearch vendors in Concur
- Update userUpdate user in Concur
- Update users BatchUpdate users in Concur
- Update vendors BatchUpdate vendors in Concur
Any other action you can think up
Google BigQuery
- Custom actionCustom action in Google BigQuery (Custom)
- Get batch of rows by Job ID BatchGet batch of rows from query result in BigQuery
- Insert rowInsert a row in table in BigQuery
- Insert rows BatchInsert rows in table in BigQuery
- Load data into BigQueryLoad data into table on BigQuery
- Load data from Google Cloud Storage into BigQueryLoad data from Google Cloud Storage into table on BigQuery
- Run custom SQL in BigQueryRun custom SQL in BigQuery
- Select rows (Old) BatchSelect rows asynchronously in a table in BigQuery
- Select rows BatchSelect rows in a table in BigQuery
- Select rows using custom SQL (Old) BatchSelect rows asynchronously using custom SQL in BigQuery
- Select rows using custom SQL BatchSelect rows using custom SQL in BigQuery
- Select rows using custom SQL and insert into table BatchSelect rows using custom SQL and insert into table in BigQuery
Any other action you can think up
The wonders of Workato
Easily set up as many intelligent automations you need.
- 1000s of ready-to-use templates
- Accelerate work with intelligent automation
- Do it yourself, faster
- Build bots. Put them to work