Forum Discussion
Solved
Web.Contents - Timeout=#duration
Hi all! Have POST request: let
data = Json.FromValue([StatisticsSessionId=paramStatisticsSessionId]),
headers = [#"accept"="*/*", #"ScoutAuthorization"=paramAuthorizationId, #"C...
Solution:
GetStatistics = Table.AddColumn(StartBuild, "GetStatistics", each Function.InvokeAfter(()=>fnTrackPeriodsMileage_GetStatistics([SessionId], [StatisticsSessionId]), #duration(0,0,0,15))),
Bessonnizza , power query is case sensitive . Try like
if [Value.1] = "Ok", then "A" else if [Value.1] = "Procesing" then "Ok" else "Error"
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).
update
new example
Solution:
GetStatistics = Table.AddColumn(StartBuild, "GetStatistics", each Function.InvokeAfter(()=>fnTrackPeriodsMileage_GetStatistics([SessionId], [StatisticsSessionId]), #duration(0,0,0,15))),