SAP Knowledge Base Article - Public

2946940 - The field "last_modified_on" is not being return for DELETE action - Compound Employee API

Symptom

You make a Compound Employee query using the parameters queryMode=Delta and resultOptions=renderPreviousTags, and you noticed that on action=DELETE segments, there is no <last_modified_on> field:

<email_information>
<action>DELETE</action>
<created_by>admin</created_by>
<created_on_timestamp>2020-07-10T20:33:15.000Z</created_on_timestamp>
<email_address>test@example.com</email_address>
<email_type>P</email_type>
<isPrimary>false</isPrimary>
</email_information>

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

Environment

  • SAP SuccessFactors HXM Suite
    • Compound Employee API

Resolution

The action=DELETE segments don't have "last_modified_on" field, and this is the expected behavior.

On Compound Employee Guide, you'll be able to see the following statement on section "3.2.3.1 Select Parameters for the WHERE Clause":

Deletion of records is considered in queries for last modified employees. These deleted records aren’t returned by the API. For example: WHERE last_modified_on > to_datetime('2012-11-06T23:30:00Z') WHERE last_modified_on > to_date('01/07/10', 'DD/MM/YY')>

See Also

Compound Employee Guide

Compound Employee Guide in Delta Transmission Mode

Keywords

ce api, compoundemployee, sf, successfactors, success factors, last modified on, portlet, segment, object,  , KBA , LOD-SF-INT-CE , Compound Employee API , How To

Product

SAP SuccessFactors HXM Core 2005