Retrieves data from a database table.
The table to retrieve data from.
The number of records to retrieve from the table.
The fields to retrieve for each record. By default, no fields are retrieved.
Conditions for filtering the retrieved data. You can create conditions against the values of the record's fields or against values from previous steps in the flow. The conditions themselves behave the same as conditions in the If component.
Options for sorting the retrieved data. You can sort one or more columns in ascending or descending order.
Options for grouping the retrieved data.
You can group columns by applying the following mathematical functions to a column:
An array of objects representing each database record that was retrieved.
Updated 8 months ago