Facing errors.internalError when try to do nested To-many association

[burhanhelmy]

Hi

I was trying to do a nested entity query form Placement -> JobOrder -> Categories. But I'm stumble upon "errorMessageKey": "errors.internalError" issue. This is the GET query URL that are used

Placement Query:

{{bh_rest_url}}/search/Placement?query=id:6&fields=id,salary,salaryUnit,payRate,dateAdded,owners(firstName,lastName,email,isDeleted),owner(firstName,lastName,email,isDeleted),candidate(firstName,lastName,email),clientContact(firstName,lastName,email),jobOrder(title,publishedZip,employmentType,owner(firstName,lastName,email,isDeleted),categories[1](id,name)),clientCorporation(industryList),status,commissions(id,role,user(email,isDeleted))

However if I'm search for the specific JobOrder, it was successfully return the categories result.

JobOrder Query:

{{bh_rest_url}}/search/JobOrder?query=id:16&fields=title,publishedZip,employmentType,owner(firstName,lastName,email,isDeleted),categories[1](id,name)


I'm noticed that the error is thrown only when I try to query "To-many association" but not the "To-one Association". Could Bullhorn help to support me on this?

[damarishartle]

Hi

I was trying to do a nested entity query form Placement -> JobOrder -> Categories. But I'm stumble upon "errorMessageKey": "errors.internalError" issue. This is the GET query URL that are used

Placement Query:

{{bh_rest_url}}/search/Placement?query=id:6&fields=id,salary,salaryUnit,payRate,dateAdded,owners(firstName,lastName,email,isDeleted),owner(firstName,lastName,email,isDeleted),candidate(firstName,lastName,email),clientContact(firstName,lastName,email),jobOrder(title,publishedZip,employmentType,owner(firstName,lastName,email,isDeleted),categories[1](id,name)),clientCorporation(industryList),status,commissions(id,role,user(email,isDeleted))bloxd io

However if I'm search for the specific JobOrder, it was successfully return the categories result.

JobOrder Query:

{{bh_rest_url}}/search/JobOrder?query=id:16&fields=title,publishedZip,employmentType,owner(firstName,lastName,email,isDeleted),categories[1](id,name)


I'm noticed that the error is thrown only when I try to query "To-many association" but not the "To-one Association". Could Bullhorn help to support me on this?

Based on your description, the error is thrown only when you try to query a “To-many association” but not a "To-one association". It’s possible that there might be some limitations or specific requirements when querying nested entities in Bullhorn. To get assistance with this issue, I recommend reaching out to ClientContact support.
https://bullhorn.github.io/rest-api-doc ... entcontact

[Jules17]

The error message you're encountering is "errors.internalError." Here's some information and suggestions:

Error Message Explanation: The "errors.internalError" message typically indicates a problem on the server side. It might not provide specific details about the issue, but it suggests that there's an internal problem with processing the request.

To-One vs. To-Many Associations: Your observation that the error occurs only when querying "To-many associations" (like categories) but not with "To-one associations" is important. This could be due to the way the API handles these different types of associations.

API Documentation: It's also helpful to review the Bullhorn API documentation to ensure that you're using the correct query structure and syntax for nested entity queries. They might have specific guidelines or limitations for querying nested entities.

Error Handling: Make sure that your code has proper error-handling mechanisms in place. This includes checking the API response for error codes and messages. You might also consider implementing retries for transient errors.

Query Optimization: Review your query and the data you're requesting to see if there are any potential optimizations that can be made. For example, you could try requesting fewer fields or using different query parameters.