Get rows

Use Get rows to retrieve data from a table inside an API Endpoint workflow.

It’s a good fit when you want to fetch a list (like orders, products, or messages) and then return it from your endpoint.

When to use it

• To fetch a list of rows (with optional filtering and sorting)
• To build custom endpoints (for example “search products” or “list user orders”)
• To fetch data you’ll use later in the workflow (before a Send response)

Add the action

1. In Data & API, open your API Endpoint workflow.
2. Click + Add an action.
3. Go to Data → Tables.
4. Select Get rows.

Configuration

Choose a table

Table: Select the table you want to retrieve rows from.

Pick which fields to return

In the Data section, use Fields to choose which columns (and linked fields) you want to include in the result.

Add filters and sorting (optional)

In Filters & Sort you can:

• Add Filter rules to narrow down which rows are returned
• Add Sort rules to control the order of the rows

Limit and offset (optional)

In Pagination you can:

• Set Limit to control how many rows are returned
• Set Offset to skip a number of rows (useful for paging)
• Enable Include Total Count if you want the total number of matching rows

Result

Get rows returns:

• data: The list of rows
• metadata: Helpful info like limit, offset, and (when enabled) total

You can then use this data in later logic in the endpoint, and/or return this data back to the user via the Send response action.

CONTINUE LEARNING

Learn how to return the rows from your endpoint.

Send response →