SAP Knowledge Base Article - Public

2790871 - Bad property expression when trying to query "addressXxx" series from FOLocation Entity

Symptom

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

An error encountered when trying to query  "addressXxx" series from FOLocation entity.

Example of "addressXxx" series from FOLocation Entity in the ODATA API data dictionary (addressZipCode,addressState,addressProvince,addressCountry.. etc)

DataDictionary.png

Example Query:

https://apisalesdemoX.successfactors.com/odata/v2/FOLocation?$select=addressZipCode

Error Message:

[COE0003]Bad property expression: FOLocation/addressZipCode; FOLocation/addressZipCode is not viewable

error.png

Environment

SuccessFactors BiZx

Cause

The "addressXxx" series properties are only used to write address related information while upserting FOLocation data. While querying FOLocation data, these information will be contained under navigation "addressNavDEFLT".

Resolution

  • Please use parameter $expand=addressNavDEFLT for reading these information.

    Example Query using "addressZipCode" and Result per using the $expand=addressNavDEFLT

    zipcode.png

Keywords

[COE0003] Bad property expression, COE_BAD_PROPERTY_EXPRESSION , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , Problem

Product

SAP SuccessFactors HCM Core 1902