SAP Knowledge Base Article - Public

2913879 - Invalid Property issue while null value is passed for a null-able filed - Background (EP) ODATA API

Symptom

If you try to UPSERT a null-able field with null value (without quotes) of a Background ODATA API, it gives below error:

The given value null for property XXXXX is invalid. Valid values are:[]. Please check the property in Admin Center > OData API Data Dictionary. with the index 0

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

Environment

  • SAP SuccessFactors HXM Suite ODATA API
  • SAP SuccessFactors Employee Profile

Reproducing the Issue

Consider one Background ODATA API such as Background_InsideWorkExperience. Now run UPSERT on the same API.

API Entity: Background_InsideWorkExperience

Request: POST

https://apisalesdemo4.successfactors.com/odata/v2/upsert

 

Body:

[

{

"__metadata":{"uri":"Background_InsideWorkExperience"},

"backgroundElementId" :123456,

"userId" :"XYZ",

"affiliation":"ABC",

"jobTitle":null, ­­

"startDate": "/Date(735846400000)/"

}

]

 

RESPONSE:

 

<d:status>ERROR</d:status>

The given value null for property jobTitle is invalid. Valid values are:[]. Please check the property in Admin Center &gt; OData API Data Dictionary. with the index 0

 

Cause

As per the Module design, it was showing expected behaviour. But for b1911 Release, this issue was fixed/design was changed via one Patch (b1911p16, 28th Feb, 2020). Permanent fix has been given with b2005 Release.

Resolution

For b1911 Release, this issue was fixed/design was changed via one Patch (b1911p16, 28th Feb). Permanent fix has been given with b2005 Release. If you still get the same issue, please create a support ticket via Launchpad under LOD-SF-INT Component.

Keywords

Valid values are:[], invalid property, Background API, Employee Profile, ODATA , KBA , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT , Integrations , LOD-SF-INT-ODATA , OData API Framework , Problem

Product

SAP SuccessFactors HXM Suite all versions