I need to keep running an API call (get request) where I am using web.contents function until the status for the request changes from "null" to "finished", once in finished state I can then retrieve the data.
Any ideas how to construct this loop in Power Query?