Dingtalk Node icon

Dingtalk Node

Interact with the Dingtalk API

Overview

This node interacts with the AI表格 (AI Table) service to retrieve all data tables associated with a specified AI表格 ID. It is useful when you want to programmatically fetch and process all sheets or tables from an AI-powered spreadsheet platform, for example, to integrate table data into workflows, automate reporting, or synchronize data with other systems.

A practical example would be automating the extraction of all tables from a given AI表格 document to feed into a data analysis pipeline or to back up the data regularly.

Properties

Name Meaning
AI表格ID (baseId) The unique identifier of the AI表格 document. This ID can be obtained via the "AI表格 解析URL" operation.
操作人的 unionId (operatorId) The unionId of the operator performing the action. This can be retrieved through user management by querying user details.

Output

The node outputs JSON data representing all the data tables fetched from the specified AI表格 document. Each item in the output corresponds to a data table with its content structured as JSON. The exact structure depends on the AI表格 API response but typically includes rows, columns, and cell values.

There is no indication that the node outputs binary data.

Dependencies

  • Requires an API key credential for authenticating with the AI表格 service.
  • The node depends on the external AI表格 API to fetch data tables.
  • Proper configuration of credentials and permissions to access the AI表格 document and user information is necessary.

Troubleshooting

  • Missing or invalid AI表格ID: Ensure the baseId property is correctly set and corresponds to an existing AI表格 document.
  • Invalid operatorId: The operatorId must be a valid unionId of a user authorized to perform the operation.
  • API authentication errors: Verify that the API key credential is configured properly and has sufficient permissions.
  • Network or API errors: Check network connectivity and the status of the AI表格 service.
  • Operation not found error: If the node throws an error about the operation not being found, ensure the correct operation name "获取所有数据表" is selected.

Links and References

  • AI表格 official documentation (for API usage and obtaining baseId): [Link not provided in source]
  • User management API documentation (to get operator unionId): [Link not provided in source]

Discussion