Symptom
OData Query is failing with below error:
400-COE_BAD_PROPERTY_EXPRESSION Bad Request-[COE0003]Bad property expression: cannot expand non-navigation property
"code" : "COE_BAD_PROPERTY_EXPRESSION", "message" : {"lang" : "en-US", "value" : "[COE0003]Bad property expression: <Field>; cannot expand non-navigation property: <Entity>/<Field>"
Environment
- SAP SuccessFactors HCM Suite
- OData API
Reproducing the Issue
- Perform an OData API Query on an entity expanding to a regular field (non-navigation property)
- The OData Query will fail and return with [COE0003]Bad property expression: cannot expand non-navigation property error
Cause
The error is returned when the OData API detects the use of a non‑navigation property in an $expand or cross‑entity join. The issue occurs when the query attempts to expand or reference a property that is not defined as a navigation property in the metadata.
Resolution
Remove the field - that is a non-navigation property, and also mentioned in the error <Field> from the $expand clause.
Check available properties and navigation properties in the Reference Guide or in OData API Data Dictionary.
See Also
Keywords
400-COE_BAD_PROPERTY_EXPRESSION, Bad Request-[COE0003]Bad property expression : cannot expand non-navigation property, OData API, expand , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , Integrations , Problem
SAP Knowledge Base Article - Public