Actions112
- 知识库 Actions
- 群组管理 Actions
- 通讯录 Actions
- 任务 Actions
- 云文档 Actions
- 多维表格 Actions
- 消息 Actions
- 日历 Actions
- Aily Actions
- 云空间 Actions
多维表格 → 多维表格 - Upsert row(s)
AI-generatedSummary
Matches incoming records against conditions in a Feishu Bitable table and upserts each record using the mapped values: matching rows are updated, and rows without a match are inserted. Configure the App token and table ID, choose whether any or all conditions must match, and map fields manually or automatically from each input item’s JSON.
Inputs
- 凭证类型 — Choose user-level OAuth2 or application-level credentials; application-level credentials are the default.
- 多维表格 App 的唯一标识 (app_toke) (required) — The Bitable App token.
- 多维表格数据表的唯一标识 (table_id) (required) — The ID of the table to search and upsert into.
- Combine Conditions — Combine Match conditions with Any Condition (OR, default) or All Conditions (AND).
- Match — Add one or more field conditions to identify rows. Select a column and a type-dependent operator, then enter a value unless the operator is Is Empty or Is Not Empty. The default operator is equals. Conditions are sent as the upsert filter.
- Values to Upsert — Map table fields to values to write. Define mappings directly or automatically map input JSON fields; automatic mapping can exclude named fields. Null, undefined, and empty-string values are omitted. Multi-select values accept arrays or comma-separated strings. For attachment fields, provide incoming Binary field names, comma-separated if needed; the default is data. Read-only table fields are skipped.
- Options: 用户 ID 类型 — Choose open_id (default), union_id, or user_id for user values.
- Options: Batching — Requests are batched concurrently by default: up to 10 items per batch, with a 1000 ms wait between batches. Set batch size and interval to adjust the rate; a zero batch size is treated as 1 and a zero interval disables the wait.
- Options: 排除字段 — In automatic mapping mode, omit these input JSON fields. Accepts a comma-separated string or an expression that returns a string array.
- Options: Timeout — Maximum time in milliseconds to wait for a response; 0 (default) means no timeout.
Output shape
A list of n8n items containing the API response data for each processed input item.
The implementation uses the Feishu API response data directly; it does not flatten or simplify records. If Continue On Fail is enabled, failed items produce an item with an error field. Attachment binary data is uploaded to Feishu before the row upsert.