Get Row(s)

Retrieves a single row or multiple rows from a table.

Overview

This procedure gets a single row or multiple rows from a table. Optionally, a row selection formula can be specified to narrow the retrieval.

You can retrieve up to a maximum of 1,000 rows.

Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

get the table's row(s)

What does it do?

Instructs the system to get one or more rows from a table. If a single-row request returns multiple rows, a question will be raised, prompting you to select one.

Where does it go?

This phrase should be written on a new line.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — A reference to the table must be defined in the automation.

the row selection formula is

What does it do?

None

Where does it go?

Indented under get the table's row(s) where.

Is it required?

❌ No — This phrase is optional.

Does it require data?

❌ No — This phrase does not require data.

Examples

1. Get a Single Row

Automation

create an sample table
get the table's row

Results

A question is raised saying Multiple rows found, please select a row to continue.

2. Get a Single Row Using a Row Selection Formula

Automation

create an sample table
get the table's row where
    the row selection formula is "Name == john"

Results

Name	Number	Address	City
john	+ 1 [phone]	123 east street	San Francisco

3. Get Multiple Rows

Automation

create an sample table
get the table's rows

Results

the rows

Address	City	Name	Number
123 east street	San Francisco	john	+ 1 [phone]
321 west street	San Jose	joe	+ 1 [phone]
213 north street	San Francisco	jack	+ 1 [phone]

4. Get Multiple Rows Using a Row Selection Formula

Automation

create an sample table
get the table's rows where
    the row selection formula is "City == San Francisco"

Results

the rows

Name	Number	Address	City
john	+ 1 [phone]	123 east street	San Francisco
jack	+ 1 [phone]	213 north street	San Francisco