Skip to Content
Jan 22, 2021 at 04:29 PM

SuccessFactor delta query returning records with startDate in the future

64 Views Last edit Jan 22, 2021 at 04:32 PM 4 rev

Hello, I am developing an integration based on EmpJob using HTTP OData query, I need to select only modified, created and the ones that became "current" because of statDate records between now and the last run.

But when a record is modified between the delta time but with a startDate in the future it appears in the query result.
This is an example with the critical part of the filter:

(employmentNav/personNav/personalInfoNav/lastModifiedDateTime ge datetimeoffset'2021-01-22T11:22:53Z' ) and (employmentNav/personNav/personalInfoNav/startDate le datetime'2021-01-22T11:22:53Z')

I changed some Personal Info on 2021-01-22T14:00:00Z but with a future date, the asOfDate is set at 2021-01-22.

I did not expect the modified record to show in the result but it appears, with this data:

<d:startDate m:type="Edm.DateTime">2020-12-01T00:00:00</d:startDate>

<d:lastModifiedDateTime m:type="Edm.DateTimeOffset">2020-12-03T15:58:03Z</d:lastModifiedDateTime>

<d:lastModifiedOn m:type="Edm.DateTime">2020-12-03T16:58:03</d:lastModifiedOn>

This is really strange, a record with this data should not match the filter but it does.

So I can't understand how to not make appear in the delta query that record, that is unchanged until startDate comes.