SAP Knowledge Base Article - Public

3323412 - OData API Candidate entity error "[COE0019]Failed to retrieve result with given criteria" - Recruiting Management

Symptom

  • Failed to get candidate information via OData API.
  • Error in Response: "[COE0019]Failed to retrieve result with given criteria".

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors Recruiting Management

Cause

This is a generic error and here are some possible causes identified so far:

  1. The field id "name" is defined as a Standard field in Candidate Profile template. (For Support only: see internal memo)
    <field-definition id="name" type="text" required="false" custom="false" anonymize="false" sensitive="false">
  2. Data type mismatch caused due to a field type change. For example, a Text type field has been changed to Number type or Picklist type.
  3. The custom picklist field used as a filter is not a reportable field.

Resolution

Possible Cause 1: The field id "name" is defined as a Standard field

  1. Check if the field id "name" is defined in the Candidate Profile template.
  2. Set it as CUSTOM field with the attribute custom="true".
  3. Refresh the metadata via Admin Center > OData API Metadata Refresh.

Note: It is not supported to change the custom attribute via the Manage Templates tool. This change can be done via Provisioning only.

If you are no longer working with an Implementation Partner, you can submit a change request to SAP Support using the approval document downloaded from the following KBA.

  • KBA 2258199 - Software Change Request for SuccessFactors Recruiting Management
  • Request item: "XML Template Upload due to Manage Templates limitation"

Possible Cause 2: Data type mismatch caused due to a field type change

Please update the field value for existing candidates via OData API or Integration Center.

If you don't know which field caused the error, please open a support ticket and provide details as per KBA 2437841 - Troubleshooting API issues - what you need to provide to Support - Recruiting Management.

Possible Cause 3: The custom picklist field used as a filter is not a reportable field

Please refer to KBA 2372331 - Error: "Failed to retrieve result with given criteria." occurs when trying to filter on a picklist field using OData API - Recruiting Management

Keywords

ODATA query, OData API Candidate Export, Candidate Profile, GET, invalid column name: T.RCM_CANDIDATE, RCM-66130  , KBA , LOD-SF-RCM-API , Webservices & APIs , LOD-SF-RCM-CAN , General Candidate Issues (not Offers, not Profiles) , Problem

Product

SAP SuccessFactors Recruiting all versions