Retrieve rows from Datastore | Wrk Automation Documentation

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.

Retrieve all rows from Baserow

Retrieve all rows from a table in Coda

Retrieve all view rows from Coda

Retrieve all rows from NocoDB

Query table in Datastore