SAP Knowledge Base Article - Public

3674640 - Code Field Filtering Not Supported for OData API Entity 'PicklistOption'

Symptom

When viewing a picklist in the Picklist Center, you will see a "code" field on the page.

You are attempting to filter the Picklist using the 'Code' value in the Picklist Center by API.

However, when you try to retrieve this picklist using the API with the URL: /odata/v2/PicklistOption?$filter=Code eq 'ACADEMICDEGREE_ARE'&$format=json, you are unable to filter out the desired results. 

"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 HXM Suite

  • OData API

Reproducing the Issue

Query: /odata/v2/PicklistOption?$filter=Code eq 'ACADEMICDEGREE_ARE'&$format=json

Cause

The starting entity used for the operation was incorrect.

Resolution

  1. Ensure the starting entity is set to "PickListValueV2".
  2. Use the "Picklist_Code" field for filtering picklist values.
  3. Example: /odata/v2/PickListValueV2?$filter=Picklist_Code eq 'ACADEMICDEGREE_ARE'&$format=json

See Also

Help Portal:PickListValueV2|Help portal

Keywords

odata api framework, picklist field, selectID, picklist_code, external code, update picklist value, PickListValueV2, field update , KBA , LOD-SF-INT-ODATA , OData API Framework , How To

Product

SAP SuccessFactors HCM Core all versions