Feishu Node icon

Feishu Node

Feishu Node

Actions106

Overview

This node, named "Feishu Node," provides various operations related to Feishu services. Specifically, for the resource "电子表格" (Spreadsheet) and operation "查询工作表" (Query Sheet), it allows users to query data from a specified spreadsheet by providing its token and sheet ID. This is useful for automating data retrieval from spreadsheets stored in Feishu, enabling workflows that integrate spreadsheet data into other processes such as reporting, data analysis, or triggering actions based on spreadsheet content.

Practical examples include:

  • Automatically fetching updated rows from a spreadsheet to process them further.
  • Integrating spreadsheet data into CRM or project management tools.
  • Extracting specific sheet data for notifications or dashboards.

Properties

Name Meaning
电子表格 Token The token of the spreadsheet.
工作表 ID The ID of the worksheet within the spreadsheet.

These properties are required inputs when performing the "查询工作表" operation on the "电子表格" resource.

Output

The node outputs an array of JSON objects representing the queried data from the specified worksheet. Each item corresponds to a row or data entry retrieved from the sheet. The exact structure depends on the sheet's content but will be returned as JSON for easy consumption in subsequent workflow steps.

If any errors occur during the query, and if the node is configured to continue on failure, error details will be included in the output JSON under an error field.

No binary data output is indicated in the source code.

Dependencies

  • Requires an API key credential for Feishu services (referred generically as an API authentication token).
  • The node relies on internal helper methods and a ResourceFactory to dynamically call the appropriate method for the resource-operation pair.
  • No external environment variables are explicitly mentioned, but proper configuration of the Feishu API credentials in n8n is necessary.

Troubleshooting

  • Common issues:

    • Invalid or missing spreadsheet token or sheet ID will cause the operation to fail.
    • Network or API errors from Feishu service may interrupt data retrieval.
    • If the specified resource-operation combination is not implemented, the node throws an error indicating the method is not implemented.
  • Error messages:

    • "未实现方法: 电子表格.查询工作表" means the requested operation is not implemented; verify the resource and operation names.
    • Errors with NodeApiError indicate API-level failures; check the API token validity and permissions.
    • Other errors will be wrapped and reported with their message and stack trace for debugging.
  • Resolution:

    • Ensure correct and valid input parameters.
    • Verify API credentials and network connectivity.
    • Use the "Continue On Fail" option to handle errors gracefully in batch processing.

Links and References

Discussion