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 create a new field (column) in a specified table sheet. It is useful when you want to programmatically add custom fields to your AI表格 data tables, for example, adding status indicators, categories, or other metadata columns dynamically based on your workflow logic.

Typical use cases include:

  • Automating the expansion of your AI表格 schema as new data types or classifications are needed.
  • Integrating AI表格 with other systems where fields need to be created before inserting or updating records.
  • Managing table structures in bulk or via API-driven workflows without manual intervention.

Properties

Name Meaning
AI表格ID (baseId) The unique identifier of the AI表格 base (table collection). Can be obtained via URL parsing.
数据表ID或名称 (sheetIdOrName) The ID or name of the specific sheet within the AI表格 base where the field will be created.
操作人的 unionId (operatorId) The unionId of the operator performing the action. This identifies the user making the request.
请求体 JSON (body) The JSON body describing the field to create, including its name, type, and properties such as choices for single select fields. Example: {"name":"状态","property":{"choices":[{"name":"完成"},{"name":"失败"}]},"type":"singleSelect"}

Output

The node outputs JSON data representing the response from the AI表格 API after attempting to create the field. This typically includes details about the newly created field such as its ID, name, type, and any additional metadata returned by the API.

If the operation fails and "Continue On Fail" is enabled, the output will contain an error message under the json.error property for the corresponding item.

No binary data output is produced by this node.

Dependencies

  • Requires an API key credential for authenticating with the AI表格 API.
  • The node depends on the AI表格 service being accessible and the provided IDs (baseId, sheetIdOrName) being valid.
  • Proper permissions for the operatorId to create fields in the specified AI表格 base and sheet are necessary.
  • The JSON body must conform to the API specification described in the official documentation: https://open.dingtalk.com/document/orgapp/api-noatable-createfield

Troubleshooting

  • Common issues:

    • Invalid or missing baseId, sheetIdOrName, or operatorId will cause the API call to fail.
    • Malformed JSON in the body property can lead to request errors.
    • Insufficient permissions for the operator may result in authorization errors.
    • Network connectivity problems or incorrect API credentials will prevent successful requests.

  • Error messages:

    • "Operation "<operation>" not found": Indicates the requested operation is not implemented or incorrectly specified.
    • API error responses will be passed through in the output's error field if "Continue On Fail" is enabled.

  • Resolution tips:

    • Verify all IDs and operator information are correct and current.
    • Validate the JSON structure against the API documentation.
    • Ensure the API key credential is configured properly in n8n.
    • Check network access and firewall settings if connection issues occur.

Links and References

Discussion