Forum Discussion

gustavofiretti's avatar
gustavofiretti
Frequent Visitor
4 years ago

API Pagination Cursor

Hello,   I'm trying to retrave data use an API, and i tested it in PostMan and it gaves me a json file. The API has a limit of 25 lines per page, and in the json i can see the link to the next pag...
Need Help
otravers's avatar
otravers
Community Champion
4 years ago

To solve an unfamiliar problem, try breaking it down into the smallest possible challenge. Right now you don't know how to handle pagination, so focus on solving that by getting everything else out of the way.

 

Create a copy of your query, remove everything but the source, turn that query into a function, and try adding pagination as explained in the links Amit gave you. Once you have pagination working, you can add back all the post-API processing from your initial query.

gustavofiretti's avatar
gustavofiretti
Frequent Visitor
4 years ago

Hello otravers .

 

I tried to do this, i deleted all of the unecessary code and now i got this:

 

let

    Token = "XXX",
    iterations = 2,
    url = "https://api.deskbee.io/v1.1/bookings?",
    Source = Json.Document(Web.Contents(url,
    [Headers=[Authorization=Token]])),

    FnGetOnePage =
  (url) as record =>
   let
    data = try Source[data] otherwise null,
    next = try Source[links][next] otherwise null,
    res = [Data=data, Next=next]
   in
    res,
 
 GeneratedList =
  List.Generate(
   ()=>[i=0, res = FnGetOnePage(url)],
   each [i]<iterations and [res][Data]<>null,
   each [i=[i]+1, res = FnGetOnePage([res][Next])],
   each [res][Data])
in
    GeneratedList

 

But now i got the same data from page 1 twice (number os iterations) i'm not getting the new page's data yet.

 

I'm not a dev, so I'm basicly trying to replace the code and adapting it to my case.