API Loop with nextlink

[lipster26]

Hello,

I'm looking to pull data from an API that returns 100 entries at a time. At the end of the JSON it provides a link to the next 100 entries. How do i write a loop to use the @NextLink to pull the next set of entries until there are no entries left?

Thanks for any help.

[v-henryk-mstf]

Hi @lipster26 ,

Is it helpful to refer to a similar solution?

Solved: PowerBI API call with loop - Microsoft Power BI Community

powerbi - Power BI Iterative API Loop - Stack Overflow

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[amitchandak]

@lipster26 , refer if these can help

https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78