Google BigQuery and Random.org integration | Workato

Market leaders run on Workato

Build Powerful Workflows, fast

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

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…

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

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