code 1017: Invalid where clause. Not Existing columns.

I have a table called Request with an entry with requestId F92G3W.
When I do

curl -H "Content-Type: application/json" -X "GET" -v ""

(or Request?where=requestId=F92G3W with equal sign)
I get the error {“code”:1017,“message”:“Invalid where clause. Not Existing columns: F92G3W”}.
But when I do the same curl with, I get back a list of results including the entry with requestId F92G3W.
Why am I getting this error?

When I change the requestId to 1 and GET, I get the correct object returned. So it may be a problem with strings.

Could you post a screenshot of the Request table with the name of the columns and data in there?


PS The “secretkeys” are fake so no worries.

the reason your query didn’t work is because requestId is a STRING column. Therefore the following query:


must be written like this:


Hope this helps. When the value is just a number like 1 or 2, then Backendless does that conversion automatically.


That did the trick! Thanks Mark.