How to loop through API until status changes with Web.contents

[acoyne]

Hi,

I need to keep running an api using web.contents until its status goes from null to finished.

Any ideas how to construct this loop in query editor?

I did use the InvokeAfter function to delay the api calll, which works but depending on what you are requesting the time taken varies which doesn't optimise the overall query.

Thanks

Alan

[lbendlin]

Handling paging for Power Query connectors - Power Query | Microsoft Learn