Getting data from paginated API

[Rocky_Road]

Im fairly new in Power bi. I worked through lot of different sugestions how to et data in from painated api, but i still can't figure it out what is the problem.

Here is code to get next page.

let
    Source = Json.Document(Web.Contents("https://xxxxxxxxxxxx?page[size]=2000&page[number]=1", [Headers=[Authorization="Bearer "&Gettoken()]])),
    links = Source[links],
    next = links[next]
in
    next

Here is code to get data from 10 pages. 

let
iterations = 10, // Number of iterations
url = "https://xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
FnGetOnePage =
(url) as record =>
let
Source = Json.Document(Web.Contents(url),[Headers=[Authorization="Bearer "&Gettoken()]]),
data = try Source[data] otherwise null,
next = try Source[links] [next] otherwise null,
res = [Data=data, Next=next]
in
res,

GeneratedList =
List.Generate(
()=>[i=0, res = FnGetOnePage(url)],
each [i]<iterations and [res][Data]<>null,
each [i=[i]+1, res = FnGetOnePage([res][Next])],
each [res][Data])
in
GeneratedList

Can someone point me into right direction. Thank you for advance 🙂

[Rocky_Road · Accepted solution]

Hello again, 

I found working logic from here: https://stackoverflow.com/questions/73832274/power-query-pagination