MySQL and Random.org integration | Workato

Market leaders run on Workato

Build Powerful Workflows, fast

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

Random.org

Monitor API Quota
Monitors your RANDOM.ORG API quota and triggers when bits or requests fall below specified thresholds.

Any other trigger you can think up

Actions

Do this…

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

Random.org

Create Tickets
Creates tickets that can be used with signed methods to establish an audit trail.
Generate Binary Blobs
Generates true random binary data. Useful for cryptographic seeds, encryption keys, etc.
Generate Decimal Fractions
Generates true random decimal fractions from a uniform distribution across the [0,1) interval.
Generate Gaussian Distribution
Generates true random numbers from a Gaussian (normal) distribution with specified mean and standard deviation.
Generate Integer Sequences
Generates uniform or multiform sequences of true random integers. Useful for shuffling decks, lottery numbers, etc.
Generate Random Integers
Generates true random integers within a user-defined range using RANDOM.ORG's atmospheric noise.
Generate Signed Random Integers
Generates true random integers with a digital signature for non-repudiation. The signature proves the data came from RANDOM.ORG.
Generate Signed Random Strings
Generates true random strings with a digital signature for non-repudiation.
Generate Signed UUIDs
Generates true random UUIDs with a digital signature for non-repudiation.
Generate Random Strings
Generates true random strings using characters from a specified set. Useful for passwords, tokens, codes, etc.
Generate UUIDs
Generates true random version 4 UUIDs (Universally Unique IDentifiers) in accordance with RFC 4122.
Get Previous Result
Retrieves the result of a previous signed API call using its serial number. Results are stored for at least one year.
Get Ticket
Returns information about a specific ticket, including the random values if showResult was true.
Get API Usage
Returns information about the usage of your API key including remaining bits and requests.
List Tickets
Returns all tickets that have been created for your API key.
Verify Signature
Verifies that a signature from a signed method is authentic and came from RANDOM.ORG.

Any other action you can think up

One platform

Power
Agility
Speed
Innovation