Cannot query from ZipCodeGis entity

Forum for users and developers of Bullhorn's API service.

Moderators: StaffingSupport, s.emmons, BullhornSupport

Post Reply
dreameral
User
Posts: 6
Joined: Mon Nov 25, 2019 1:04 pm

Cannot query from ZipCodeGis entity

Post by dreameral » Wed Jan 15, 2020 12:34 pm

I am sending a POST request to https://rest33.bullhornstaffing.com/res ... 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 a.id, ...]",
"errorMessageKey":"errors.badSearchQuery","errorCode":400
}

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?

Post Reply