List. Generate not working for Rest API pagination

[Anonymous]

Hi, Everyone I hope you all are fine.
API URL: https://vcc-na8.8x8.com/api/stats/agents/{Aent-ID}/activities?n=(offset)
Background: Reference to the URL above I am trying to extract data from this API which allows me to add the Agent-ID and provide only 50 rows per request.

I have created this function below which is working perfectly fine and allows me to extract all the id's by using invoke function against those id's in new table, PFB,

But when I use it in List. Generate function in order to do the pagination of these id's it shows the empty list, PFB

I also created this function below in order to extract all the id's and rows at the same time but it provide infinite loop of tables.

Any Power query expert who can loo into it solve my problem.
Thanks in advance.

[Anonymous · Accepted solution]

Hi @Anonymous ,

You may kindly refer to:Iterate over dynamic Web API Pages with Power Query - How to resolve Cursor-Based Pagination - DataChant  to learn how to implement Cursor-Based Pagination using List.Generate to extract large data sets from Web APIs.  

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