Lookup tables by Workato and MySQL integrations and automations

Do everything in one place

Customize your Lookup tables by Workato and MySQL integration with the following triggers and actions.

Triggers

When this happens…

MySQL
  • New row
    New row in a table in MySQL
  • New rows Batch
    New batch of rows in a table in MySQL
  • Scheduled query Batch
    New/updated batch of rows via scheduled custom SQL in MySQL
  • New/updated row
    New/updated row in a table in MySQL
  • New/updated rows Batch
    New/updated batch of rows in a table in MySQL

    • Any other trigger you can think up

Actions

Do this…

Lookup tables by Workato
  • Add entries Batch
    Add entries to lookup table
  • Add entry
    Add entry to lookup table
  • Delete multiple entries Batch
    Delete multiple entries from lookup table
  • Delete entry
    Delete entry in lookup table
  • Get all entries Batch
    Get all entries from lookup table
  • Lookup entry
    Lookup entry from lookup table
  • Search entries Batch
    Search entries in lookup table
  • Truncate table Batch
    Truncate all entries from lookup table
  • Update entry
    Update entry in lookup table

    • Any other action you can think up

MySQL
  • Delete rows Batch
    Delete rows in a table in MySQL
  • Execute stored procedure Batch
    Execute stored procedure in MySQL
  • Export query result
    Export query result as a CSV file in MySQL
  • Insert row
    Insert row in a table in MySQL
  • Insert rows Batch
    Insert batch of rows in a table in MySQL
  • Run custom SQL Batch
    Run custom SQL in MySQL
  • Run long query using custom SQL
    Run long query using custom SQL in MySQL
  • Select rows Batch
    Select rows in a table in MySQL
  • Get table schema
    Get table schema for MySQL
  • Update rows
    Update rows in a table in MySQL
  • Upsert rows Batch
    Upsert batch of rows in a table in MySQL
  • Upsert row
    Upsert row in a table in MySQL

    • 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

  • monday
  • box
  • att
  • atlassian
  • slack

Let’s start automating

Schedule a Demo