Symptom
Getting a general ODATA error trying to query JobReqFwdCandidates and filtering on "status"
Environment
SAP SuccessFactors Recruiting Management
Reproducing the Issue
ODATA Request:
GET .../odata/v2/JobReqFwdCandidates?$filter=status eq Forwarded
Error in Response:
<code>COE_GENERAL_SERVER_FAILURE</code>
<message lang="en-US">[COE0019]Failed to retrieve result with given criteria.</message>
Cause
Incorrect value in the filter
Resolution
The value in the "status" filter should be the Status ID and not the Status Name.
Correct queries below:
GET …/odata/v2/JobReqFwdCandidates?$filter=status eq '3' (for 'Default' status)
GET …/odata/v2/JobReqFwdCandidates?$filter=status eq '1' (for 'Forwarded' status)
Keywords
ODATA query, JobReqFwdCandidates , status , KBA , LOD-SF-RCM-API , Webservices & APIs , Problem