Do everything in one place
Customize your Epic and Google BigQuery integration with the following
triggers and actions.
Triggers
When this happens…
Epic
- New PatientTriggers when a new patient is added to a specified list.
- New ProcedureTriggers when a new procedure is added for a specific patient
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…
Epic
- Find AppointmentFind appointment in system
- Get AppointmentGet Appointment in FHIR
- Book AppointmentBook Appointment in FHIR
- Create DocumentReferenceCreate DocumentReference in FHIR
- Create a patientcreate a new patient
- Create Questionnaire ResponseCreate Questionnaire Response in FHIR
- Get Immunization by IDGet Immunization in FHIR
- Get Immunization RecommendationGet Immunization Recommendation in FHIR
- Get Patient by IDGet Patient in FHIR
- Search Immunization RecommendationSearch Immunization Recommendation in FHIR
- Search ImmunizationsSearch Immunizations in FHIR
- Get patient's medication historyGet patient's medication history in Epic
- Observation SearchObservation Search in Epic
- Observation UpdateObservation Update in Epic
- Observation Create (Vitals)Observation Create (Vitals) in Epic
- Match PatientMatch patient in FHIR
- Create ProblemCreate Problem in Epic
- Read Service Request(Community Resource) (R4)Read Service Request in Epic
- Read TaskRead Task in Epic
- Search for patientSearch for patient with Date of birth and last name
- Search TasksSearch Tasks in Epic
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