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.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
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
    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)

  • BRVL's avatar
    BRVL
    Frequent Visitor
    3 years ago

    Hi thanks for your reply but this does not change the result.