Symptom
You are building an integration at Integration Center or OData API, however you can only see the internal ID or Option ID for the picklists.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
- SuccessFactors HXM Suite
- Integration center
- OData API
Reproducing the Issue
Call OData API or build an integration into Integration Center, and navigate for a Picklist value. You will only see the picklist's internal code.
Resolution
In order to fetch the Picklist Labels, you will need to navigate to the corresponding 'picklistLabel' entity for it.
For OData API, the sample URL is as follows:
https://<api-server>/odata/v2/EmpJob?$format=json&$expand=internshipSchoolNav/picklistLabels
Note: Picklist Labels are usually One-to-Many, so make sure to configure/filter the field for the desired output (check KBA 2856036 and 3087941 for more information).
See Also
Keywords
picklist labels odata, "How to fetch picklist labels while using integration center odata API" , KBA , LOD-SF-INT , Integrations , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , LOD-SF-INT-INC , Integration Center , LOD-SF-INT-INC-ODATA , ODATA API In Integration Center , How To