Effective as of date filter returning multiple records in integration center outside of specified range.
Reproducing the Issue
- Set effective as Of date filter
- In preview screen we see that multiple records are returned out of filter criteria
This is expected behaviour.
The "asOfDate" parameters returns all the records including historical but not future dated information.
This requirement can be met by using the filter parameters "lastModifiedOn ge" followed by a specific date.
This would be a static date and wouldn't be applicable if data changes are made on different dates.
KBA , LOD-SF-INT , SF Integrations - EC Payroll, Boomi/ HCI, API , LOD-SF-INT-INC , Integration Center , Problem