Symptom
You are trying to get data from SuccessFactors using Integration Center and it's not returning future or historical records in the output, only the recent time slice is being returned.
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
- Integration Center
Reproducing the Issue
- Go to Admin Center > Integration Center
- Create a simple CSV outbound integration
- Choose an effective-dated (like EmpJob, for example) as the base entity and select the fields needed
- Now click on Configure Fields tab and notice that only the latest time slice record is shown
Cause
OData queries by default fetch current effective records (asOfDate parameter equals today's date), hence we need to apply fromDate and toDate filters to fetch historical/future data. Since Integration Center runs on OData, the same behavior applies to it too.
Resolution
- Go to "Filter and Sort" tab
- Under "Time-Based Filters", you'll be able to see the "Effective From" and "Effective To" filters.
- Choose the values for "Effective From" and "Effective To" according to your requirement by clicking in the pencil icon next to it.
For example: if we want to fetch the complete information pertaining to an employee from 2001-05-10 until today, we can set the "Effective From" to that value: - Now all the historical data for that employee will be properly shown according to the period set on "Effective From" and "Effective To" filters
Note: the filters available under Time-Based Filters section (including the "Modified Since Query Mode" filter) will only work on effective dated entities. If you configure these filters and your integration is selecting only fields from non-effective dated entities, they will be ignored.
See Also
Keywords
Future dated records, Historical records, Inactive users, Integration center, effective dated, effective-dated, historical, past, future, inactive, time based filter, filters, time-based, successfactors, ic, integration center, configure fields, preview, latest, recent, active, , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , LOD-SF-INT-ODATA , OData API Framework , LOD-SF-INT-API , API & Adhoc API Framework , Problem