Using a Loop to Get All Paginated Results in a Non-ODATA Rest API

[glove80]

I am a newbie in the API space, and I am trying to pull all the paginated data from UserVoice.  They have a limit of 100 results per page, and I can't use the ?limit syntax to increase the limit.  I am trying to do a loop in PowerQuery but seem to keep getting the same list over and over again.  Here is the query I have so far:

let

url = "https://SUBSITE.userrvoice.com/",

Header=[Authorization="Bearer TOKEN"],

RelativePathing = "api/v2/admin/suggestions",

Source1 = Json.Document(Web.Contents(url, [RelativePath=RelativePathing, Headers=Header])),

iterations = Source1[pagination][total_pages],

FullURL = url & RelativePathing,

FnGetOnePage =

(FullURL) as record =>

let

Source2 = Json.Document(Web.Contents(url, [RelativePath=RelativePathing, Headers=Header])),

data = try Source2[suggestions] otherwise null,

next = try Source2[pagination][cursor] otherwise null,

res = [Data=data, Next=FullURL & "?cursor=" & next]

in

res,

GeneratedList =

List.Generate(

()=>[i=0, res = FnGetOnePage(FullURL)],

each [i]<iterations and [res][Data]<>null,

each [i=[i]+1, res = FnGetOnePage([res][Next])],

each [res][Data])

in

   GeneratedList

[v-chuncz-msft · Accepted solution]

@glove80 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Stopping-when-looping-through-a-paginated-API-feed/m-p/3103...