NocoDB (Custom) icon

NocoDB (Custom)

Work with NocoDB rows and links

Actions9

Row → Get

AI-generated

Summary

Get a single row from a NocoDB table by its record ID. Specify the base (project) and table (optionally within a workspace), and the record ID. Optionally, limit the response to specific fields via the Fields option in Record Options, or expand linked relations via the Expand Relations option in Record Options.

Inputs

  • workspaceId — Optional workspace to resolve the base by name or ID
  • baseId (required) — Base (project) identifier or slug
  • tableId (required) — Table identifier or slug
  • recordId (required) — Source record ID
  • recordOptions.fields — Array of field IDs or names to return (if empty, all fields are returned)
  • recordOptions.expandRelations — If true, expands all link fields to include linked record data
  • recordOptions.sort — Ignored for Get operation
  • recordOptions.page — Ignored for Get operation

Output shape

Array containing a single object representing the requested row, with fields as specified and link fields expanded if enabled

If expandRelations is true, link fields are replaced with objects containing the linked records. If fields is specified, only those fields are included in the output (plus any link fields expanded if expandRelations is true).

Examples

Example 1: Get a specific user record by ID, including only name and email fields

Set baseId to your project, tableId to 'users', recordId to the user's ID, and in Record Options set Fields to ['name', 'email']

Links

Discussion