Dingtalk Node icon

Dingtalk Node

Interact with the Dingtalk API
Join our community

Actions16

Overview

This node integrates with the AI表格 (AI Table) service to update records in a specified table. It is useful when you want to programmatically modify existing data entries within an AI表格 spreadsheet, such as updating titles, statuses, or other fields of records based on dynamic inputs.

Common scenarios include:

  • Automating updates to project management tables.
  • Synchronizing external data changes into AI表格.
  • Bulk editing records based on workflow logic.

For example, you might use this node to update the "标题" (Title) field of specific records by providing their record IDs and new values in JSON format.

Properties

Name Meaning
AI表格ID (baseId) The unique identifier of the AI表格 base (spreadsheet). Can be obtained via the "解析URL" operation.
数据表ID或名称 (sheetIdOrName) The ID or name of the sheet within the AI表格 base where records will be updated. Also retrievable via the "解析URL" operation.
操作人的 unionId (operatorId) The unionId of the user performing the operation. This can be fetched from user management details.
请求体 JSON (body) The JSON request body specifying which records to update and their new field values. Must follow the official API structure, e.g.:
json<br>{<br> "records": [<br> {<br> "id": "String",<br> "fields": {<br> "标题": "新标题"<br> }<br> }<br> ]<br>}<br>

Output

The node outputs JSON data representing the response from the AI表格 API after attempting to update the records. This typically includes confirmation of updated records or error information if the update failed.

No binary data output is produced by this node.

Dependencies

  • Requires an API key credential for authenticating with the AI表格 service.
  • The node depends on the official AI表格 API endpoint for updating records.
  • Proper configuration of the API authentication token in n8n credentials is necessary.
  • The user must have valid baseId, sheetIdOrName, and operatorId values to perform updates.

Troubleshooting

  • Invalid or missing IDs: If baseId, sheetIdOrName, or operatorId are incorrect or missing, the API call will fail. Ensure these are correctly retrieved from prior operations or user management.
  • Malformed JSON body: The body property must be valid JSON matching the expected schema. Errors in JSON syntax or structure will cause the update to fail.
  • Permission errors: The operator's unionId must have sufficient permissions to update records in the target AI表格 base.
  • API rate limits or network issues: Temporary failures may occur due to API limits or connectivity problems; retrying may help.
  • Error messages returned from the API will usually indicate the cause, such as invalid record IDs or unauthorized access. Review the message and adjust parameters accordingly.

Links and References

Discussion