Feishu Node icon

Feishu Node

Feishu Node

Actions106

Overview

This node, named "Feishu Node," provides integration with a spreadsheet service (likely Feishu Sheets) to perform operations on spreadsheets. Specifically, the "查找单元格" (Find Cells) operation allows users to search for cells within a specified range of a worksheet by matching a string or pattern. This is useful for scenarios where you need to locate specific data points, validate content, or extract information based on cell values or formulas.

Practical examples include:

  • Searching for all cells containing a particular keyword in a project tracking sheet.
  • Finding cells that match a regular expression pattern to identify formatted data.
  • Locating cells with formulas that reference certain values for auditing purposes.

Properties

Name Meaning
电子表格 Token The token used to authenticate and access the spreadsheet.
工作表 ID The identifier of the worksheet within the spreadsheet where the search will be performed.
查找范围 The search range in the format <sheetId>!<startPosition>:<endPosition>, defining the area to search.
查找字符串 The string to find within the specified range.
是否忽略查找字符串的大小写 Whether to ignore case when searching for the string (true or false).
字符串是否需要完全匹配整个单元格 Whether the string must exactly match the entire cell content (true or false).
是否使用正则表达式查找 Whether to interpret the search string as a regular expression (true or false).
是否仅搜索单元格公式 Whether to restrict the search to only cell formulas (true or false).

Output

The node outputs JSON data representing the found cells matching the search criteria. Each output item corresponds to a matched cell and typically includes details such as the cell's address, value, and possibly formula if applicable.

If binary data were involved (e.g., exporting parts of the spreadsheet), it would be summarized here, but this node focuses on JSON output related to cell search results.

Dependencies

  • Requires an API token credential to authenticate with the spreadsheet service.
  • The node depends on the external spreadsheet API accessible via the provided token.
  • No additional environment variables are explicitly required beyond the API token.
  • The bundled code references a resource factory helper to build properties and call appropriate methods dynamically.

Troubleshooting

  • Common issues:

    • Invalid or expired spreadsheet token leading to authentication errors.
    • Incorrect sheet ID or range format causing the API to fail or return no results.
    • Using regex without proper syntax may cause search failures or unexpected matches.
    • Case sensitivity settings not matching user expectations, resulting in missed matches.

  • Error messages:

    • "未实现方法: <resource>.<operation>" indicates the requested operation is not implemented; verify resource and operation names.
    • API-related errors wrapped as NodeApiError may indicate network issues, permission problems, or invalid parameters.

  • Resolutions:

    • Ensure the token is valid and has sufficient permissions.
    • Double-check the sheet ID and range formatting.
    • Validate regex patterns before use.
    • Adjust case sensitivity and full cell match options according to needs.

Links and References

Discussion