PO 7.5:How to define Resource path query to extract delta records using Odata Sender Adapter

[former_member10122]

Hi Team,

I am working on a interface to extract records from Odata service. I am able to make successful connection and extract data based on different query statements. But the challenge I have is, I am interested in only extracting delta records as shown in below example.

In the source schema TD_REG_WELL_RESULT there is a field "MODIFIED_AT"

Eg: If I have 5 records which has MODIFIED_AT = 2022-04-20T05:11:35.000GMT, My next execution should check for this last run time minus 1 hour to pull the records.. i.e., 2022-04-20T04:11:35.000GMT

can this be achieved using QUERY option in the Odata Sender adapter ?

if so how Resource path should be defined as ?

I am working on PO 7.5 SPS 22 with Odata V2 deployed using CONNECTIVITY ADD ON 2.0

Or

Is there a way I can store the last timestamp somewhere in SAP PO so that it helps to query for next execution ?

Thanks,

Varun