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 |
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
Supported Filter Conditions (SQL-like)
You can add a condition to filter results using SQL-like syntax. The following types of comparisons and values are supported:
✅ Comparison Operators
Operator | Description | Example |
| Equal to |
|
| Not equal to |
|
| Greater than |
|
| Less than |
|
| Greater than or equal to |
|
| Less than or equal to |
|
✅ Logical Operators
You can combine multiple conditions:
AND– All conditions must be true
Example:status = 'active' AND age >= 18OR– At least one condition must be true
Example:status = 'pending' OR status = 'review'
✅ Supported Value Types
Text:
'John','example'Numbers:
42,3.14Boolean:
true,falseDate/Time:
'2024-05-01','2024-05-01T12:00:00Z'(ISO 8601)
🚫 Not Supported
List matching (e.g.
status IN (...))Pattern matching (e.g.
LIKE 'abc%')Between ranges (e.g.
price BETWEEN 10 AND 20)Subqueries or nested expressions
Function calls (e.g.
LOWER(name))