Forum Discussion
Anonymous
2 years agoNot applicable
Issue with checking the status in Get and Post request from Tenable.io
Hi All,
I have to do the below steps in Power Query
- Issue a POST to the Tenable API to create an export . Export data contains UUID, status, number of pages ( called chunks ) etc.
- Wait for the status for the latest UUID to change from "PROCESSING" to "FINISHED".
- 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.
1 Reply
- amustafaSolution Sage
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