Forum Discussion

BRVL's avatar
BRVL
Frequent Visitor
3 years ago
Solved

Web based cursor pagination issue

Hi I’ve been working on trying to use List.generate to create a paginated list from the api. My issue is that my api uses Cursor-Based Pagination. A single request will give me two sections if a curs...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi BRVL ,

    Have you tried to use if function like this:

    each if Record.HasFields(_,"cursor"）=true then Json.Document(... else...

    Best Regards,
    Community Support Team _ kalyj

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

  • BRVL's avatar
    BRVL
    3 years ago

    Nevermind, I've figured it myself.

BRVL's avatar
BRVL
Frequent Visitor
3 years ago

Nevermind, I've figured it myself.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi,

 

Would you mind sharing how you resolved the issue as I am struggling with a similar problem.

 

Thanks,

 

Amreet

  • BRVL's avatar
    BRVL
    Frequent Visitor
    3 years ago

    I used the below and it solved it for me: 

     

    data = let
    Pagination = List.Generate( ()=> Source,
    each [payments] <> null ,
    each if Record.HasFields(_,"cursor") and [cursor] <>null then Json.Document(Web.Contents("https://connect.squareup.com/v2/payments?cursor=" & Text.From([cursor]), [Headers=[Authorization="Token"]] )) else Record.FromList({null, null}, {"payments","cursor"} ))


    in Pagination,
    #"Converted to Table1" = Table.FromList(data, Splitter.SplitByNothing(), null, null, ExtraValues.Ignore)

    • jrush4's avatar
      jrush4
      Frequent Visitor
      1 year ago

      Any chance you could give a little more context on how you got this working? I'm currently trying to do something similar with pagination, but can't crack it. Your above code has gotten me closer, but I'm still not there!