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
- Ensure the starting entity is set to "PickListValueV2".
- Use the "Picklist_Code" field for filtering picklist values.
- 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
SAP Knowledge Base Article - Public