Do everything in one place
Customize your Google BigQuery and NHS Electronic Staff Record (ESR) Wrapper integration with the following
triggers and actions.
Triggers
When this happens…
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…
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
NHS Electronic Staff Record (ESR) Wrapper
- GET Absence RecordGet individual Absence Record
- GET Absence Record ListGet Absence Record List
- GET Competence Assignment RecordGet individual Competence Assignment Record
- GET Competence Assignment Record ListGet Competence Assignment Record List
- GET Competence Definition RecordGet individual Competence Definition Record
- GET Competence Definition Record ListGet Competence Definition Record List
- GET Competency RecordGet individual Competency Record
- GET Competency Record ListGet Competency Record List
- GET Costing RecordGet individual Costing Record
- GET Costing Record ListGet Costing Record List
- GET Disability RecordGet individual Disability Record
- GET Disability Record ListGet Disability Record List
- GET Element RecordGet individual Element Record
- GET Element Record ListGet Element Record List
- GET Location RecordGet individual Location Record
- GET Location Record ListGet Location Record List
- GET Organisation RecordGet individual Organisation Record
- GET Organisation Record ListGet Organisation Record List
- GET Person Eit RecordGet individual Person Eit Record
- GET Person Eit Record ListGet Person Eit Record List
- GET Person RecordGet individual Person Record
- GET Person Record ListGet Person Record List
- GET Position Eit RecordGet individual Position Eit Record
- GET Position Eit Record ListGet Position Eit Record List
- GET Position RecordGet individual Position Record
- GET Position Record ListGet Position Record List
- GET Qualification RecordGet individual Qualification Record
- GET Qualification Record ListGet Qualification Record List
- GET Sit RecordGet individual Sit Record
- GET Sit Record ListGet Sit Record List
- GET Training Absence RecordGet individual Training Absence Record
- GET Training Absence Record ListGet Training Absence Record List
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
