Teable icon

Teable

Read and write records, tables, and spaces in Teable

Record → Upsert

AI-generated

Summary

Creates a Teable record when no record matches the selected Match Field value, or updates the first matching record with the supplied fields. Processes each incoming item separately in the selected space, base, and table.

Inputs

  • Space (required) — Teable space containing the target base.
  • Base (required) — Base within the selected space.
  • Table (required) — Table to search and write.
  • Match Field (required) — Field whose value identifies an existing record. This field must also be included in Fields; otherwise execution errors. The node searches for an exact match and uses the first result.
  • Fields — Field names and values to write. JSON-looking values are parsed as arrays or objects when valid. The supplied values are used for both matching and creating or updating the record.
  • Additional Options: Field Key Type — Choose human-readable field names (default) or internal field IDs for field keys in API requests.

Output shape

One n8n item containing the created or updated record for each input item.

The operation enables Teable typecasting when creating a record. If the API response does not contain a record in its records array, the raw response is returned instead. With continue-on-fail enabled, errors produce an item with an error message.

Links

Discussion