How to load several pages of web-API

[SaifAmer]

Hi,

I have some issues with loading several pages of a web-API and was hoping for some input. The API for my e-commerce store and it is limited to 100 rows per page. I have a meta column that specify how many pages there are, see below. 

Is there a neat way that I can load all 19 pages with manullay entering each query. Would it also to be possible to use the meta.last.page as reference as it will most likely be updated as I am adding new products to my e-commerce store. 

Thanks in advance.

Best Regards,

Saif

[amitchandak · Accepted solution]

@SaifAmer , refer if this can help

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

https://datachant.com/2016/06/27/cursor-based-pagination-power-query/