Teable (TuanDK) icon

Teable (TuanDK)

Read and write records, tables, and spaces in Teable

Actions14

Record → Get

AI-generated

Summary

Retrieves a single Teable record by its ID from a chosen table and returns it as one output item per input item.

Inputs

  • Space (required) — Teable space, chosen from a dropdown. Only used to populate the Base dropdown; not sent in the request.
  • Base (required) — Base within the selected space. Only used to populate the Table dropdown.
  • Table (required) — Table containing the record. Its ID goes into the request path and must contain only letters, digits, underscores or hyphens.
  • Record ID (required) — ID of the record (recXXXXXXXX). Validated to letters, digits, underscores or hyphens. It can be set with an expression for each input item.
  • Additional Options — Collection with two optional settings. Field Key Type is 'name' (default) or 'id' (fldXXX) and sets how field keys appear in the response. Cell Format is 'json' (default, structured values) or 'text' (plain strings).

Output shape

One output item per input item. Its json is the record object returned by Teable's GET /table/{tableId}/record/{recordId}, typically the record id and its fields.

The node runs once for each input item, so recordId can vary per item. Requests that fail with HTTP 429 or 5xx are retried up to 3 times, with no delay between attempts. If Continue On Fail is enabled, a failed item outputs { error: message } instead of stopping the workflow.

Examples

Example 1: Look up a record whose ID came from a previous node, such as a webhook or a search.

Select Space, Base and Table. Set Record ID to the expression {{ $json.recordId }}. Leave Additional Options empty.

Example 2: Fetch a record keyed by field IDs with plain-text cell values.

Set Record ID to rec123abc. Under Additional Options, set Field Key Type to Field ID and Cell Format to Text.

Links

Discussion