Dingtalk Node icon

Dingtalk Node

Interact with the Dingtalk API
Join our community

Actions16

Overview

This node operation "删除多行记录" (Delete Multiple Rows) under the resource "AI表格" (AI Table) allows users to delete multiple records from a specified AI table sheet in one request. It is useful for batch removal of data rows based on their record IDs, which can help maintain or clean up datasets efficiently.

Common scenarios include:

  • Removing outdated or incorrect entries from an AI-powered spreadsheet.
  • Bulk deleting records after processing or archiving.
  • Automating data management workflows where multiple rows need to be deleted simultaneously.

For example, if you have an AI table with sales data and want to remove all records related to canceled orders, you can provide their record IDs in the request body to delete them in one API call.

Properties

Name Meaning
AI表格ID (baseId) The unique identifier of the AI table base. Can be obtained via the "解析URL" (Parse URL) operation of AI表格. Required to specify the target base.
数据表ID或名称 (sheetIdOrName) The ID or name of the specific sheet within the AI table base. Also retrievable via the "解析URL" operation. Required to specify the target sheet.
操作人的 unionId (operatorId) The unionId of the operator performing the deletion. This identifies the user making the request and can be fetched from user management details.
请求体 JSON (body) JSON object containing the list of record IDs to delete. Example: {"recordIds":["String"]}. Refer to official docs for exact format. Required.

Output

The output of this operation is a JSON object representing the response from the AI表格 API after attempting to delete the specified records. It typically includes success confirmation or error details per record.

No binary data output is involved.

Dependencies

  • Requires an API key credential for authenticating with the AI表格 (Dingtalk Noatable) API.
  • The node depends on correct configuration of this credential in n8n.
  • Network access to the Dingtalk Open Platform API endpoint is necessary.
  • The user must have appropriate permissions to delete records in the specified AI table.

Troubleshooting

  • Common issues:

    • Invalid or missing baseId, sheetIdOrName, or operatorId will cause the API call to fail.
    • Providing incorrect or non-existent record IDs in the request body will result in partial or complete failure of deletion.
    • Insufficient permissions for the operator may lead to authorization errors.
    • Malformed JSON in the body property can cause request rejection.

  • Error messages:

    • "Operation not found": Indicates the selected operation is invalid or not implemented.
    • API errors returned from the Dingtalk platform usually contain descriptive messages; check these for guidance.
    • Network or authentication errors suggest checking API credentials and connectivity.

  • Resolution tips:

    • Verify all required properties are correctly set and valid.
    • Ensure the operator's unionId corresponds to a user with delete permissions.
    • Validate the JSON structure of the request body before execution.
    • Consult the official API documentation linked below for detailed requirements.

Links and References

Discussion