SAP Knowledge Base Article - Preview

3084336 - CompoundEmployee API Snapshot Mode Behavior and What to parameter use to extract only the time slices valid on a given date for Effective Dated Information

Symptom

When you execute a query using queryMode=snapshot to retrieve only the current record for the given snapshot_date value, but the response returns 

Complete picture of all the Employee's data as it was on the snapshot date including all changes, corrections, and deletions.


e.g. 

Query : where snapshot_date = to_datetime('2021-07-28T00:00:00')

<queryString>SELECT person, personal_information, employment_information, job_information FROM CompoundEmployee WHERE  snapshot_date = to_datetime('YYYY-mm-DDTHH:MM:SSZ') AND person_id_external = (*)</queryString>
<urn:param>
     <urn:name>queryMode</urn:name>
     <urn:value>snapshot</urn:value>
</urn:param>


Response : 

You receive in the response historic records for in job_information as example even if the lastmodifiedOn value for these records are before the snapshot_date = to_datetime value in your query


- Query above is using queryMode=snapshot with value snapshot_date = to_datetime('2021-07-28T00:00:00Z'), however records returned are those whose lastModifiedOn is before the snapshot_date value. 


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


Read more...

Environment

SAP Successfactors HXM Suite

SAP SuccessFactors Employee Central

  •  Employee Central Compound Employee API

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HXM Suite all versions

Keywords

queryMode=snapshot, snapshost_date=to_datetime, effective_end_date, compoundEmployee API, effective-dated information for compoundEmployee API, effective_end_date filter , KBA , LOD-SF-INT-CE , Compound Employee API , LOD-SF-INT , Integrations , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.