External APIs: Paging

Michael Udinski

Sometimes when fetching data from an external API, you may encounter some that returns the data in pages or sections. Check out this tutorial that shows how you can leverage the While Loop to get all the data - or a specified amount of data - across multiple pages.

https://youtu.be/9e2RKerHvBw

Junior Vidotti

Hi ! Great tutorial, but how I do paging while GET'ting a list from Xano backend? There's docs about that?

Michael Udinski

Query All Records > Output > Return > Paging

https://docs.xano.com/working-with-data/functions/database-requests/query-all-records/output-tab#return

David Richardson

Does paging work when you are getting records in a "random" order?  Is it random every time you use the API or is ONE list created (in random order) and the records served from the one random list?

Michael Udinski

 Yes paging still works on random orders. And I'm not sure, that would probably depend on the 3rd party API service you are using and how they set it up... I'm assuming each time you ran the API it would be a new random order. For example, that's how a random order in Xano's query all records would function

David Richardson

Thanks Michael.  It seems somewhat serendipitous, but in a table with 1000(s) records that I'd want to pull 30 at a time, making an  another request might be just as effective a paging (!?) the results.