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 ,

yes, definitely making progress here.

Please check format of paste picture of myList{0}.

If it is a record, then the following code might work:

 

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][link], 1)[#"Attribute:href"]), Counter = [Counter]+1],
    each [Result])
in
    myList

 

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi ImkeF ,

 

The data in myList{0} looks like this:

 

Forgive my ignorance as I'm a bit new to Power Query data structures.  Is the structure essentially a table with two rows (records) in it and the Table column then holding a Table data structure within it?

 

I tried  the ammended code which still errored but gave this message :