Cannot read property 'data' of undefined (Google Sheets)

I was trying to fetch all rows of delivered orders from a google sheet that has e commerce orders, I used a Query JSON with SQL and it produced “Cannot read property ‘data’ of undefined (Google Sheets)”
here is the query:
FROM {{}}
WHERE = “Pending”;
query1 only lists all the data in the spreadsheet.
I am still a bit new to mysql and I don’t know where is the mistake, using mysql or using retool itself.

Two guesses:
First - in the “where” clause, try only “Status” instead of “”
Second - surround “” with brackets ({{}}) in the where clause
I haven’t had just that issue, so I’m not 100% sure that any of these approaches will solve your problem - a disclaimer :slight_smile:

You’ll definitely need to enclose in brackets, like {{ }}. Thanks for chiming in @daniel-andersson :grinning: