Forum Discussion
jrobertosm
5 years agoFrequent Visitor
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...
- 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/;
mahoneypat
5 years agoMicrosoft Employee
- jrobertosm5 years agoFrequent Visitor
Thank`s man.