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 list multiple records from a specified data table. It is useful for scenarios where you need to retrieve filtered or specific sets of rows from an AI-powered spreadsheet or database managed within the AI表格 platform.

Typical use cases include:

  • Extracting records that match certain criteria for further processing or reporting.
  • Automating workflows that depend on dynamic data stored in AI表格 tables.
  • Integrating AI表格 data retrieval into larger automation pipelines, such as syncing data with other systems or triggering actions based on record contents.

For example, you might use this node to fetch all records where the "标题" (Title) field equals "test", then process those records downstream in your workflow.

Properties

Name Meaning
AI表格ID (baseId) The unique identifier of the AI表格 base (spreadsheet/database). Can be obtained via the AI表格 URL parsing operation.
数据表ID或名称 (sheetIdOrName) The ID or name of the specific data sheet/table within the AI表格 base. Also retrievable through the AI表格 URL parsing operation.
操作人的 unionId (operatorId) The unionId of the operator performing the request. This identifies the user and can be fetched from user management details.
请求体 JSON (body) A JSON object representing the request body, including filters and conditions to specify which records to list. Example: {"filter":{"combination":"and","conditions":[{"field":"标题","operator":"equals","value":"test"}]}}. Refer to the official API documentation for detailed structure.

Output

The node outputs an array of JSON objects, each representing a record retrieved from the AI表格 data table according to the specified filter conditions.

  • The json output contains the fields and values of each matching record.
  • If the node supports binary data output (not indicated here), it would typically represent attachments or files associated with records, but this node focuses on JSON data.

Dependencies

  • Requires an API key credential for authenticating with the AI表格 service.
  • Needs proper configuration of the API authentication token in n8n credentials.
  • The node depends on the AI表格 API endpoint for listing records, so network access to the API is necessary.
  • The user must have appropriate permissions and valid identifiers (baseId, sheetIdOrName, operatorId) to query the data.

Troubleshooting

  • Common issues:

    • Invalid or missing baseId, sheetIdOrName, or operatorId will cause the API call to fail.
    • Incorrectly formatted JSON in the "请求体 JSON" property may lead to errors or no results.
    • Insufficient permissions for the operatorId may result in authorization errors.
    • Network connectivity problems can prevent successful API calls.

  • Error messages:

    • "Operation "<name>" not found": Indicates the selected operation is invalid or not implemented; ensure the correct operation is chosen.
    • API errors related to authentication or authorization usually indicate invalid credentials or insufficient user rights.
    • JSON parsing errors suggest malformed input in the request body; validate JSON syntax carefully.

  • Resolutions:

    • Verify all IDs and operator unionId are correct and accessible.
    • Use the AI表格 URL parsing operation to obtain accurate IDs.
    • Validate the JSON request body using online tools or JSON validators.
    • Confirm API credentials are correctly set up in n8n.
    • Check network connectivity and firewall settings.

Links and References

Discussion