Page 1 of 1

Cannot query from ZipCodeGis entity

Posted: Wed Jan 15, 2020 12:34 pm
by dreameral
I am sending a POST request to ... ZipCodeGis with the following request body:

"where": "id is not null",
"fields": "id,areaCode,city,countryID,latitude,latitudeActual,longitude,longitudeActual,state",
"count": 500,
"start": 0

and the response we get back is:

"errorMessage":"Bad Query: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: 7 near line 1, column 364 [SELECT, ...]",

This definitely does not look like an error the end user should get. Even if we're missing something you should at least be able to handle the error.

Anyway, are we missing something here? How can we avoid this error?