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="a...
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)]))

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)]))

  • purple_banana's avatar
    purple_banana
    Frequent Visitor
    3 years ago

    **bleep** I was close ğŸ˜‚

     

    Thank you!