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
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

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi ImkeF ,

 

I think that day has arrived!  We have success!!! 

 

I now get a result set of Tables as expected:

 

Can I ask one more question please? Ultimatley I need to replace the Counter variable with a test for whether a link row is returned (the last paginated dataset won't have a link row).  How would it be best to do that?

 

Many many thanks for all your help with this 😁