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

response_format

response_format

response_format of type

json_object

json_object

json_object

json_object type are only compatible if all tools are type

function

function

function

function.

Now I am not sure what this means. I thought the template was supposed to work out of the box. Any ideas?

kuldudeOP•6/3/24, 9:37 PM

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?

kuldudeOP•6/4/24, 5:06 PM

I worked around the issue using URL scrapping on CSV

ssmedusass•7/26/24, 2:03 PM

Hello! @kuldude could you share the template you are using? I'm having the same issue