EdCast and Google BigQuery integrations and automations

Do everything in one place

Customize your EdCast and Google BigQuery integration with the following triggers and actions.

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

Actions

Do this…

EdCast
  • Add Learning goals to the user
    Add a Learning goal to the user in Edcast LXP
  • Add a Member to a Group
    Add a member to a group in EdCast LXP
  • Assign manager to user
    Assign manager to user by User External ID or User Email ID.
  • Create a Group
    Create a group in EdCast LXP
  • Create User Badge
    Create badge for a user in EdCast LXP
  • Create User Skill
    Create Skill for a user in EdCast LXP
  • Create User Records
    Create users records in EdCast LXP (maximum batches of 10)
  • Custom action
    Custom action in EdCast LXP
  • Delete user skill
    Delete User Skill from Edcast LXP
  • Get list of users
    Get list of users in EdCast LXP
  • Get Groups
    Get groups in EdCast LXP
  • Get user by ID
    Get a user record in EdCast LXP
  • Get User Skill Credentials
    Get Skill credential for a user in EdCast LXP
  • Get Users Groups
    Returns the user's group(s) from EdCast LXP
  • Remove Learning goals to the user
    Remove a Learning goal of the user in Edcast LXP
  • Remove a Member From a Group
    Remove a Member from a Group in EdCast LXP
  • Unassign manager from user
    Unassign manager from user by User External ID or User Email ID
  • Update a Group
    Update a group in EdCast LXP
  • Update User Record by ID
    Update a user record in EdCast LXP
  • Update User Status
    Update a user's status in EdCast LXP

    • Any other action you can think up

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

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

Market leaders run on Workato

  • mgm
  • adobe
  • att
  • atlassian
  • slack

Let’s start automating

Schedule a Demo