Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 

 

  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.