Cannot query from JobBoardPost 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 JobBoardPost entity

Post by dreameral »

I sent a POST request to https://rest33.bullhornstaffing.com/res ... bBoardPost with the following JSON in the body of the request:

{
"where": "id is not null",
"fields": "location",
"count": 500,
"start": 0
}

The issue happens only when the field 'location' is included to fields. The response we get is as below:

{
"errorMessage":"javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query",
"errorCode":400
}

We need a general solution for this, we can't go and hard code stuff, to not include the 'location' in the fields, or for other issues the API may have.

The location field is of type 'TO_ONE', but also the 'owner' field is of type 'TO_ONE' and that works just fine.
Post Reply