Do everything in one place
Customize your EdApp and Google BigQuery integration with the following
triggers and actions.
Triggers
When this happens…
EdApp
- Course Completed Real-timeGets Course details when Course is completed
- Course Published Real-timeGets Course details when Course is published
- Course Unpublished Real-timeGets Course details when Course is unpublished
- Custom trigger Real-timeAllows sending a custom payload to this endpoint
- Lesson Completed Real-timeGets Lesson details when Lesson is completed
- Lesson Published Real-timeGets Lesson details when Lesson is published
- Lesson Unpublished Real-timeGets Lesson details when Lesson is unpublished
- Rapid Refresh Retry Session Started Notification Real-timeGets Rapid Refresh details when Rapid refresh retry session is started
- Rapid Refresh Session Reminder Notification Real-timeGets Rapid Refresh details when Rapid refresh session is reminded
- Rapid Refresh Session Started Notification Real-timeGets Rapid Refresh details when Rapid refresh session is started
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…
EdApp
- Delete UserDelete User in EdApp by Username
- Get Course CollectionsGets Catalog Course Collections in account with page and page size optional value
- Get Course LessonsGets Catalog Lessons in course with page and page size optional value
- Get CoursesGets Catalog All Courses in account with page and page size optional value
- Get Courses in CollectionGets Catalog All Courses in a course collection with page and page size optional value
- Get User by IdGets User in EdApp by User Id
- Get User coursesGets User courses by User Id with page and page size optional value
- Get UsersGets Users with page and page size optional value
- Add or Update UserCreate User if not exists otherwise update to EdApp
- Add or Update Users BatchUpload a batch of users to add or update based on username / externalid to EdApp
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