3361805 - ODATA API: Background entity - Partial upsert results in null fields

While attempting to upsert an existing record in a Background entity - You only enter the values for the fields you wish to change. 

• But this results in the rest of the fields becoming null. 

  

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

SAP SuccessFactors HXM Suite

• OData API

   

1) GET: https://apisalesdemo2.successfactors.eu/odata/v2/Background_OutsideWorkExperience?$filter=userId eq 'XXXX'&$format=json

employerEmail: null 

 

2) POST: https://apisalesdemo2.successfactors.eu/odata/v2/upsert?

{

    "__metadata": {

        "uri": "Background_OutsideWorkExperience"

    },

    "backgroundElementId": "56403",

    "userId": "XXX",

    "employerCountry": "5587",

    "employerAddress": "東京都墨田区5-5-5",

    "endDate": "/Date(1301529600000)/",

    "employerZip": "1310000",

    "employerState": null,

    "employerCity": null,

    "startTitle": "製造管理部長",

    "employerEmail": "TEST_BG_OVERWRITE",

    "bgOrderPos": "1",

    "employer": "ベストエンジニアリング株式会社",

    "businessType": "9727",

    "employerContact": null,

    "employerPhone": "+00001234",

    "startDate": "/Date(1112313600000)/",

    "presentEmployer": "5459"

}

 

3) Re-run the GET to confirm it's populated

 

4) The re-run same POST request without employerEmail in the payload

 

5) Run the GET again & you will see employerEmail is set to null

  

The system updates all fields for an existing background record, and it considers the non specified fields to be null on purpose.

  

If you wish to keep the original values for these fields, you need to specify the fields as their original value.

   

, KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , Integrations , How To

SAP SuccessFactors HXM Suite all versions