Convex icon

Convex

Interact with Convex API

Actions10

Database (Function) → Get Many Rows

AI-generated

Summary

Fetches rows from a Convex table using the n8n_nodes_convex:n8nGetRows query. Choose a table from the dropdown or enter a custom table name; set the creation-time sort order, maximum number of rows, and number to skip.

Inputs

  • Table Name or ID (required) — Select a table from the available list, or choose the manual option. The node sanitizes the table name before querying.
  • Custom Table Name (required) — Shown for the manual table option. Enter the table name; the node attempts to register it before querying, then uses it for the query.
  • Sort Order — Sorts by creation time, ascending or descending; defaults to descending.
  • Limit — Maximum number of rows to return; defaults to 50.
  • Offset — Number of rows to skip; defaults to 0.

Output shape

A list of n8n items, one for each returned row.

Each row is returned as JSON. If a row has a truthy _creationTime, the node formats it as a date-time string. Convex query errors raise an operation error.

Links

Discussion