Forum Discussion

jrobertosm's avatar
jrobertosm
Frequent Visitor
5 years ago
Solved

Extract data from an API paginated??

I need to extract data from an API paginated. The item limit per page is 50. There are 15,000 items to be extracted. I can connect with the API and retrieve the first 50 items. How can I recursiv...
Need Help
jrobertosm's avatar
jrobertosm
Frequent Visitor
5 years ago

Hi;

Grateful for the help.

I solved the situation using:

- Authentication in API Auth, and;

- Function List.Generate;

 

The videos and content from the links below helped a lot:

- https://www.youtube.com/watch?v=Xhr864DlfNE;
- https://www.youtube.com/watch?v=yc78DZnGhbQ;

- https://www.youtube.com/watch?v=mXbjoSg9ldo;

- https://www.youtube.com/watch?v=hHkU8tPhVXs&t=492s;

-http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/;