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.

Prerequisite Data

These required data elements must be present in the automation before using the procedure.

Data Name	Data Type
the table	Table

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.

Does it require input data? ⛔ No — This phrase does not require input data.

Is it required? ✅ Yes — This phrase is required in the syntax.

the row selection formula is

What does it do? Specifies a pandas query expression for row selection.

Where does it go? This phrase should be indented beneath get the table's row(s) where.

Does it require input data? ✅ Yes — A text value should be specified.

Is it required? 🌟 No — This phrase is optional in the syntax.

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