Forum Discussion

purple_banana's avatar
purple_banana
Frequent Visitor
3 years ago
Solved

Adding Timeout to a Web.Contents Dataflow query

I have the following query which works, however the API is very slow, and if I try to increase the date range it times out:

 

Json.Document(Web.Contents("https://<source>/api/v2/",[RelativePath="analytics-stream?startDate="
    & Date.ToText(RangeStart, "yyyy-MM-dd") & "&endDate=" & Date.ToText(RangeEnd, "yyyy-MM-dd")
    &"&code=01"]))
 
I think I should be able to add a timeout argument: e.g. "[Timeout=#duration(0, 0, 30, 0)]" - From research I thought it would go before the end parentheses, however no matter where I put it, the query subsequently fails;
 
Json.Document(Web.Contents("https://<source>/api/v2/",[RelativePath="analytics-stream?startDate=" & Date.ToText(RangeStart, "yyyy-MM-dd") & "&endDate=" & Date.ToText(RangeEnd, "yyyy-MM-dd")
    &"&code=01"],[Timeout=#duration(0, 0, 30, 0)]))
Error: 3 arguments were passed to a function which expects between 1 and 2
 
Json.Document(Web.Contents("https://<source>/api/v2/",[RelativePath="analytics-stream?startDate="
    & Date.ToText(RangeStart, "yyyy-MM-dd") & "&endDate=" & Date.ToText(RangeEnd, "yyyy-MM-dd")
    &"&code=01"]),[Timeout=#duration(0, 0, 30, 0)])
Error: We cannot convert a value of type Record to type Number

Json.Document(Web.Contents("https://<source>/api/v2/",[Timeout=#duration(0, 0, 30, 0)],[RelativePath="analytics-stream?startDate=" & Date.ToText(RangeStart, "yyyy-MM-dd") & "&endDate=" & Date.ToText(RangeEnd, "yyyy-MM-dd")
    &"&code=01"]))
Error: 3 arguments were passed to a function which expects between 1 and 2
 
Please can anyone help with how I should incorperate this argument to this query?
 
Many thanks
Dataflow
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    Json.Document(Web.Contents("https:///api/v2/",[RelativePath="analytics-stream?startDate=" & Date.ToText(RangeStart, "yyyy-MM-dd") & "&endDate=" & Date.ToText(RangeEnd, "yyyy-MM-dd") &"&code=01",Timeout=#duration(0, 0, 30, 0)]))

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    Json.Document(Web.Contents("https:///api/v2/",[RelativePath="analytics-stream?startDate=" & Date.ToText(RangeStart, "yyyy-MM-dd") & "&endDate=" & Date.ToText(RangeEnd, "yyyy-MM-dd") &"&code=01",Timeout=#duration(0, 0, 30, 0)]))