Overview
This node is designed to update a record in a multi-dimensional table (多维表格). It allows users to specify the target table and record by their identifiers, then update one or more properties of that record with new values. This functionality is useful for automating data management workflows where records need to be programmatically modified based on external triggers or inputs.
Common scenarios include:
- Updating customer information in a CRM system when new data arrives.
- Modifying inventory records in a product database after stock changes.
- Adjusting project task details dynamically as progress updates occur.
For example, you might use this node to update the status and due date of a task record in a project management table whenever a related event happens elsewhere in your workflow.
Properties
| Name | Meaning |
|---|---|
| app_token | The unique identifier of the multi-dimensional table application. |
| 记录表 (databaseId) | The specific record table to operate on. Must be selected after providing the app_token. |
| 记录ID (record_id) | The ID of the single record to update. Example: recwNXzPQv. |
| 属性 (propertiesUi) | A collection of properties to update on the record. Each property includes: - 键名或ID (key): The key or ID of the property to update. - 类型 (type): The type of the property (hidden, auto-filled). - Value fields depending on type: • 文本 (TextValue): Text string. • 公式 (FormulaValue): Formula expression. • 条形码 (BarcodeValue): Barcode string. • 电话号码 (PhoneValue): Phone number string. • 多选 (MultiSelectValue): Multiple selectable options. • 单选 (SingleSelectValue): Single selectable option. • 电子邮件 (EmailValue): Email address. • 链接名称 (name) and 链接地址 (url): URL link name and address. • 用户名称或ID (UserValue): User(s) by name or ID. • 关联ID (relation): Related record IDs, comma-separated. • 已选中 (CheckboxValue): Boolean checkbox state. • 数字 (NumberValue), 货币 (CurrencyValue), 进度 (ProgressValue), 评分 (Rating): Numeric values. • 日期 (date): ISO 8601 formatted date/time. • 创建时间 (CreatedTime), 上次编辑时间 (ModifiedTime): Timestamps. |
Output
The node outputs JSON data representing the result of the update operation. Typically, this will include confirmation of the updated record's ID and possibly the updated fields or status returned from the multi-dimensional table service.
If the node supports binary data output, it would represent attachments or files related to the record, but based on the provided code and properties, the primary output is structured JSON reflecting the updated record state.
Dependencies
- Requires access to the multi-dimensional table service identified by the
app_token. - Needs proper API authentication configured in n8n to authorize update operations.
- Dynamic loading of options depends on methods like
getOptions,getFilterProperties, andgetPropertySelectValueswhich fetch metadata about tables and properties from the service.
Troubleshooting
- Invalid
app_tokenor insufficient permissions: The node may fail to load tables or update records. Ensure the token is correct and has write access. - Incorrect
record_id: If the record ID does not exist, the update will fail. Verify the record ID before running the node. - Property value type mismatch: Providing a value that does not match the expected property type (e.g., text for a numeric field) can cause errors. Double-check property types and input formats.
- Network or API errors: Temporary connectivity issues or API rate limits may cause failures. Retry or check API usage limits.
- Empty or missing required fields: Required fields like
databaseIdandrecord_idmust be set; otherwise, the node will error out.
Links and References
- n8n Expressions Documentation
- Multi-dimensional table official API documentation (not provided here, but recommended to consult for detailed property types and update semantics).