2531677 - How to view past and future dated records of an MDF Entity in Integration Center

SAP Knowledge Base Article - Public

2531677 - How to view past and future dated records of an MDF Entity in Integration Center

Symptom

The Purpose of this KBA is to show how historical data can be returned in Integration Center.

Environment

  • Integration Center
  • Successfactors

Cause

When performing an API call or building a report in Integration Center, by default it returns the 'asOfDate' records which means it will only return the current record for that object.

Resolution

To achieve this we need to make use of the Time Based Filters and use the "Effective From" and "Effective To" Options in our Integration Center Interface and follow below steps.

1. Navigate to the 'Filter and Sort' page

2. Add a date to the "Effective From" field which is a date in the past of the first record you want to retrieve.

3.Set the "Effective To" field value to "Now" or the date until which you want to retrieve the records. (This can also be used to retrieve future records)

TimeBased filters.PNG

Keywords

Time Based Filters, Historical records, Integration Center, Future dated records , KBA , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , LOD-SF-INT-INC , Integration Center , Problem

Product

SAP SuccessFactors HCM Core 1705