Fetching Latest 2 records from Lookback API

Question

We are in situation where We Need to fetch last two records from Lookback API every time .

For the below case, we need the records highlighted in green,

We are doing the incremental fetch using the _ValidFrom Date in Lookback API. We need last two records so that we can handle the updates happening to _ValidTo whenever new snapshot is created.

Answer 1

You should be able to get that data from just the most recent snapshot can't you? The _ValidFrom of the most recent should be equal to the _ValidTo of the second to last one.