SAP Knowledge Base Article - Public

2559661 - How to query deleted records using SFAPI

Symptom

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

Environment

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

Cause

Deleted data is not returned in an API call by default

Resolution

Deleted records from SAP can be retrieved by using SF API CompoundEmployee in Delta mode.Check SAP Help to know more about Compound Employee API – Delta Transmission.

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 below:

soapui1-1.png

Keywords

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

Product

SAP SuccessFactors HCM Core all versions