List.Generate function returning the same value while calling a rest API which supports cursor

[kunal1120]

Hi, I am trying to get data from a rest API which sends the cusor information for the next page. I am geeting the same cursor back as It keeps on triggering the initial condition in List. Gernate

My code 

let
    FnGetOnePage =  (cursor_ as text) => Json.Document(Web.Contents(URLEndPoint,[
            Headers = [#"Content-Type"="application/json", #"Authorization"=token],
            Content = Text.ToBinary("{""kind"": """ & kind & """,""limit"": """ & Number.ToText(100) & """, ""cursor"": """ & cursor_ & """}")
            ]))

GeneratedList = List.Generate(
                       ()=> [res = FnGetOnePage("")],
                           each [res][cursor]<>null,
                           each [res = FnGetOnePage([res][cursor])]                                                              
                       ) 
in 
      x

[Anonymous]

Hi @kunal1120 ,

You may kindly refer to

Part 2: Programming "Do-Loop" loops with List-Generate() in M for Power Query - data-insights.de: Mi...

List.Generate in Power Query: Tutorial with Easy Examples

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.