Delay web query until condition met from another web query

Hi Anonymous,

I've prepared a template which you can use for solving your problem.

You have to add your logic for processing JSON responses and modify the WaitForList according your needs.

let
    // request data
    RequestDataRecord = fnProcessJson(Web.Contents("request data URL")),

    // wait 10x for 5 seconds
    WaitForList = List.Repeat({5}, 10),
    // wait until the response is COMPLETE, but max 50 secs
    WaitForStatus = List.MatchesAny(
            WaitForList,
            each 
                Function.InvokeAfter(
                    () => fnProcessJson(Web.Contents("http://StatusCheckURL")), 
                    #duration(0,0,0,_)
                ) = "COMPLETE"
            ),
    
    // download file if WaitForStatus was successful        
    DownloadFile =
        if WaitForStatus then
            fnProcessJson(Web.Contents("download data URL"))
        else
            null
in
    DownloadFile