Issue with checking the status in Get and Post request from Tenable.io

[Anonymous]

Hi All,

I have to do the below steps in Power Query 

1. Issue a POST to the Tenable API to create an export . Export data contains UUID, status, number of pages ( called chunks ) etc.
2. Wait for the status for the latest UUID to change from "PROCESSING" to "FINISHED".
3. Get this UUID all pages ( chunks ) data in Power BI.

I am able to achieve 1st and 3rd point. However when I refresh my power query the status is always PROCESSING. is there any way where I can go back and check the status and wait until it is finished?  I can not provide a time duration using Function.InvokeAfter as the time period of completion is not fixed.

Is waiting for external events like API responses to change which means a recursive function to check the status of UUID to get “FINISHED” is possible in Power query?

Please share your expertise.

[amustafa]

Perhaps a Power Query function InvokeAfter might work for you. See two links:

Solved: Delay web query until condition met from another w... - Microsoft Fabric Community

Delay API Requests in Power Query (youtube.com)