Dingtalk Node icon

Dingtalk Node

Interact with the Dingtalk API
Join our community

Actions16

Overview

This node operation allows users to delete a specific field from an AI table (referred to as "AI表格"). It is useful in scenarios where you need to programmatically remove unwanted or obsolete columns from a data table managed within the AI表格 system. For example, if a data column is no longer relevant for analysis or reporting, this operation can automate its removal without manual intervention.

Practical examples include:

  • Cleaning up data tables by removing deprecated fields.
  • Automating schema updates in AI表格 workflows.
  • Managing dynamic datasets where fields may be added or removed based on business logic.

Properties

Name Meaning
AI表格ID (baseId) The unique identifier of the AI table (base). Can be obtained via the "解析URL" operation.
数据表ID或名称 (sheetIdOrName) The ID or name of the specific sheet within the AI table. Can be retrieved via the "解析URL" operation.
字段ID或字段名称 (fieldIdOrName) The ID or name of the field (column) to be deleted from the specified sheet.
操作人的 unionId (operatorId) The unionId of the operator performing the deletion. This can be fetched from user management details.

Output

The output JSON will typically contain the result of the delete operation, such as confirmation of success or details about the deleted field. If an error occurs, the output JSON will include an error field with the error message.

No binary data output is expected from this operation.

Example output JSON structure:

{
  "success": true,
  "deletedField": "fieldIdOrName"
}

or in case of failure:

{
  "error": "Error message describing what went wrong"
}

Dependencies

  • Requires an API key credential for authenticating with the AI表格 service.
  • The node depends on the AI表格 API endpoints that allow field deletion.
  • Proper permissions are needed for the operator identified by operatorId to perform deletions.
  • The user must have access to retrieve baseId, sheetIdOrName, and operatorId from other operations or external sources.

Troubleshooting

  • Common issues:

    • Invalid or missing baseId, sheetIdOrName, or fieldIdOrName parameters will cause the operation to fail.
    • Insufficient permissions for the operator (operatorId) may result in authorization errors.
    • Attempting to delete a non-existent field will likely return an error.

  • Error messages:

    • "Operation not found": Indicates the selected operation is invalid or not implemented.
    • "Field not found": The specified field does not exist in the given sheet.
    • "Unauthorized" or "Permission denied": The operator does not have rights to delete fields.

  • Resolutions:

    • Verify all IDs and names are correct and correspond to existing resources.
    • Ensure the operator has the necessary permissions.
    • Use the "解析URL" operation or user management queries to obtain accurate identifiers.

Links and References

  • AI表格 official documentation (for API usage and authentication)
  • User management API docs (to retrieve operator unionId)
  • n8n documentation on creating custom nodes and handling credentials

Discussion