Candidate /search by tearsheet ID always return empty result - 02258057

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

Moderators: StaffingSupport, s.emmons, BullhornSupport

Post Reply
nsaputro
User
Posts: 4
Joined: Thu Jun 02, 2016 3:51 am

Candidate /search by tearsheet ID always return empty result - 02258057

Post by nsaputro » Thu Jun 02, 2016 4:56 am

Hi,

I have a problem with /search operation on Candidate entity. Bullhorn always returns empty result if queried by tearsheets.id search field.

Query:
tearsheets.id:2

Response:
{
"total" : 0,
"start" : 0,
"count" : 0,
"data" : [ ]
}

Is this a bug?

Thank you.
Nugroho

nsaputro
User
Posts: 4
Joined: Thu Jun 02, 2016 3:51 am

Re: Candidate /search by tearsheet ID always return empty result - 02258057

Post by nsaputro » Sun Jun 05, 2016 9:38 pm

I checked that search by tearsheet id works for ClientContact using the same query so it seems the problem only occurs on Candidate entity.

Could you please check.

Thank you.
Nugroho

tkobel
User
Posts: 2
Joined: Thu Jun 02, 2016 1:01 pm

Re: Candidate /search by tearsheet ID always return empty result - 02258057

Post by tkobel » Tue Jun 07, 2016 6:02 pm

you will get better results if you use shortListIDs:

Code: Select all

search/Candidate?query=shortListIDs:72&fields=
however they may not be the most up to date, depending on when the candidate was lastModified and if the tearsheet was created after that. I am not certain on this but for some tearsheets it will not return all of the candidates. I suspect that the candidates are not associated with the tearsheets through candidate search until another field that also updates the lastModified field is updated.

I ended up getting all the candidates doing an associated entity search of the tearsheets.

Code: Select all

entity/Tearsheet/72/candidates?fields=id&count=500&start=
then you would have to search for the candidates using the ids you get back.

nsaputro
User
Posts: 4
Joined: Thu Jun 02, 2016 3:51 am

Re: Candidate /search by tearsheet ID always return empty result - 02258057

Post by nsaputro » Tue Jun 07, 2016 10:52 pm

I have tried to update candidate after assigning tearsheet but still no records returned. It works on Client Contact entity so I think it is a bug.

I think for now as workaround I will use association entity retrieval although I could not add query expression using this method so I will need to manually filter the result after records retrieved.

Thank you.

tkobel
User
Posts: 2
Joined: Thu Jun 02, 2016 1:01 pm

Re: Candidate /search by tearsheet ID always return empty result - 02258057

Post by tkobel » Wed Jun 08, 2016 3:21 pm

I agree, it's a bug and thank you for looking into my lastModified theory, as I was never able to fully test it. I should mention that the bug also exists when you get the clientContacts by tearsheets.id.

When I also got the clientContacts for a specific tearsheet through query/ClientContact, it also did not return the full list of client contacts for that tearsheet. Some tearsheets had about 1-5 client contacts missing, sometimes more. I calculated about 95% of the client contacts or candidates were returned when doing candidate search by shortListIDs or querying Client Contact by tearsheets.id.

It may be best to get the clientContacts in the same way as the candidates.
If you compare the total candidates and clientContacts from the tearsheet query

Code: Select all

query/Tearsheet?fields=id,candidates,clientContacts,name&where=id>0&count=200&BhRestToken=
You will always get back the same totals when doing to-many associated entity retrieval.

TedWalters
User
Posts: 7
Joined: Mon Apr 18, 2016 1:25 pm

Re: Candidate /search by tearsheet ID always return empty result - 02258057

Post by TedWalters » Thu Jun 09, 2016 8:33 am

Hi Nugroho,

This is Ted from Bullhorn Support. I was able to run a successful /search by tearsheet ID by structuring my query in the following format:

query=tearsheet.id=(2)

Please let me know if you have any questions or if this does not work for you, and I will be happy to help!

Thanks,
Ted Walters
Technical Support Analyst

nsaputro
User
Posts: 4
Joined: Thu Jun 02, 2016 3:51 am

Re: Candidate /search by tearsheet ID always return empty result - 02258057

Post by nsaputro » Sun Jun 12, 2016 7:58 pm

I tested query=tearsheet.id=(2) does not work. Empty record is returned:

{
"total" : 0,
"start" : 0,
"count" : 0,
"data" : [ ]
}

jimh88
User
Posts: 39
Joined: Mon Apr 11, 2016 12:34 pm

Re: Candidate /search by tearsheet ID always return empty result - 02258057

Post by jimh88 » Fri Jun 24, 2016 1:06 pm

nsaputro wrote:I tested query=tearsheet.id=(2) does not work. Empty record is returned:

{
"total" : 0,
"start" : 0,
"count" : 0,
"data" : [ ]
}
I used query=tearsheets.id:2 and was able to get a result. However it only returned a single candidate back. There should be more results!

Support, please help!

maryjohn
User
Posts: 5
Joined: Wed Aug 10, 2016 6:04 am

Re: Candidate /search by tearsheet ID always return empty result - 02258057

Post by maryjohn » Wed Aug 10, 2016 6:48 am

I checked that search by tearsheet id works for ClientContact using the same query so it seems the problem only occurs on Candidate entity.

Could you please check.
Hello I Am Mary

Post Reply