Symptom
Odata API error 400 Not able to query JobRequisition or other entity 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: [fieldID]; cannot expand non-navigation property: JobRequisition/costCenterId"
Environment
- SAP SuccessFactors HXM Suite
- SAP SuccessFactors Recruiting Management
Cause
- Expand clause contains string field: 'JobRequisition/costCenterId'
- Field ID is of type string, Field of type String cannot be expanded.
Resolution
Remove the field from the $expand clause, in which the type is String, and the job should run correctly.
See Also
Refer to SAP SuccessFactors HXM Suite OData API: Reference Guide (V2) for guidelines on and usage of Odata APIs e.g. $expand.
Keywords
400-COE_BAD_PROPERTY_EXPRESSION, Bad Request-[COE0003]Bad property expression : cannot expand non-navigation property, Odata API, JobRequisition/costCenterId, expand clause, 'costCenterId' of type string , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , Integrations , Problem