Retrieves data from a database table.

Inputs

Table

The table to retrieve data from.

Count

The number of records to retrieve from the table.

Select

The fields to retrieve for each record. By default, no fields are retrieved.

Filter

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.

Sort By

Options for sorting the retrieved data. You can sort one or more columns in ascending or descending order.

Group By

Options for grouping the retrieved data.

You can group columns by applying the following mathematical functions to a column:

  • Count
  • Sum
  • Average
  • Maximum
  • Minimum

Outputs

Data

An array of objects representing each database record that was retrieved.