2468967 - Mismatch in startDate field value while insertin/gupserting it and reading it via Odata API

SAP Knowledge Base Article - Public

2468967 - Mismatch in startDate field value while insertin/gupserting it and reading it via Odata API

Symptom

Odata API entities are returning different value(diference can be observed in the time part) for the 'startDate' field when retrieving it from EmpJob,PerPerson or EmpEmployment entity compared to the value inserted for this field.

For example:

  • API request written to upsert the Start date:

 API1.PNG

  • API response when trying to read the data from either of those entities:

 API2.PNG 

Environment

Successfactors

Reproducing the Issue

  • API request written to upsert the Start date:

 

API1.PNG

  • API response when trying to read the data for during Onboarding:

 

API2.PNG

 

Resolution

  • This is an expected behavior of Odata API.
  • For "starDate", only the date is stored and not the time.
  • In this example the writting time stamp is 1493184507000 which is equal to 2017-04-26 05:28:27. Whereas, the query time stamp is 1493164800000 i.e., 2017-04-26 00:00:00.

 

 

Keywords

  • 'startDate' field is not returning correct value
  • Mismatch in the 'startDate' field value returned by the Odata API v/s what was inserted
, KBA , LOD-SF-INT-API , SF API & Adhoc API Framework , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , Problem

Product

SAP SuccessFactors HCM Suite all versions