Get Rows

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.

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

Input Concepts

Concept	Type	Description	Default	Required
row selection formula	string	A pandas query expression to select the row.	No default	No

Output Concepts

Concept	Description
row	The selected row.

Note: If multiple rows are found, a question will be raised asking you to select a row to continue.

Examples

In the examples below, the table refers to the following table, which can be generated using the create a sample table procedure:

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

1. Get a Single Row

Automation

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

2. Get Multiple Rows

Automation

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

Results

A question is raised saying Multiple rows found, please select a row to continue. The user can pick the suggested value out of the following rows:

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