kuldude
kuldude5mo ago

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
kuldude
kuldude5mo ago
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
ssmedusass
ssmedusass3mo ago
Hello! @kuldude could you share the template you are using? I'm having the same issue