Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

List. Generate not working for Rest API pagination

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.

1 Reply