SAP Knowledge Base Article - Public

2559661 - How to query deleted records using SFAPI


  •  User has a requirement to retrieve deleted records in a given time frame
  •  User is using the Compound Employee API


Compound Employee API

Reproducing the Issue

Customer has a requirement to return deleted record using SFAPI but cannot see the deleted records in the response


Deleted data is not returned in an API call by default


Deleted records from SAP can be retrieved by using SF API CompoundEmployee in Delta mode.

In order to extract deleted data, in the CompoundEmployee API query, one needs to use queryMode= Delta along with other parameters like “last_modified_on“, “fromDate” and “toDate” as shown in the screenshot below. Please note this will not return deleted records per se, but only the delta result considering those deleted records.


Removing toDate and fromDate from a query transforms a period-based delta query into an effective-dated delta query. To learn more about the differences between the two, please check:



Deleted records, SFAPI, Compound Employee, Delta Transmission , KBA , LOD-SF-INT-API , API & Adhoc API Framework , Problem


SAP SuccessFactors HXM Core all versions