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 add new records into a specified data table. It is useful when you want to programmatically insert structured data rows into an AI-powered spreadsheet or database managed by the AI表格 platform.

Common scenarios include:

  • Automating data entry from other systems into AI表格.
  • Collecting form submissions or API data and appending them as new records.
  • Synchronizing external datasets with AI表格 tables.

For example, you might use this node to insert customer feedback entries collected via a web form directly into an AI表格 sheet for further analysis.

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 target data table within the AI表格 base where records will be added.
操作人的 unionId (operatorId) The unionId of the operator performing the action. This can be retrieved from user management details.
请求体 JSON (body) The JSON request body specifying the records to insert. Must follow the official API format, e.g., {"records":[{"fields":{"字段名":"字段值"}}]}.

Output

The node outputs JSON data representing the response from the AI表格 API after attempting to insert the records. This typically includes information about the inserted records such as their IDs and any metadata returned by the service.

If the insertion fails, the output may contain an error message describing the issue.

The node does not output binary data.

Dependencies

  • Requires an API key credential for authenticating with the AI表格 (Dingtalk) API.
  • The node depends on network access to the AI表格 API endpoints.
  • Proper configuration of the API authentication credentials in n8n is necessary.

Troubleshooting

  • Missing or invalid AI表格ID/baseId: Ensure that the baseId is correctly obtained and provided; otherwise, the API will reject the request.
  • Incorrect sheetIdOrName: Verify that the target data table ID or name exists within the specified AI表格 base.
  • Invalid operatorId: The operator's unionId must be valid and authorized to perform record insertions.
  • Malformed JSON in the request body: The body property must be a valid JSON string matching the expected schema. Use the official documentation to verify the structure.
  • API authentication errors: Check that the API key credential is set up correctly and has sufficient permissions.
  • Network issues: Confirm that your environment allows outbound requests to the AI表格 API.

Common error messages usually indicate which parameter is missing or invalid, or if there are permission issues. Reviewing the error message and cross-checking input parameters often resolves these problems.

Links and References

Discussion