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