Teable (TuanDK) icon

Teable (TuanDK)

Read and write records, tables, and spaces in Teable

Actions14

Record → Upsert

AI-generated

Summary

Update or create a single Teable record per input item. It looks up an existing record whose Match Field equals the supplied value, updates it if found, and otherwise creates a new record.

Inputs

  • Space (required) — Teable space, used to populate the Base dropdown.
  • Base (required) — Base within the selected space, used to populate the Table dropdown.
  • Table (required) — Table in which the record is searched for, updated, or created.
  • Match Field (required) — Field name used to find an existing record. It must also be included in Fields, otherwise the node throws an error.
  • Fields — List of field name and value pairs to write. Values are parsed as JSON where possible, so arrays, objects, booleans and null are converted. Numeric strings are sent as strings.
  • Additional Options — Field Key Type: 'name' (default) or 'id'. It sets how field keys are used in the request and response.

Output shape

One item per input item, with the json being the created or updated Teable record (id, fields, and so on).

The search sends an 'is' filter on the Match Field with take=1, so only the first match is updated if several exist. The search is done by field name, so with Field Key Type 'id' the filter and the Fields keys may need to be field IDs. The match field must be in Fields and, with that setting, the Match Field dropdown still gives names. The create call sends typecast: true, but the update call does not. Requests are retried up to 3 times on 429 or 5xx errors, with no delay between attempts. With Continue On Fail enabled, an item that fails returns {error: message} and processing continues.

Examples

Example 1: Sync contacts by email, updating existing rows and adding new ones.

Select Space, Base and Table. Set Match Field to Email. In Fields add Email = {{$json.email}} and Name = {{$json.name}}.

Example 2: Upsert using field IDs as keys.

Set Match Field and the Fields names to the field IDs (for example fldXXX, entered in expression mode). Set Additional Options > Field Key Type to Field ID.

Links

Discussion