Hi Daniel,
Thank you for the response. I tried with the redirect workaround as you
suggested but it does not help. It gives the same "Request Timed Out"
error. I am sharing the below query, if you could please look into the same
and help:
----------------------------------------------------------------------------
<!DOCTYPE html>
<html>
<head>
<style>
#f2dj__table table {
font-size: 12pt;
font-weight:bold;
}
#f2dj__table th {
background: orange;
}
</style>
<script src="https://www.gstatic.com/charts/loader.js";
type="text/javascript"></script><script type="text/javascript">
var f2dj_sskey='1gOEU8Oo9rPznYHIEkSSOpH0CyUqnvOVeDQTpBo1ERv0'
var f2dj_sheet=752311914
var f2dj_authkey='CITwr80K'
google.charts.load('current', {'packages' : ['table']});
//google.load('visualization', '1', {'packages':['table']});
function f2dj_getData(){
var q='select A,C,D,E'
var
url='https://spreadsheets.google.com/tq?tq='+encodeURIComponent(q)+'&key='+f2dj_sskey+'&authkey='+f2dj_authkey+'&gid='+f2dj_sheet;
var query = new google.visualization.Query(url);
query.send(f2dj_displayTable);
}
function f2dj_displayTable(response){
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' +
response.getDetailedMessage());
return;
}
var data = response.getDataTable();
visualization = new
google.visualization.Table(document.getElementById('f2dj__table'));
visualization.draw(data, null);
var table = new
google.visualization.Table(document.getElementById('f2dj__table'));
var formatter = new google.visualization.ColorFormat();
formatter.addRange(-20000, -0, 'white', '#e74c3c');
formatter.addRange(0, 20000, 'white', '#27ae60');
formatter.format(data, 3); // Apply formatter to second column
table.draw(data, {allowHtml: true, showRowNumber: true, width:'100%',
height:'100%' });
}
//google.setOnLoadCallback(f2dj_getData)
google.charts.setOnLoadCallback(f2dj_getData)
</script>
</head>
<body>
<div id="f2dj__table">
</div>
<!-- END: f1dj Google Spreadsheet/viz api table insert -->
</body>
</html>
-----------------------------------------------------------------------------
I am just sharing one query. All these were working perfectly fine till 5-6
days before. Only now they are throwing the "Request Timed Out" error.
Request you to please look into the same. Thanks.
On Wednesday, 29 July 2020 at 16:16:50 UTC+5:30 Avadhoot Dandekar wrote:
> Hey Daniel,
>
> Even today when you try a case that is explained in the Miscellaneous
> Examples here:
>
> https://developers.google.com/chart/interactive/docs/examples
>
> also throws the same "Request Timed Out" error. You can yourself check
> this now. This problem started only from the last 5-6 days. Till then all
> queries were working fine. Any thoughts on this? Please. Thanks.
>
> On Monday, 27 July 2020 at 20:19:44 UTC+5:30 Daniel LaLiberte wrote:
>
>> I believe the general problem with the timed-out Query calls that are
>> happening in the latest version (v49) is that the original spreadsheet URL
>> is being redirected to another server but the redirect is not done in a way
>> that works. I've seen this happen in a couple different cases already, and
>> I suspect other cases are similar.
>>
>> So if this is the case, you can work around this problem by looking in
>> your browser's debugger to see what the URL is redirecting to, and then use
>> that new URL directly.
>>
>> If this is not the case, then please post (or send me) a link to a page
>> that demonstrates the problem you are seeing.
>>
>> I hope that helps.
>>
>> On Mon, Jul 27, 2020 at 9:21 AM Jim West <[email protected]> wrote:
>>
>>>
>>> I am seeing the same problem with my Google Map application.
>>> I have not changed anything in my application 2 weeks, but the "Error
>>> in Query" problem just started appearing in the last 2 days.
>>> When I attempt to display my Google Map, there is a long delay, and then
>>> the message "Error in Query".
>>> I have to click on the Error in Query message to see my Google Map.
>>> I have attached a file, "WyRow.html" to this message containing an
>>> example of this problem.
>>> I created a Google Map Support request and was told that this was a
>>> Google Chart problem outside their support area.
>>> I am not aware of using Google Chart in my html code.
>>> Please explain what I can to do fix this problem. There is a very long
>>> delay in display my Google Map.
>>> Google Map Support has sent me to your forum.
>>> Has anything changed in a google library over the weekend to cause this
>>> problem ??
>>>
>>> Thanks,
>>> Jim West
>>> Email: [email protected]
>>>
>>> On Friday, July 24, 2020 at 11:20:08 AM UTC-4, Orlando Canchola wrote:
>>>>
>>>> Before I could load charts without that message, I didn't change
>>>> anything in my code. The link to my spreadsheet is:
>>>>
>>>> this
>>>> https://drive.google.com/file/d/1ot4VJqenqtRGdI5QCImaVCUEiN_pRlWv/view?usp=sharing
>>>>
>>>> Please tell me, why I am getting that message?
>>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Google Visualization API" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to [email protected].
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/google-visualization-api/618e60e7-29dc-48a8-abfe-e365ed561a70o%40googlegroups.com
>>>
>>> <https://groups.google.com/d/msgid/google-visualization-api/618e60e7-29dc-48a8-abfe-e365ed561a70o%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>>
>>
>> --
>> Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2>
>> [email protected] Cambridge MA
>>
>>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/9dc34d1b-c766-4dec-9115-a4d702c6149fn%40googlegroups.com.
