Dingtalk Node icon

Dingtalk Node

Interact with the Dingtalk API
Join our community

Actions16

Overview

This node interacts with the AI表格 (AI Table) service to retrieve all fields from a specified data table within an AI表格 base. It is useful when you need to programmatically access metadata about the columns or fields of a particular sheet in an AI表格 base, for example, to dynamically generate forms, validate input data, or synchronize schema information.

Practical examples include:

  • Fetching all column definitions before importing or exporting data.
  • Dynamically building user interfaces based on the fields available in a specific AI表格 sheet.
  • Automating workflows that depend on the structure of AI表格 tables.

Properties

Name Meaning
AI表格ID (baseId) The unique identifier of the AI表格 base. Can be obtained via the "解析URL" operation.
数据表ID或名称 (sheetIdOrName) The ID or name of the target data table (sheet) within the AI表格 base.
操作人的 unionId (operatorId) The unionId of the operator performing the action. Can be retrieved via user management.

Output

The node outputs JSON data containing the list of all fields (columns) in the specified AI表格 sheet. Each item in the output corresponds to a field and includes its metadata such as field name, type, and other relevant attributes defined by the AI表格 API.

If the node supports binary data output, it would typically represent attachments or files related to the fields, but based on the provided code and properties, this node focuses on JSON metadata output only.

Dependencies

  • Requires an API key credential for authenticating with the AI表格 service.
  • Needs network access to the AI表格 API endpoints.
  • Proper configuration of the node’s credentials in n8n is necessary to authorize requests.
  • The baseId, sheetIdOrName, and operatorId must be valid and correspond to existing resources in the AI表格 system.

Troubleshooting

  • Common issues:

    • Invalid or missing baseId, sheetIdOrName, or operatorId will cause the operation to fail.
    • Network connectivity problems can prevent successful API calls.
    • Insufficient permissions for the provided operator may result in authorization errors.

  • Error messages:

    • "Operation "<operation>" not found": This indicates the requested operation is not implemented or incorrectly specified.
    • API errors returned from AI表格 usually contain descriptive messages; ensure the IDs and operator unionId are correct.
    • If the node throws errors related to credentials, verify that the API key or authentication token is correctly set up in n8n.

  • Resolution tips:

    • Double-check all input parameters for correctness.
    • Confirm that the operator has sufficient rights to access the specified base and sheet.
    • Ensure the API credentials are valid and have not expired.
    • Use the "continue on fail" option cautiously to handle partial failures gracefully.

Links and References

Discussion