Issue - API calls with pagination

[LP2803]

Hi Team,

I have created the below function in powerquery to fetch the data from an API

name of fx = getpage1

(page as text) =>
let
Source = Json.Document(Web.Contents("https://api.onguard.convergeone.com:8080/cc2076video/videoCDR/_search?q=@timestamp%3A[2019-01-01T00:...

and created a Query as below :  (this creates a list from 1 to 20 and these numbers are used a page ...

let

Source = List.Generate(()=>1, each _ <20, each _ +1),
#"Converted to Table" = Table.FromList(Source, ...

Issue :

I see that the same ID is queried multiple times as shown below: 

Kindly help why is this fetching the same records instead of different ones. Am i missing anything here?

[amitchandak]

@LP2803 , Not very clear to me.

Refer , if these two can help

https://datachant.com/2016/06/27/cursor-based-pagination-power-query/

https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78