2554717 - Unexpected results when using time-based filters in effective-dated entities - OData API and Integration Center

You are trying to create a query in one Effective dated entity (in this example we are using EmpJob entity) and the time-based filter is not working as expected and returning inaccurate records. Specifically, the 'Modified Since' filter is not giving your desired results.

• When you use the 'Modified Since' filter in combination with the 'Effective From/To' filter to include all records, you do not get the desired results. This grabs ALL records of a given employee where at least one record has been modified since last run time, and thus does not limit it to only the record(s) recently modified.

• If you remove the 'Effective From/To' filter, this grabs the current record only (even if historical records are recently modified [they fall out of the results], and even if the current record was not recently modified).  

Your desired results is to get all Job Info records (current and/or historical) that have been last modified since the last time the integration ran.

You have not been able to configure the integration filters to accomplish this requirement.

NOTE: The information and behaviors described in this KBA apply for both Integration Center and OData API, (as Integration Center is based on OData API). The terms can be mapped from the context of Integration Center to the context of direct OData API queries as follows:

• 'Effective from' and 'Effective to' filter -> 'fromDate' and 'toDate' parameters
• 'Modified since' filter -> lastModifiedDateTime ge datetimeoffset'yyyy-MM-dd'

• SAP SuccessFactors HXM Suite
• Integration Center
• OData API

effective, from, to, lastModifiedDateTime, datetimeoffset, Modified Since, Last modified Date, Time based filters, entities, like, time-based , KBA , LOD-SF-INT-INC , Integration Center , LOD-SF-INT , Integrations , LOD-SF-INT-ODATA , OData API Framework , Problem