template Data Analyst app failed with error
I tried out the Data Analyst app that analyzes GSheet. However, initially the app complained about
👉 400 Thread messages or instructions must contain the word 'json' in some form to use 'response_format' of type 'json_object'.
Then I added the "output format in JSON" in the instruction. But it failed with a different error message:
👉 400 Runs with
response_format
of type json_object
type are only compatible if all tools are type function
.
Now I am not sure what this means. I thought the template was supposed to work out of the box. Any ideas?2 Replies
I finally got the error resolved. But then the return message asked for the URL to the Google Sheet. Which should have already been made available by the tool node. {
"message": "Please provide the URL of the Google Spreadsheet containing your expenditure data so I can access and analyze it.",
"threadId": "thread_Lw51Uq7cHY5BpWk4HxGk07Oq"
}. Why it didn't pick up the Google Sheet from the node?
I worked around the issue using URL scrapping on CSV
Hello! @kuldude could you share the template you are using? I'm having the same issue