code 1017: Invalid where clause. Not Existing columns.

eric-yi · August 7, 2015, 10:59pm

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

curl -H "Content-Type: application/json" -X "GET" -v "https://api.backendless.com/v1/data/Request?where=requestId%3DF92G3W"

(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 https://api.backendless.com/v1/data/Request, I get back a list of results including the entry with requestId F92G3W.
Why am I getting this error?

eric-yi · August 8, 2015, 12:18am

When I change the requestId to 1 and GET https://api.backendless.com/v1/data/Request?where=requestId%3D1, I get the correct object returned. So it may be a problem with strings.

mark-piller · August 8, 2015, 2:01am

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

eric-yi · August 8, 2015, 2:04am

Sure

PS The “secretkeys” are fake so no worries.

mark-piller · August 8, 2015, 2:08am

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

requestId=F92G3W

must be written like this:

requestId='F92G3W'

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

Regards,
Mark

eric-yi · August 8, 2015, 2:12am

That did the trick! Thanks Mark.