Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Cursor Paginated data from Web API

Hi,   I am calling a web api to grab some data which is paginated and I am struggling with how to get the next page of data as it is cursor based.   When I call the api in PowerQuery (I'm connect...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi ImkeF ,

 

Ah I see!  I didn't realise that you could nest references in that way!

 

So, a little more progress I think, still erroring but with this message from row 2 onwards:

ImkeF's avatar
ImkeF
Community Champion
6 years ago

Hi Anonymous ,

one day, we'll get there 😉

let
myList = List.Generate( ()=>
    [Result = Query4("https://api.brighttalk.com/v1/channel/10737/webcasts"), Counter = 0],
    each  [Counter] < 5,
    each [Result =  Query4(Table.LastN([Result]{[Name = "link"]}[Table], 1){0}[#"Attribute:href"]), Counter = [Counter]+1],
    each [Result])
in
    myList