For more information, please refer to this announcement explaining best practices for getting answers to questions.
Join Candidate to Requisition record
Content
Hi all
I am trying to join the candidate and requisition data. Below is the use case for the data that i am trying to retrieve through REST API calls. Please look into it and suggest the possible ways to achieve it.
Say we have a Cand A, Cand B
Cand A has applied to Requisition R1 and R2 and got hired for R2.
Cand B has applied to Requisition R1 and got hired for R1.
When i search for candidates with Status=Hired i will have the Cand A and Cand B in the result set, now i wanted to find Cand A is hired for which requisition ? For this purpose using the relationship URL for requisition received in the candidate record response xml i have retrieved the list of requisitions that Cand A has applied. I have received multiple requisitions (R1,R2) as he has applied for more than one position and now i will have to filter out the requisition (R2) that he has got hired for. I am unable to find any join