SAP Knowledge Base Article - Preview

2554717 - Unexpected results when using Modified Since combined with Effective From/To filters - OData API and Integration Center

Symptom

An Integration Center job starting with an effective-dated entity (e.g. EmpJob) and combining Modified Since and Effective From/To filters is returning unexpected results.

This behavior comes from the OData API engine, as Integration Center is based on it, so when using OData API directly, the behavior is the same.

  

Equivalence between Integration Center and OData parameters:

  • Modified Since (IC) = lastModifiedDateTime (OData)
  • Effective From/To (IC) = fromDate/toDate (OData)


Read more...

Environment

SAP SuccessFactors HCM Suite

Product

SAP SuccessFactors HCM Suite all versions

Keywords

effective, from, to, lastModifiedDateTime, datetimeoffset, Modified Since, Last modified Date, Time based filters, entities, like, time-based, delta logic, dynamic value If you want the integration to return only the entity records (current and/or historical) that were indeed modified since the last integration run, know that this logic cannot be fully achieved within Integration Center alone, so the options are: , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT-ODATA , OData API Framework , Problem

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.