Status Update
Comments
se...@google.com <se...@google.com> #2
dc...@gmail.com <dc...@gmail.com> #3
ga...@prospectpath.com <ga...@prospectpath.com> #4
GAS: It happens consistently when calling UrlFetchApp.fetch("URL"). The same http URL query works fine outside of the Google environment.
Google sheet: At the same time started to experience unsuccessful calls when using IMPORTDATA("URL") in Google sheets. The calls seems to work on/off if I change the query a bit, for a call or two. Outside of the Google environment the calls are successful.
I have looked in vain if there are any restrictions in our Google account. Anyone have a clue on how to resolve this?
se...@google.com <se...@google.com> #5
hi...@gmail.com <hi...@gmail.com> #6
JP...@clairescourt.net <JP...@clairescourt.net> #7
We're also experiencing this issue when calling UrlFetchApp.fetch()
Our production system is down.
ez...@gmail.com <ez...@gmail.com> #8
at get_csv1d_(Code:31:30)
at auxIMP(Code:63:17)
No idea what the error codes mean but this is also affecting exports of CSV files from a URL and attempting to import and parse them. It can't fetch the URL. I can manually access the same link and it works fine so I know this is on Google's end.
ac...@bingologistics.com <ac...@bingologistics.com> #9
We confirmed that the same files are being fetched without an issue outside of AppScript.
an...@gmail.com <an...@gmail.com> #10
iz...@isep-cba.edu.ar <iz...@isep-cba.edu.ar> #11
[Deleted User] <[Deleted User]> #12
Co...@ancoraeducation.com <Co...@ancoraeducation.com> #13
Used to work fine few days ago
br...@bigbrandtire.com <br...@bigbrandtire.com> #14
hi...@gmail.com <hi...@gmail.com> #15
al...@familyfirstpmc.ca <al...@familyfirstpmc.ca> #16
We are also encountering the issue with ImportData in Google Sheets mentioned by above. That has been failing 100% of the time on automatic refresh for at least the past 24 hours. Many cases being reported here
jr...@gmail.com <jr...@gmail.com> #17
ad...@dpdgroup.co.uk <ad...@dpdgroup.co.uk> #18
var csvData = Utilities.parseCsv(UrlFetchApp.fetch('
ba...@gmail.com <ba...@gmail.com> #19
JP...@clairescourt.net <JP...@clairescourt.net> #20
Also If i Check my web server logs, It does returns response successfully.
jr...@digitalremedy.com <jr...@digitalremedy.com> #21
[Deleted User] <[Deleted User]> #22
am...@var.fr <am...@var.fr> #23
re...@digitalmarketinglabs.com <re...@digitalmarketinglabs.com> #24
si...@wearecompany.co.uk <si...@wearecompany.co.uk> #25
[Deleted User] <[Deleted User]> #26
an...@gmail.com <an...@gmail.com> #27
nu...@pocketmath.com <nu...@pocketmath.com> #28
am...@var.fr <am...@var.fr> #29
de...@gmail.com <de...@gmail.com> #30
tr...@sierracharter.com <tr...@sierracharter.com> #31
va...@gmail.com <va...@gmail.com> #32
sv...@devblock.net <sv...@devblock.net> #33
am...@var.fr <am...@var.fr> #34
These issues have resulted in a significant loss of trust in Google Apps Script.
ad...@var.fr <ad...@var.fr> #35
ke...@focusproducts.com.au <ke...@focusproducts.com.au> #36
da...@gmail.com <da...@gmail.com> #37
an...@gmail.com <an...@gmail.com> #38
[Deleted User] <[Deleted User]> #39
I have the same issue when trying to obtain the content text from redash in CSV format! In JSON format it works just fine. Please fix this, it just stopped working overnight.
ry...@rentuzzi.com <ry...@rentuzzi.com> #40
This has been a problem for the past 2-3 days for me when using IMPORTDATA()
on a CSV file. I do
Yesterday, this failure was pretty intermittent. I could cache-bust the URL a few times and get it working. Today, out of roughly 30 attempts, I can't get any URLs to load.
de...@gmail.com <de...@gmail.com> #41
ey...@gmail.com <ey...@gmail.com> #42
I can verify through server logs that the HTTP request is being made, and data returned by the server hosting the CSV file:
66.102.8.209 - - [09/Dec/2020:13:22:36 -0800] "GET /data/csv/butte-dashboard-v3.csv HTTP/1.1" 200 20192 "-" "Mozilla/5.0 (compatible; GoogleDocs; apps-spreadsheets; +http://docs.google.com)"
The end result is still #N/A
in the cell, with an error on hover saying Could not fetch url: https://bc19.live/data/csv/butte-dashboard-v3.csv
.
[Deleted User] <[Deleted User]> #43
Looking at the resulting internal HTTP request to fetchData
, I get back something with a whole lot of null
s:
[null,[[null,"{1\u003d6,9\u003d{1\u003d51#https://bc19.live/data/csv/butte-dashboard-v3.csv?7}}",null,[null,null,[null,7,37,[[null,2,"https://bc19.live/data/csv/butte-dashboard-v3.csv?7"]]],1.60754958746E9,null,null,null,null,[]]]]]
pi...@gmail.com <pi...@gmail.com> #44
li...@gmail.com <li...@gmail.com> #45
It looks like this may be specifically related to CSV parsing. If I convert the CSV file to TSV first, it works reliably.
If you have to go this route, and can set up any intermediary URL for a CSV file, here's a basic Python script that can convert CSV to TSV:
#!/usr/bin/env python
import csv
import sys
in_filename = sys.argv[1]
out_filename = in_filename.replace('.csv', '.tsv')
with open(in_filename, 'r') as in_fp:
with open(out_filename, 'w') as out_fp:
csv.writer(out_fp, dialect='excel-tab').writerows(csv.reader(in_fp))
sm...@gmail.com <sm...@gmail.com> #46
go...@kukurin.co <go...@kukurin.co> #47
[Deleted User] <[Deleted User]> #48
aa...@gmail.com <aa...@gmail.com> #49
ty...@ashleyvance.com <ty...@ashleyvance.com> #50
sa...@flowglobal.net <sa...@flowglobal.net> #51
ar...@collabasia.com <ar...@collabasia.com> #52
ty...@gmail.com <ty...@gmail.com> #53
jb...@kaliop.com <jb...@kaliop.com> #54
bu...@apesan.com.tr <bu...@apesan.com.tr> #55
ar...@digital-effect.com <ar...@digital-effect.com> #56
ma...@gmail.com <ma...@gmail.com> #57
ta...@gmail.com <ta...@gmail.com> #58
[Deleted User] <[Deleted User]> #59
bp...@gmail.com <bp...@gmail.com> #60
ta...@gmail.com <ta...@gmail.com> #61
an...@gmail.com <an...@gmail.com> #62
Hi there!
I have been evaluating your issue, but I can't replicate it. If you keep facing this behaviour, please share the minimal steps needed for its reproduction. If it is possible, please share too an example URL that repeat the issue.
ta...@gmail.com <ta...@gmail.com> #63
am...@var.fr <am...@var.fr> #64
al...@mesonet-quebec.org <al...@mesonet-quebec.org> #65
With G-connector addon installed, and an access to a salesforce just try to import any report. That do not work anymore for me since yesterday.
al...@mesonet-quebec.org <al...@mesonet-quebec.org> #66
gu...@solutions-mesonet.org <gu...@solutions-mesonet.org> #67
but its basically
importdata('url') on an external (non google drive) .csv file
i have 0 problems reproducing it
[Deleted User] <[Deleted User]> #68
I reproduced it with a minimal spreadsheet and a new script.
an...@gmail.com <an...@gmail.com> #69
function myFunction() {
UrlFetchApp.fetch("
}
[Deleted User] <[Deleted User]> #70
var url = the URL from Workday
var b64 = the username and password
var response = UrlFetchApp.fetch(url, {
headers: {
Authorization: 'Basic '+ b64
}
});
[Deleted User] <[Deleted User]> #71
[Deleted User] <[Deleted User]> #72
jb...@kaliop.com <jb...@kaliop.com> #73
ta...@gmail.com <ta...@gmail.com> #74
function myFunction() {
UrlFetchApp.fetch("
}
<?php
$filename="
$content=file_get_contents($filename);
echo $content;
?>
je...@les3chouettes.fr <je...@les3chouettes.fr> #75
ma...@elmarasi.com <ma...@elmarasi.com> #76
dc...@gmail.com <dc...@gmail.com> #77
GOOGLE PLEASE PROVIDE AN ETA ON CORRECTION.
PLEASE UPDATE US WITH CURRENT STATUS. ASAP
JP...@clairescourt.net <JP...@clairescourt.net> #78
ca...@restauratiemetkwaliteit.be <ca...@restauratiemetkwaliteit.be> #79
[Deleted User] <[Deleted User]> #80
jb...@kaliop.com <jb...@kaliop.com> #81
ma...@elmarasi.com <ma...@elmarasi.com> #82
jb...@kaliop.com <jb...@kaliop.com> #83
ta...@gmail.com <ta...@gmail.com> #84
Would like to thank you for the new script engine! The 30 - 60 script failure notifications per day are down to 3 - 4.
Notwithstanding the above, please, address this conundrum as expeditiously as possible.
dk...@lajkonik.com <dk...@lajkonik.com> #85
ca...@restauratiemetkwaliteit.be <ca...@restauratiemetkwaliteit.be> #86
ty...@gmail.com <ty...@gmail.com> #87
mi...@datacompusa.com <mi...@datacompusa.com> #88
fp...@gmail.com <fp...@gmail.com> #89
G-Connector will give random errors when running scheduled operations.
Thanks!
va...@g.hmc.edu <va...@g.hmc.edu> #90
ba...@gmail.com <ba...@gmail.com> #91
ba...@gmail.com <ba...@gmail.com> #92
ol...@inaubi.fr <ol...@inaubi.fr> #93
am...@liverpool.com.mx <am...@liverpool.com.mx> #94
ca...@restauratiemetkwaliteit.be <ca...@restauratiemetkwaliteit.be> #95
bs...@gracechristian.edu <bs...@gracechristian.edu> #96
ma...@elmarasi.com <ma...@elmarasi.com> #97
var csvContentURL = UrlFetchApp.fetch(url).getContentText();
var csvContentURLparsed = Utilities.parseCsv(csvContentURL);
It is causing major reporting issues. I can't help to observe that this started happening exactly when Google started rolling out the new script UI.
This morning it reported an issue. Interestingly currently the script fails without reporting an issue.
ta...@gmail.com <ta...@gmail.com> #98
Hello! Thanks for your messages.
I could reproduce this issue and I submitted it to the appropriate team. Any update will be posted here.
Thanks for your patience.
ca...@restauratiemetkwaliteit.be <ca...@restauratiemetkwaliteit.be> #99
ta...@gmail.com <ta...@gmail.com> #100
ad...@conceptliquids.com <ad...@conceptliquids.com> #101
na...@aeco.hu <na...@aeco.hu> #102
ta...@gmail.com <ta...@gmail.com> #103
ak...@tss-ae.com <ak...@tss-ae.com> #104
ma...@educacao.mg.gov.br <ma...@educacao.mg.gov.br> #105
al...@gmail.com <al...@gmail.com> #106
dc...@gmail.com <dc...@gmail.com> #107
1) create php file on your server for example getthatfile.php:
replace text secretsalt with something different. It's for security reason
<?php
if($_GET["s"]=="secretsalt"){
$filename=$_GET["file"];
$content=file_get_contents($filename);
echo $content;
}
?>
2) in your google script create function . Remember to change secretsalt
function getfromphp(file) {
return UrlFetchApp.fetch("
}
3) in your code use this
istead UrlFetchApp.fetch(url);
use
getfromphp(url);
wc...@gmail.com <wc...@gmail.com> #108
JP...@clairescourt.net <JP...@clairescourt.net> #109
da...@rockitcoin.com <da...@rockitcoin.com> #110
jo...@prata.mx <jo...@prata.mx> #111
co...@gmail.com <co...@gmail.com> #112
ca...@restauratiemetkwaliteit.be <ca...@restauratiemetkwaliteit.be> #113
ad...@gmail.com <ad...@gmail.com> #114
fo...@costco.com <fo...@costco.com> #115
ds...@inicie.digital <ds...@inicie.digital> #116
al...@gmail.com <al...@gmail.com> #117
ma...@gmail.com <ma...@gmail.com> #118
co...@gmail.com <co...@gmail.com> #119
ca...@restauratiemetkwaliteit.be <ca...@restauratiemetkwaliteit.be> #120
Given the number of business systems clearly impacted this would deserve escalated attention.
sm...@hotwax.co <sm...@hotwax.co> #121
mi...@ryniecki.pl <mi...@ryniecki.pl> #122
la...@ljd-tech.com <la...@ljd-tech.com> #123
JP...@clairescourt.net <JP...@clairescourt.net> #124
Thank you!
in...@excelkida.com <in...@excelkida.com> #125
ad...@gmail.com <ad...@gmail.com> #126
dw...@ella.co <dw...@ella.co> #127
ma...@sunlab.de <ma...@sunlab.de> #128
da...@rockitcoin.com <da...@rockitcoin.com> #129
da...@rockitcoin.com <da...@rockitcoin.com> #130
ta...@gmail.com <ta...@gmail.com> #131
ka...@gmail.com <ka...@gmail.com> #132
au...@fidesio.com <au...@fidesio.com> #133
th...@toolsense.io <th...@toolsense.io> #134
kr...@highground.be <kr...@highground.be> #135
ma...@hugen.com.au <ma...@hugen.com.au> #136
We would all appreciate if you could please increase the priority of this and look to issue a patch to remedy the situation.
Thanks,
-Mike
Demandbase, Inc.
ad...@gmail.com <ad...@gmail.com> #137
OK anger aside for a moment. I have a script which uses UrlFetchApp to get data from an API via CSV. It give the unexpected error. When I copy the identical URL to a Google Sheet and use importHTML it works just fine, as it has for months.
to...@gmail.com <to...@gmail.com> #138
Running on life support... this is not good. Xappex... can you do any work around using the suggestions on this thread? I am not generally ok paying subscription revenues and then having my vendor reply with "its all on Google". Please post an update to let the user community know what's happening and your efforts. Would really appreciate it.
tr...@sierracharter.com <tr...@sierracharter.com> #139
ra...@in.g4s.com <ra...@in.g4s.com> #140
ca...@restauratiemetkwaliteit.be <ca...@restauratiemetkwaliteit.be> #141
br...@jmellosaude.pt <br...@jmellosaude.pt> #142
ma...@elmarasi.com <ma...@elmarasi.com> #143
se...@google.com <se...@google.com> #144
la...@ljd-tech.com <la...@ljd-tech.com> #145
co...@gmail.com <co...@gmail.com> #146
JP...@clairescourt.net <JP...@clairescourt.net> #147
ka...@gmail.com <ka...@gmail.com> #148
ra...@in.g4s.com <ra...@in.g4s.com> #149
am...@var.fr <am...@var.fr> #150
ce...@hemoeco.com <ce...@hemoeco.com> #151
[Deleted User] <[Deleted User]> #152
am...@var.fr <am...@var.fr> #153
#107 workaround work fine; thanks!
ty...@gmail.com <ty...@gmail.com> #154
jr...@gmail.com <jr...@gmail.com> #155
br...@jmellosaude.pt <br...@jmellosaude.pt> #156
la...@ljd-tech.com <la...@ljd-tech.com> #157
We rely heavily on urlfetch function for advertising reporting purposes. Every report script is down now. Please increase the priority of this issue.
Description
The error I get is: "Statement cancelled due to timeout or client request". This error throws in just a few seconds but very simple queries run fine, so I assume the timeout is set to something very small. Tried using setQueryTimeout(30), this didn't make any difference and the error still threw in just a few seconds. Larger parameters for setQueryTimeout are rejected.