Get Record

nocodb.get_record
ActionDatabases & warehousesconnection required

Calls the NocoDB API with the connection's credentials.

Read one record from a table by its primary-key value.

Connection

Required
Yes — the node will not save without one
Auth type
API key
Providers
NocoDB
Secret shape
the API token, or {"api_token": "…"}
Config it needs
base_url, base_id, table_id, workspace_id
Resolved by
config.connection_id, else node.connection_id

Configuration

3 fields, 1 required. A dotted path is a nested object and name[] an array of objects — the editor renders the same tree.

FieldTypeRequiredDefaultConstraintsExample
table_id
Id of the table to act on, from Table context menu → Copy table ID. Overrides the default table id on the connection.
stringNo——mftbsyu6dxo4y8i
record_id
Primary-key value of the record, e.g. 1. Composite keys are joined with '___'.
stringYes——1
fields
Comma-separated field names to return, with no spaces. Empty returns every field.
stringNo——Id,Title,Status

Example configuration

Every value below is the contract’s own example or default — nothing invented.

{
  "fields": "Id,Title,Status",
  "record_id": "1",
  "table_id": "mftbsyu6dxo4y8i"
}

Output

One shape.

result

The provider's response object, as returned.

Extra keys beyond the ones listed can appear.

{}

Notes

  • The output is the record itself, so its keys are the table's field names.

See Get Record run in a workflow.

In a technical demo we add the NocoDB connection, drop the node on the canvas and let Workflow Health pre-flight it before the first real run.