Forum Discussion

Bessonnizza's avatar
Bessonnizza
Icon for Helper II rankHelper II
6 years ago
Solved

Web.Contents - Timeout=#duration

Hi all!   Have POST request: let data = Json.FromValue([StatisticsSessionId=paramStatisticsSessionId]), headers = [#"accept"="*/*", #"ScoutAuthorization"=paramAuthorizationId, #"C...
Need Help
  • Bessonnizza's avatar
    Bessonnizza
    6 years ago

    Solution:

     

    GetStatistics = Table.AddColumn(StartBuild, "GetStatistics", each Function.InvokeAfter(()=>fnTrackPeriodsMileage_GetStatistics([SessionId], [StatisticsSessionId]), #duration(0,0,0,15))),
Bessonnizza's avatar
Bessonnizza
Icon for Helper II rankHelper II
6 years ago

amitchandak thx for reply, but i think you not understand me. I need not to replace "Processing" to "Ok", query should wait answer "Ok" (for example wait 1 min) in colomn Value.1, and then execute.

 

Now the request is being executed when get first answer, it can be "Ok" (data download), or it can be "Processing" (data is loaded). So i need to wait when query return me definite answer - "Ok" and only then download another colums with data (as shown in the screenshot above).

Bessonnizza's avatar
Bessonnizza
Icon for Helper II rankHelper II
6 years ago

update

 

new example

  • Bessonnizza's avatar
    Bessonnizza
    Icon for Helper II rankHelper II
    6 years ago

    Solution:

     

    GetStatistics = Table.AddColumn(StartBuild, "GetStatistics", each Function.InvokeAfter(()=>fnTrackPeriodsMileage_GetStatistics([SessionId], [StatisticsSessionId]), #duration(0,0,0,15))),