SAP Knowledge Base Article - Public

2298289 - How to change the effective start date of a record using Odata API Upsert operation


Requiremnet is to update the Global Assignment Startdate via the Odata API before the approval of global assignment workflow. So basically-

  • Is there a way to access the un-approved future dated data row via Odata API ?
  • Is it possible to update the effective start date of an existing record using Odata API?

Currently it is possible via UI, however when we try to do this using ODATA API system is creating another row rather than updating the previous one.

Reproducing the Issue

Updating the start date of the approved Global Assignment: This can be achieved via UI ( SF Application), by the following navigation.

- Login As admin

- Select user , go to the employment information

- Select the future assignment

- Click on History in the Job Information and go to 'Make Correction' to update the start date. This will automatically update the GA start date.


There is no direct way to change the effective start date of a record through API or imports as effective start date is part of business key for the record to figure out if it is update or insert.

There are 2 workarounds though to achieve the same:

  • Import the new data in full purgeType parameter as FULL. Syntax should be as shown below:


  • Delete the old record and create new record. There is an operation column in job info import file which takes DELETE as a value. So you can have 2 records in the API or import file, one record has only the user-id, start-date, sequence-number and DELETE operation whereas the second record has all the values with new start-date.


KBA , LOD-SF-INT-API , API & Adhoc API Framework , LOD-SF-INT , Integrations , How To


SAP SuccessFactors HXM Suite all versions