WebAPi Query Timeout

[Geoffrey Estrade]

Hi everyone,

I'm using Get and Transform Data to get data from my webapi. If the amount of data is big and the job is hard, the webapi can take few minutes to response Excel. The problem is about 1m30s after the begin, Excel launch a new query to my webapi, so two jobs running in my server. When the initial job in done, Excel ignore the result because Excel have start a second query. after 1m30s, Excel launch a third query, etc, etc, etc. 5 minutes time after, Excel exit in timeout.

Can I tell to Excel to doesn't start a new query if the first take a lot of time?

Thanks

Geoffrey,

[#2 · Accepted solution]

Ok I found a the solution. The first time I create the query, I can set the timeout in advanced settings window.

For an existing query, I can add the timeout with the advanced editor

Source = Json.Document(Web.Contents("http://172.17.8.102/swa/api/trendquery", [Timeout=#duration(0, 0, 5, 0)])),