SAP Knowledge Base Article - Public

2584770 - [COE0003]Bad property expression: cannot expand non-navigation property

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

  1. Perform an OData API Query on an entity expanding to a regular field (non-navigation property)
  2. 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

$expand | SAP SuccessFactors API Reference Guide (OData V2) | SAP Help Portal

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

Product

SAP SuccessFactors HCM Core all versions