Forum Discussion
WebAPi Query Timeout
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,
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)])),
1 Reply
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)])),