Retrieve rows from Datastore

Retrieve rows from a table in Datastore.

Application

• Datastore

Inputs (what you have)

Name	Description	Data Type	Required?	Example
Table name	Name of the table to retrieve data from	Text (Short)	Yes	DataTable1
Row ID	ID of the value you would like to fetch	Text (Long)	No	MyCustomRowID
Fields	A comma-separated list of the fields you would like to return to in your search. * will return all fields	Text (Long)	No	*
Filters	Filters to apply to the retrieval. See the documentation for configuration details	Text (Long)	No	first_name = 'John'
Limit	Limit on the number of results to return	Number	No	1

Outputs (what you get)

Name	Description	Data Type	Required?	Example
Total number of rows	The total number of rows in the output JSON	Number	No
Output JSON	JSON output of the query result	Text (Long)	No

Outcomes

Name	Description
Success	This status is selected if the job has successfully completed.
No Result	This status is selected if the job has returned no results

Filter Configuration

You can apply SQL-like filters to narrow down your query results.

These filters use a familiar comparison syntax and support basic operators, list matching, and pattern matching.

---

✅ Supported Filter Conditions (SQL-like)

Comparison Operators

Operator	Description	Example
=	Equal to	first_name = 'John'
!=	Not equal to	status != 'cancelled'
>	Greater than	age > 18
<	Less than	age < 65
>=	Greater than or equal to	score >= 80
<=	Less than or equal to	created_at <= '2024-12-31'

---

List Matching

Use IN or NOT IN to match against multiple values.

Operator	Description	Example
IN (...)	Matches any of the listed values	status IN ('active', 'pending', 'review')
NOT IN (...)	Excludes all listed values	role NOT IN ('admin', 'superuser')

---

Pattern Matching

Use LIKE for text searches with wildcard support.

Pattern	Meaning	Example
%	Matches any sequence of characters	name LIKE '%John%'
_	Matches a single character	code LIKE 'A_1'

Patterns are case-insensitive by default.

---

Logical Operators

Combine multiple conditions using AND and OR.

Operator	Description	Example
AND	All conditions must be true	status = 'active' AND age >= 18
OR	At least one condition must be true	status = 'pending' OR status = 'review'

---

Supported Value Types

Type	Examples	Notes
Text	'John', 'example'	Must be enclosed in single quotes
Number	42, 3.14	Integers and decimals supported
Boolean	true, false	Case-insensitive
Date/Time	'2024-05-01', '2024-05-01T12:00:00Z'	Must be valid ISO 8601 formatted string

---

🚫 Not Supported

Feature	Example	Reason
Between ranges	price BETWEEN 10 AND 20	Use separate > and < comparisons instead
Subqueries	id IN (SELECT ...)	Nested queries not supported
Function calls	LOWER(name)	Functions not supported

---

Example Configurations

✅ Example 1 — Retrieve all rows

Table name	Fields	Filters	Limit
Users	*	(none)	10

Result: Returns up to 10 rows from the Users table.

---

✅ Example 2 — Filter by exact value

Table name	Fields	Filters	Limit
Customers	first_name, email	status = 'active'	5

Result: Returns up to 5 active customers with their name and email.

---

✅ Example 3 — Match from a list

Table name	Fields	Filters	Limit
Orders	order_id, total_amount	status IN ('paid', 'shipped')	20

Result: Returns up to 20 orders where the status is either “paid” or “shipped”.

---

✅ Example 4 — Pattern matching

Table name	Fields	Filters	Limit
Contacts	email	email LIKE '%@gmail.com'	10

Result: Returns up to 10 contacts with Gmail addresses.

---

✅ Example 5 — Combined conditions

Table name	Fields	Filters	Limit
Employees	name, department	department = 'Sales' AND name LIKE 'A%'	10

Result: Returns employees in Sales whose names start with “A”.

---

✅ Example 6 — Retrieve by Row ID

Table name	Row ID
Inventory	Item-001

Result: Returns the row that matches the specified ID.