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


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.


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>

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."



SAP Successfactors HXM Suite

SAP SuccessFactors Employee Central

  •  Employee Central Compound Employee API


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


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 for Me (Login required).

Search for additional results

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