Symptom
Country-specified entity, e.g. PerAddressDEFLT, field address3 is configured as picklist for some countries and configured as field/integer for some countries.
address3 field configured as picklist for some countries and configured as integer/free-text for some countries.
Trying to fetch address3 label (PerAddressDEFLT -> Address3Nav -> PicklistLables -> Label) for a country.
Consider for specific country "Belgium", address3 field is configured as integer/free-text not as picklist. API response for picklist should be null because for that specific country, address3 configured as integer/free-text not picklist. But in this case, API is fetching the random picklist value.
Query:
https://<api url>/odata/v2/PerAddressDEFLT?$format=json&$filter=personIdExternal eq '800000001951'&$expand=countryNav,countyNav/picklistLabels,cityNav/picklistLabels,stateNav/picklistLabels,address3Nav/picklistLabels,address4Nav/picklistLabels,address7Nav/picklistLabels&$nochche=123
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Belgium case, "address3" is integer/free-text, not picklist
Response: but ODATA API, incorrectly link to picklist, and return "Algeria" rather than null.
Read more...
Environment
- SAP SuccessFactors HCM Suite
- ODATA API
Product
Keywords
Country specific entity, country specific fields, picklist specific country field, string specific field, random picklist value, ODATA API, Integration Center , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT-EC , Employee Central SFAPI & OData Entities , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.