The Data Table: Get Rows Node allows for querying your application’s data tables and storing the results of the query on your workflow’s payload.
The node takes a number of parameters, most of which are optional.
- Table ID Template: The table on which the query should be performed. You may select one of your application’s tables or enter a string template, which should resolve to a valid table ID.
- Result Path: A payload path defined at the bottom of the editor for where the result of the query will be stored. This result will include the query itself, the items in the query, and some additional meta information; or, the result will include an error if the query is invalid.
Building your query within the node is nearly identical to building a query within the table browsing interface. The only difference is, when building a query within the node, you may use string templates for each property and value – or, if building an advanced query, you may use a JSON template.
If you selected a data table directly instead of using a template, there will be a section detailing all of the columns in the table and their data types to assist you in building your query.
The query section is optional. If you do not include any queries, all rows will be returned and then limited by the filter fields defined below. However, if you do include any piece of a query (e.g. the
Property), you must also include the other two pieces (the
Operator and the
Optionally, you may also include some parameters for sorting, limiting and paginating the results of the query. All of these fields are templatable.
- Sort By Template is the field by which the results should be sorted. If using a template, this should resolve to one of your table’s column names or one of the default columns. Default is
- Sort Direction Template must be either
descor a template that resolves to one of those values. Default is
- Limit Template must be a number between 1 and 1000, or a template that resolves to such a number. Default is
- Offset Template must be a number greater than or equal to 0, or a template that resolves to such a number. This is similar to requesting a specific page of results, except you are defining the number of records to skip instead of a page to return. Default is