Feishu Spreadsheet Failed to Read Worksheet

langgenius / dify

Dify is an open-source LLM app development platform. Dify's intuitive interface combines AI workflow, RAG pipeline, agent capabilities, model management, observability features and more, letting you quickly go from prototype to production.

https://dify.ai

Other

52.6k stars 7.69k forks source link

Feishu Spreadsheet Failed to Read Worksheet #10570

Open chattor opened 1 week ago

chattor commented 1 week ago

Self Checks

[X] This is only for bug report, if you would like to ask a question, please head to Discussions.
[X] I have searched for existing issues search for existing issues, including closed ones.
[X] I confirm that I am using English to submit this report (我已阅读并同意 Language Policy).
[X] [FOR CHINESE USERS] 请务必使用英文提交 Issue，否则会被关闭。谢谢！:）
[X] Please do not modify this template :) and fill in all the required fields.

Dify version

0.11.0

Cloud or Self Hosted

Cloud

Steps to reproduce

When using the node to read row data from a Feishu spreadsheet, a number was input to specify the number of rows to read. However, an error message appeared. The error display is as follows: Xnip2024-11-12_11-07-16

✔️ Expected Behavior

Reading worksheet row data using the spreadsheet works correctly.

❌ Actual Behavior

Reading worksheet row data using the spreadsheet fails to read data correctly.

dosubot[bot] commented 1 week ago

I found a similar unsolved discussion that might be related to your issue. You can check it out here ^[1].

Regarding your issue with reading row data from a Feishu spreadsheet in Dify version 0.11.0, ensure that all required parameters are correctly configured. The ReadTableTool class requires specific parameters such as spreadsheet_token, sheet_id or sheet_name, start_row, and num_rows. Additionally, make sure that the app_id and app_secret are correctly set for authentication ^[2].

If the error persists, it might be helpful to check if there are any recent changes or updates in the Dify codebase related to Feishu spreadsheet integration that could affect its functionality, although I couldn't find specific information on recent changes ^[2].

To continue talking to Dosu, mention @dosu.

crazywoola commented 1 week ago

@hgnulb Can you take a look at this issue?

chattor commented 1 week ago

@hgnulb Can you take a look at this issue?

The starting line number cannot be entered as a variable for now and can only accept numbers. Although this solves the issue of the node being unavailable when reading Lark (Feishu) spreadsheets, it also results in the inability to read data from a long spreadsheet in multiple parts. I hope you can retain the feature that allows variables to be entered for the starting line number.