SAP Knowledge Base Article - Public

2955976 - How to retrieve picklist labels using Integration Center/OData API

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

Product

SAP SuccessFactors HCM Suite all versions