"Unexpected error" happening randomely accross all our users when trying to do UrlFetch() [175141974]

Verified

Bug

Status Update

No update yet.

Description

al...@xappex.com

created issue #1

Dec 9, 2020 01:48PM

Same issue started to happen as in 169350829 (

https://issuetracker.google.com/169350829).

"Several days ago, we've noticed that there has been a 10-fold increase of "Unexpected error" for all our users.
It happens when we call the UrlFetch() method. Re-running the operation works fine in most cases, however this increased the number of errors that are being reported to our support dramatically.
The issue is random, so there's no way to reproduce it consistently."

Comments

al...@xappex.com <al...@xappex.com> #2Dec 9, 2020 01:58PM

the error happens when calling UrlFetchApp.fetch()

al...@xappex.com <al...@xappex.com> #3Dec 9, 2020 01:58PM

This happens in a published add-in

ka...@kobler.no <ka...@kobler.no> #4Dec 9, 2020 02:18PM

I'm calling the same URL API endpoints from Google script editor UrlFetchApp.fetch("URL") and Google sheets (IMPORTDATA("URL"). This is what I've experienced since evening 8th Dec CET:

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?

Message last modified on Dec 9, 2020 02:29PM

na...@gmail.com <na...@gmail.com> #5Dec 9, 2020 02:56PM

same for me, got same problems

ab...@brunswicknews.com <ab...@brunswicknews.com> #6Dec 9, 2020 03:18PM

same here, got same issue - it affect all our users and not just random.

[Deleted User] <[Deleted User]> #7Dec 9, 2020 03:19PM

We're also experiencing this issue when calling UrlFetchApp.fetch()

Our production system is down.

ch...@telenetwork.com <ch...@telenetwork.com> #8Dec 9, 2020 03:35PM

[20-12-09 10:26:13:787 EST] Exception: Unexpected error: URL[Redcated for privacy purposes]
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.

mf...@redgobo.com <mf...@redgobo.com> #9Dec 9, 2020 03:41PM

We are also experiencing this issue in Google AppScript. For us it seems to happen specifically when fetching CSV files, and it happens 100% of the time. Just started occurring this morning or late yesterday.

We confirmed that the same files are being fetched without an issue outside of AppScript.

jo...@elementum.com <jo...@elementum.com> #10Dec 9, 2020 03:42PM

same

sh...@leenergy.com <sh...@leenergy.com> #11Dec 9, 2020 03:45PM

Same

mi...@futurezone.at <mi...@futurezone.at> #12Dec 9, 2020 03:46PM

Same issue here when trying to fetch public CSV files with code that worked before

ro...@avalon.au <ro...@avalon.au> #13Dec 9, 2020 03:55PM

We are having the same issue. If spreadsheet is open - fetch seems to execute correctly even triggered by trigger. However, as soon as I close the spreadsheet tab on my machine - all executions by trigger cause Exception: Unexpected error:

Used to work fine few days ago

ma...@sleeb.co.uk <ma...@sleeb.co.uk> #14Dec 9, 2020 04:03PM

same issue

dy...@homechef.com <dy...@homechef.com> #15Dec 9, 2020 04:06PM

Same issue, coincidentally aligned with latest Apps Script Release on December 7th.

https://developers.google.com/apps-script/releases#december_2020

pe...@gmail.com <pe...@gmail.com> #16Dec 9, 2020 04:16PM

Also encountering this issue, although sporadically - we have 9 scripts using the UrlFetch method triggered nightly, and have had 4 instances fail with the unexpected error message over the past 3 nights.

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

https://support.google.com/docs/thread/87544571?hl=en

rh...@letsgetready.org <rh...@letsgetready.org> #17Dec 9, 2020 04:23PM

Huge issue for us; all of our operations are down as a result

pa...@fazwaz.com <pa...@fazwaz.com> #18Dec 9, 2020 04:25PM

I am having this issue as well. As of today, this line which has been working for months now only gives me "Unexpected Error".

var csvData = Utilities.parseCsv(UrlFetchApp.fetch('

https://example.com/data_feed_00.csv').getContentText())

a....@pyrexx.com <a....@pyrexx.com> #19Dec 9, 2020 04:33PM

same here, it seems to be also affecting direct use of ImportData inside a google sheet function

[Deleted User] <[Deleted User]> #20Dec 9, 2020 04:56PM

This has been affecting us as well since last night and its been pretty random where some calls pass through and some fail.

Also If i Check my web server logs, It does returns response successfully.

[Deleted User] <[Deleted User]> #21Dec 9, 2020 05:00PM

Having the same issue running G-connector with Salesforce Reporting Queries

[Deleted User] <[Deleted User]> #22Dec 9, 2020 05:01PM

This happens for us with =IMPORTDATA() fetching cached CSVs from an application that we use. It has been happening since early on December 8th.

je...@logicgate.com <je...@logicgate.com> #23Dec 9, 2020 05:02PM

This is affecting me as well. Running into a lot of issues where we have relied on Sheets for business processes.

[Deleted User] <[Deleted User]> #24Dec 9, 2020 05:09PM

Issue with API calls (g-connector for Salesforce)

[Deleted User] <[Deleted User]> #25Dec 9, 2020 05:16PM

Same issue with the Salesforce G-Connector. Causing major problems for my team

[Deleted User] <[Deleted User]> #26Dec 9, 2020 05:17PM

Having the issue with the Salesforce-Data Studio connector. Seems totally random -- one visualizations will throw an error, and another one using the same data source doesn't. Refreshing the connection just makes different random visualizations throw errors.

[Deleted User] <[Deleted User]> #27Dec 9, 2020 05:52PM

Also having the same problem with external API calls. When filling the get query with less than required parameters, call completes no problem, and server errors pointing out the missing parameters are normally received and processed. When all query parameters are present, table structure expected to be received with data is not, and Unexpected error Exception is raised. Was working flawlessly until now.

sb...@remaxintegra.com <sb...@remaxintegra.com> #28Dec 9, 2020 06:20PM

Also having the same problem when i try to refresh the reports on google sheets from salesforce

sb...@remaxintegra.com <sb...@remaxintegra.com> #29Dec 9, 2020 06:20PM

Also having the same problem when i try to refresh the reports on google sheets from salesforce

sh...@leenergy.com <sh...@leenergy.com> #30Dec 9, 2020 07:11PM

@google any update to provide? Hard to believe this issue was reported at 7:48 AM and there has been no response yet?

Message last modified on Dec 9, 2020 07:17PM

jf...@softerware.com <jf...@softerware.com> #31Dec 9, 2020 07:21PM

The same issue with the Salesforce G-Connector still having issues with some calls. Any idea on when a fix may be determined?

pu...@gmail.com <pu...@gmail.com> #32Dec 9, 2020 07:28PM

same here with the IMPORTDATA() function which is fetching a CSV from a URL. It stopped working on 12/8 as reported by over 350 people in the last 24 hours here:

https://support.google.com/docs/thread/87544571

sh...@caincentives.com <sh...@caincentives.com> #33Dec 9, 2020 08:03PM

Same here. Can't pull any data from Salesforce. Appears that we can push still.

rs...@gmail.com <rs...@gmail.com> #34Dec 9, 2020 08:15PM

Can't pull anything using any of our URLFetch calls. This has tanked at least one project and is the second critical error we've experienced with Google Apps Script over the past week (the other being

https://issuetracker.google.com/issues/174489617).

These issues have resulted in a significant loss of trust in Google Apps Script.

sp...@stjosephhowell.org <sp...@stjosephhowell.org> #35Dec 9, 2020 08:36PM

same problem!

rs...@gmail.com <rs...@gmail.com> #36Dec 9, 2020 08:37PM

Noticed something interesting when testing - *the error only occurs when the getContentText() is in CSV format* and does not occur when the getContentText() is in JSON format. Is this true for everyone else?

[Deleted User] <[Deleted User]> #37Dec 9, 2020 08:42PM

I'm with this problem too. Please fix.

[Deleted User] <[Deleted User]> #38Dec 9, 2020 08:47PM

We rely on this integration for business critical functions, currently only using reports, but working toward SOQL. Any idea when it will be fixed? We'll have to find very manual workaround until then.

di...@gmail.com <di...@gmail.com> #39Dec 9, 2020 08:51PM

"Noticed something interesting when testing - *the error only occurs when the getContentText() is in CSV format* and does not occur when the getContentText() is in JSON format. Is this true for everyone else?"

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.

Message last modified on Dec 9, 2020 09:41PM

ch...@beanbaginc.com <ch...@beanbaginc.com> #40Dec 9, 2020 09:11PM

This has been a problem for the past 2-3 days for me when using IMPORTDATA() on a CSV file. I do COVID-19 reporting for Butte County, CA, and this failure is preventing me from providing updates to thousands of people, at a time when it really matters (peak numbers locally, and people are making decisions off what I report).

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.

sp...@stjosephhowell.org <sp...@stjosephhowell.org> #41Dec 9, 2020 09:22PM

Same problem. Google support please fix this!

ch...@beanbaginc.com <ch...@beanbaginc.com> #42Dec 9, 2020 09:25PM

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.

ch...@beanbaginc.com <ch...@beanbaginc.com> #43Dec 9, 2020 09:34PM

Looking at the resulting internal HTTP request to fetchData, I get back something with a whole lot of nulls:

[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,[]]]]]

Message last modified on Dec 9, 2020 09:35PM

ad...@sirum.org <ad...@sirum.org> #44Dec 9, 2020 09:50PM

Happening to us for a critical nonprofit service as well. Both UrlFetchApp.fetch() and IMPORTDATA() are failing for our CSV importing. Issue seems close to 100% failure rate and started for us early today.

ch...@beanbaginc.com <ch...@beanbaginc.com> #45Dec 9, 2020 10:17PM

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

al...@xappex.com <al...@xappex.com> #46Dec 9, 2020 10:57PM

Is Google even aware of this?

ik...@salesforce.com <ik...@salesforce.com> #47Dec 9, 2020 11:10PM

Same! This has been going on intermittently since last week. A simple Apps Script function handled for it through the weekend, and now that's not working, either. This is heavily impacting my team/business, as our reporting has become extremely manual and stale.

pr...@prestonsmalley.com <pr...@prestonsmalley.com> #48Dec 9, 2020 11:32PM

see the same issue. All importData("filename.csv") functions in Google Sheets stopped working on 12/8.

iv...@alumnos.usm.cl <iv...@alumnos.usm.cl> #49Dec 10, 2020 12:38AM

Seems like it's working again

ri...@homechef.com <ri...@homechef.com> #50Dec 10, 2020 02:02AM

Still experiencing this issue on our end

ap...@tiltingfutures.org <ap...@tiltingfutures.org> #51Dec 10, 2020 02:27AM

We are having this issue with any data we are pulling in from Salesforce but not Google Sheets. This is causing a major interruption in our work. Hoping it gets resolved very soon.

vh...@gmail.com <vh...@gmail.com> #52Dec 10, 2020 04:21AM

Same

vh...@gmail.com <vh...@gmail.com> #53Dec 10, 2020 04:21AM

Same

go...@gmail.com <go...@gmail.com> #54Dec 10, 2020 05:58AM

Same

ri...@gmail.com <ri...@gmail.com> #55Dec 10, 2020 07:33AM

Same Here. Please help. The error occurs while fetching CSV file from the URL endpoint. Lots of Unexpected error since last 2 days.

t_...@reazon.jp <t_...@reazon.jp> #56Dec 10, 2020 07:59AM

Same

wd...@gmail.com <wd...@gmail.com> #57Dec 10, 2020 08:03AM

Seems like it's working again

ka...@rudel.jp <ka...@rudel.jp> #58Dec 10, 2020 08:05AM

Same

Message last modified on Dec 10, 2020 08:05AM

[Deleted User] <[Deleted User]> #59Dec 10, 2020 08:25AM

Same

gi...@officecoach.co.uk <gi...@officecoach.co.uk> #60Dec 10, 2020 09:20AM

Same

hi...@c-fo.com <hi...@c-fo.com> #61Dec 10, 2020 10:11AM

Same plz fix

jo...@google.com <jo...@google.com> #62Dec 10, 2020 10:34AM

Accepted by jo...@google.com.

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.

[Deleted User] <[Deleted User]> #63Dec 10, 2020 10:40AM

We have been experiencing issues with this too since ~ 8th December. We use G-connector for Salesforce and all automation and scheduled updates have stopped working. We rely on this tool for tracking, reporting and modelling. Please fix ASAP thanks!

gf...@bmj.com <gf...@bmj.com> #64Dec 10, 2020 11:02AM

Causing major production issues (gconnector push and pull) - failing 100% currently - started yesterday

[Deleted User] <[Deleted User]> #65Dec 10, 2020 11:02AM

Hi,
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.

ak...@mixedanalytics.com <ak...@mixedanalytics.com> #66Dec 10, 2020 11:55AM

A few add-on users have reported this "unexpected error" issue while downloading CSV files. It started yesterday.

a....@pyrexx.com <a....@pyrexx.com> #67Dec 10, 2020 12:10PM

hey jo...@google.com i can send you many examples if you send me a email where to send them to me

but its basically

importdata('url') on an external (non google drive) .csv file

i have 0 problems reproducing it

pa...@engelska.se <pa...@engelska.se> #68Dec 10, 2020 12:43PM

jo...@google.com: See the duplicate issue for a minimal example:

https://issuetracker.google.com/issues/175149810

I reproduced it with a minimal spreadsheet and a new script.

al...@xappex.com <al...@xappex.com> #69Dec 10, 2020 12:55PM

The problem is reproducible with a single line of code:

function myFunction() {
UrlFetchApp.fetch("

https://www.xappex.com/downloads/UrlFetch_error.csv");
}

si...@tmx.com <si...@tmx.com> #70Dec 10, 2020 01:03PM

same thing here. "Unexpected error" while extracting data from Workday since Dec 8th.

var url = the URL from Workday
var b64 = the username and password

var response = UrlFetchApp.fetch(url, {
headers: {
Authorization: 'Basic '+ b64
}
});

ke...@redhat.com <ke...@redhat.com> #71Dec 10, 2020 01:26PM

Also seeing this error. It's blocking essential work we do by breaking G-Connector. Please fix this ASAP.

ct...@nexamp.com <ct...@nexamp.com> #72Dec 10, 2020 01:31PM

Experiencing the same "Unexpected Error" issue every time I try to refresh an existing report or import a new one.

ka...@vonage.com <ka...@vonage.com> #73Dec 10, 2020 01:31PM

This error is not good, I am struggling to keep my Customer metrics and company wide OKR data up to date. Can we ensure this is fixed soonest.

al...@gmail.com <al...@gmail.com> #74Dec 10, 2020 01:33PM

I'm currently using php as a workaround:

function myFunction() {
UrlFetchApp.fetch("

https://www.xappex.com/php/fetch.php");
}

<?php
$filename="

https://www.xappex.com/downloads/UrlFetch_error.csv";
$content=file_get_contents($filename);
echo $content;
?>

sb...@remaxintegra.com <sb...@remaxintegra.com> #75Dec 10, 2020 01:42PM

This is causing so many operational pauses! @google please fix asap!!!!

ja...@zayo.com <ja...@zayo.com> #76Dec 10, 2020 01:53PM

Extremely impactful to the business. We need acknowledgement and eta please!

sh...@leenergy.com <sh...@leenergy.com> #77Dec 10, 2020 01:59PM

Day 3 and this is still an issue. Unbelivable there is not more responses from google? There seems to be enough reports to warrant that this might actually be an issue?

GOOGLE PLEASE PROVIDE AN ETA ON CORRECTION.

PLEASE UPDATE US WITH CURRENT STATUS. ASAP

an...@masternaut.com <an...@masternaut.com> #78Dec 10, 2020 02:01PM

every script update breaks something. do have a testing process?

da...@openenglish.com <da...@openenglish.com> #79Dec 10, 2020 02:02PM

Same issue with the Salesforce G-Connector. Please Fix this problem ASAP.

ca...@solutionsbyfusion.com <ca...@solutionsbyfusion.com> #80Dec 10, 2020 02:17PM

Hoping the google engineers resolve this soon. I'm confident they will but I sure miss this app and using Google Sheets.

da...@gmail.com <da...@gmail.com> #81Dec 10, 2020 02:18PM

please fix ASAP we need this for our salesforce g-connector

ha...@farahatco.com <ha...@farahatco.com> #82Dec 10, 2020 02:18PM

Facing issue with Salesforce G-Connector. Please check / fix the issue. Kindly update status.

ri...@b-f.com <ri...@b-f.com> #83Dec 10, 2020 02:22PM

I'm experiencing the same issues.

[Deleted User] <[Deleted User]> #84Dec 10, 2020 02:25PM

Good Morning,

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.

as...@hawthorncreative.com <as...@hawthorncreative.com> #85Dec 10, 2020 02:26PM

I get an error with G-Connector for Salesforce when I try to refresh that says "Unexpected error" with a link to the Salesforce report.

al...@helpsy.co <al...@helpsy.co> #86Dec 10, 2020 02:28PM

Having the same issue with Salesforce G-Connector. This has brought our operations to a halt. I need a fix!

da...@gmail.com <da...@gmail.com> #87Dec 10, 2020 02:31PM

Having the same issue running G-connector with Salesforce Reporting Queries, we can't work !

of...@samsara.com <of...@samsara.com> #88Dec 10, 2020 02:38PM

Same issue here, can you please fix asap?

no...@uber.com <no...@uber.com> #89Dec 10, 2020 02:41PM

Same issue here,

G-Connector will give random errors when running scheduled operations.

Thanks!

ki...@turtleos.com <ki...@turtleos.com> #90Dec 10, 2020 02:49PM

Same issue.

de...@gmail.com <de...@gmail.com> #91Dec 10, 2020 02:51PM

Running into same issue. Please help fix this.

[Deleted User] <[Deleted User]> #92Dec 10, 2020 02:55PM

Echo everyone else here. Running into the same issue. Solving this is mission critical to my org as we rely heavily on G-Connector to process reporting and commissions. Please help fix! Thank you.

[Deleted User] <[Deleted User]> #93Dec 10, 2020 03:06PM

I am getting the error whenever I am trying to batch upload. I was not getting the errors 100% of the time until today. I am having to upload and refresh each line individually and with spreadsheets with hundreds of line to upload this is very painstaking and time consuming work. I need this rectified as soon as possible as i am transerferring dozens of documents a day and I am extremely behind schedule today.

he...@cbinsights.com <he...@cbinsights.com> #94Dec 10, 2020 03:06PM

Same issue. Fascinating to see how many orgs use this.

Message last modified on Dec 21, 2020 06:02AM

[Deleted User] <[Deleted User]> #95Dec 10, 2020 03:12PM

causing major problems on my end too.

[Deleted User] <[Deleted User]> #96Dec 10, 2020 03:12PM

Same issue.s

ma...@intelgen.com <ma...@intelgen.com> #97Dec 10, 2020 03:22PM

same issue on many scripts using this simple CSV import type syntax :

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.

ja...@google.com <ja...@google.com> #98Dec 10, 2020 03:27PM

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.

mw...@gmail.com <mw...@gmail.com> #99Dec 10, 2020 03:38PM

Major business functions rely on this.

an...@imatrix.com <an...@imatrix.com> #100Dec 10, 2020 03:41PM

Need this fixed. Critical business functions rely on this tool.

dp...@redhat.com <dp...@redhat.com> #101Dec 10, 2020 03:46PM

please, if possible, put this issue at the higher level of urgency. many processes we have need this running asap. Thanks.

ru...@jwplayer.com <ru...@jwplayer.com> #102Dec 10, 2020 03:50PM

To reiterate on the above post, please escalate as much as possible - this is a major part of our core infrastructure (and clearly many others) and needs to be addressed. Thanks.

[Deleted User] <[Deleted User]> #103Dec 10, 2020 03:52PM

^^^^ very much the case for us too. Please escalate priority and fix asap, thanks!!

ni...@avocet.io <ni...@avocet.io> #104Dec 10, 2020 03:58PM

Same

sb...@remaxintegra.com <sb...@remaxintegra.com> #105Dec 10, 2020 04:03PM

Now some reports are able to be fetched but not all are working!

ma...@creditas.com.br <ma...@creditas.com.br> #106Dec 10, 2020 04:06PM

Need this fixed. Critical business functions rely on this tool. #106

na...@gmail.com <na...@gmail.com> #107Dec 10, 2020 04:11PM

+ recommend temp solution:

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("

http://YOURSERVER/getthatfile.php?file="+ file + "&s=secretsalt");
}

3) in your code use this
istead UrlFetchApp.fetch(url);
use
getfromphp(url);

ka...@vonage.com <ka...@vonage.com> #108Dec 10, 2020 04:17PM

What does that even mean - I use G Connector so I don't have to code?

na...@gmail.com <na...@gmail.com> #109Dec 10, 2020 04:21PM

It's working for google scripts, I don't use G Connector so I can't help:(

al...@xappex.com <al...@xappex.com> #110Dec 10, 2020 04:57PM

We will implement a workaround for G-Connector today in case the underlying platform issue is not fixed.

[Deleted User] <[Deleted User]> #111Dec 10, 2020 05:14PM

Please escalate as the highest priority and resolve as soon as possible as this is a critical business function. Thank you.

[Deleted User] <[Deleted User]> #112Dec 10, 2020 05:21PM

Agreed with the above. This is a critical business function for our Salesforce&GSuite operations. Thank you.

mi...@mariadb.com <mi...@mariadb.com> #113Dec 10, 2020 05:27PM

^^^^ very much the case for us too. Please escalate priority and fix asap, thanks!!

da...@ask.com <da...@ask.com> #114Dec 10, 2020 05:31PM

My team is also seeing the same issues, and the error rate has significantly increased in the last couple of hours.

hc...@apartmentlist.com <hc...@apartmentlist.com> #115Dec 10, 2020 05:35PM

same

li...@gmail.com <li...@gmail.com> #116Dec 10, 2020 05:37PM

ko...@uber.com <ko...@uber.com> #117Dec 10, 2020 05:38PM

yi...@fflbrands.com <yi...@fflbrands.com> #118Dec 10, 2020 05:41PM

Same as above. Started with a few errors on Dec 8 and now experiencing significantly higher error rates in the last couple of hours.

sh...@zscaler.com <sh...@zscaler.com> #119Dec 10, 2020 05:46PM

+ 1

ma...@intelgen.com <ma...@intelgen.com> #120Dec 10, 2020 05:56PM

How is this still showing only a priority level 2 issue ???

Given the number of business systems clearly impacted this would deserve escalated attention.

ja...@appdynamics.com <ja...@appdynamics.com> #121Dec 10, 2020 06:01PM

This needs to be escalated! I depend on this product working correctly to run my business on a day-2-day basis.

sh...@telenetwork.com <sh...@telenetwork.com> #122Dec 10, 2020 06:06PM

Getting the same errors on urlFetchApp.

[Deleted User] <[Deleted User]> #123Dec 10, 2020 06:25PM

Same Issue. I depend on this process to calculate commissions and other financial analysis. Our data that is usually refreshed nightly is now 4 days old...

za...@weedmaps.com <za...@weedmaps.com> #124Dec 10, 2020 06:40PM

Please escalate and resolve as soon as possible my team is experiencing the same issue!

Thank you!

Message last modified on Dec 10, 2020 06:41PM

pa...@gmail.com <pa...@gmail.com> #125Dec 10, 2020 06:54PM

I"m dead in the water without this working. Please escalate and fix ASAP

ju...@mru.org <ju...@mru.org> #126Dec 10, 2020 07:00PM

Having the same issue, causing major workflow issues.

pa...@fazwaz.com <pa...@fazwaz.com> #127Dec 10, 2020 07:01PM

For those who need a working fix, would reiterate this comment as a decent solution in the meantime:

https://issuetracker.google.com/issues/175141974#comment74

ma...@intelgen.com <ma...@intelgen.com> #128Dec 10, 2020 07:03PM

Everyone, I am seeing some scripts with urlfetch CSV imports working again. Something might be happening.

ko...@uber.com <ko...@uber.com> #129Dec 10, 2020 07:06PM

Nothing on my end yet

eb...@redhat.com <eb...@redhat.com> #130Dec 10, 2020 07:34PM

Same issue. We use a method to call and generate an SFDC report that gets converted into a .csv file and gets updated into Gsheets. We have around 20+ files using this method and several schedules throughout the day. All the automation has gone out of the window for the said reports. Major issue.

la...@agapio.eu <la...@agapio.eu> #131Dec 10, 2020 08:18PM

Same issue for us, every call to UrlFetchApp.fetch() with a csv file fails, response seems to be empty... It works fine with other file formats, but not with csv.

ja...@zayo.com <ja...@zayo.com> #132Dec 10, 2020 08:23PM

I am getting 50% failures. Some workbooks 100% while others 5%.

mi...@omicronmedia.com <mi...@omicronmedia.com> #133Dec 10, 2020 08:51PM

Yeah, same thing here. Issues started in on 12/09/2020. I noticed that my issue only occurs when I JSON.stringify(payload). If I send the payload in webform format, the urlfetchapp call goes through, and ofcourse the api gives me a response that can't parse the request body because it's expecting it to be JSON encoded.

[Deleted User] <[Deleted User]> #134Dec 10, 2020 10:23PM

al...@xappex.com <al...@xappex.com> #135Dec 10, 2020 10:48PM

any chance the priority of this can be raised to P1? It's affecting a lot of users.

mh...@demandbase.com <mh...@demandbase.com> #136Dec 10, 2020 11:10PM

Hi, I'd just like to comment from a business PoV. This modification is causing a lot of downstream errors in gsheets we use to run our business (Demandbase). As a result, all of the sheets we use to run our business (forecast, renewals, pipeline, customer scores, (dozens) are slowly breaking or becoming stale due to data becoming stale.

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.

uf...@gmail.com <uf...@gmail.com> #137Dec 10, 2020 11:15PM

Yup, same problem here. This is total BS. I would be willing to pay to have reliability but that is not even an option. Will it get fixed? I wonder... When? I wonder... I have lost faith in Google over this type of thing.

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.

Message last modified on Dec 10, 2020 11:20PM

ja...@zayo.com <ja...@zayo.com> #138Dec 10, 2020 11:25PM

For those using the G-Connector GUI interface... I found that I am getting some muck manually refreshing reports one at a time. When it fails, I "Get Report" the same report into the Active sheet. Also seems to work more often. Then for bulk loads using the GUI... the first Batch completes before presenting an error. While our batch size is fairly restricted, when I increase, the first batch completes before error.

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.

ka...@gmail.com <ka...@gmail.com> #139Dec 10, 2020 11:28PM

Generally if our company deploy software that affects this many customers, we roll back... This fucker is 3 days old now and making all of your customers look like a bunch of retards... Come on Google don't be frugal... You are better than that.

al...@xappex.com <al...@xappex.com> #140Dec 11, 2020 12:29AM

G-Connector has now a workaround deployed, reports should be loading a lot better.

cl...@gmail.com <cl...@gmail.com> #141Dec 11, 2020 01:28AM

sh...@precimarke.jp <sh...@precimarke.jp> #142Dec 11, 2020 03:46AM

la...@bluehorse.com.my <la...@bluehorse.com.my> #143Dec 11, 2020 04:36AM

pr...@gmail.com <pr...@gmail.com> #144Dec 11, 2020 04:40AM

Facing the issue even after 3 days. And its getting worse.

ak...@redhat.com <ak...@redhat.com> #145Dec 11, 2020 05:10AM

Started with some triggers failing to fetch data as CSV files to now being completely down for all the files. This needs a fix ASAP.

to...@toolsplus.io <to...@toolsplus.io> #146Dec 11, 2020 05:16AM

This is also affecting us. Please fix ASAP.

jo...@yle.fi <jo...@yle.fi> #147Dec 11, 2020 06:41AM

an...@netflix.com <an...@netflix.com> #148Dec 11, 2020 06:48AM

m....@mitori.co.jp <m....@mitori.co.jp> #149Dec 11, 2020 06:59AM

[Deleted User] <[Deleted User]> #150Dec 11, 2020 07:09AM

cl...@googlemail.com <cl...@googlemail.com> #151Dec 11, 2020 07:23AM

[Deleted User] <[Deleted User]> #152Dec 11, 2020 07:40AM

mi...@michelecanal.tv.it <mi...@michelecanal.tv.it> #153Dec 11, 2020 07:58AM

+1
#107 workaround work fine; thanks!

Message last modified on Dec 11, 2020 08:07AM

n....@sitespa.it <n....@sitespa.it> #154Dec 11, 2020 08:03AM

sa...@gmail.com <sa...@gmail.com> #155Dec 11, 2020 08:09AM

This issue is open for 3 days now and there are entire businesses that rely on this feature operationally. Isn't it time to increase the priority and severity to P1 and S1? Especially since there are no workarounds available AFAIK.

ke...@redhat.com <ke...@redhat.com> #156Dec 11, 2020 08:11AM

pi...@gtempaccount.com <pi...@gtempaccount.com> #157Dec 11, 2020 09:08AM

We rely heavily on urlfetch function for advertising reporting purposes. Every report script is down now. Please increase the priority of this issue.

al...@gmail.com <al...@gmail.com> #158Dec 11, 2020 09:15AM

sh...@adinnovation.jp <sh...@adinnovation.jp> #159Dec 11, 2020 09:18AM

m....@knuddels.de <m....@knuddels.de> #160Dec 11, 2020 09:18AM

[Deleted User] <[Deleted User]> #161Dec 11, 2020 09:39AM

an...@phdmedia.com <an...@phdmedia.com> #162Dec 11, 2020 09:44AM

Same issue here!

ba...@google.com <ba...@google.com> Dec 11, 2020 09:48AM

Assigned to ja...@google.com.

tu...@flinters.co.jp <tu...@flinters.co.jp> #163Dec 11, 2020 09:51AM

az...@gmail.com <az...@gmail.com> #164Dec 11, 2020 10:02AM

Same issue here.

me...@gmail.com <me...@gmail.com> #165Dec 11, 2020 10:02AM

+1 This issue has been going on for 3 days now. Any updates on when this is going to be fixed? This is causing serious disruption to my business.

an...@sae.edu.au <an...@sae.edu.au> #166Dec 11, 2020 10:12AM

This has broken my company's equipment hiring system, we can no longer create google documents based off a third party CSV report. It will cause us some serious issues if not fixed in the next 48 hours. Anyone know how I can get an update from Google as to whether they aware of and/or plan to fix the issue?

az...@gmail.com <az...@gmail.com> #167Dec 11, 2020 10:20AM

Please look at that

Fri Dec 11 2020 15:49:53 GMT+0530 (India Standard Time).png

139 KB

View

Download

[Deleted User] <[Deleted User]> #168Dec 11, 2020 10:42AM

Same here getting 100 percent error in urlFetch for loading csv using app script from url

ke...@gmail.com <ke...@gmail.com> #169Dec 11, 2020 10:51AM

Requesting this to be put on P1S1

bj...@measureone.com <bj...@measureone.com> #170Dec 11, 2020 10:59AM

Facing same error mesasage when calling fetchURL to get csv data from metabase APIs.

op...@gmail.com <op...@gmail.com> #171Dec 11, 2020 12:00PM

Same issue when I do UrlFetchApp.fetch() for a .CSV file. It's a critical bug that interrupts 100% of our users. Please, fix it.

an...@gmail.com <an...@gmail.com> #172Dec 11, 2020 12:02PM

Please solve now!

fl...@gmail.com <fl...@gmail.com> #173Dec 11, 2020 12:04PM

Same here, causing big problems for us!

ta...@streethub.com <ta...@streethub.com> #174Dec 11, 2020 12:11PM

+1
Production systems are down, please fix ASAP

ba...@gmail.com <ba...@gmail.com> #175Dec 11, 2020 12:38PM

Same here

ja...@google.com <ja...@google.com> #176Dec 11, 2020 12:39PM

Hello!

We are aware of the importance of this issue and it's being investigated.

Thank you all for the information provided.

bi...@gmail.com <bi...@gmail.com> #177Dec 11, 2020 02:00PM

Same here - can't wait for this fix bc my emails getting LOOOOONG haha ;) <3

a....@pyrexx.com <a....@pyrexx.com> #178Dec 11, 2020 02:20PM

i just received this from google:

I hope this message finds you well. This is Hugo following on this case.
I have reviewed internal investigation #175142969 and the product engineering team has confirmed that the roll-out of fix has been completed. For any sheet that is still showing the error , refreshing the browser tab will fix the issue.
I hope this is helpful information. Please let me know if additional concerns arise and I will assist you.

- my sheets that are using importdata() are working again, so at least this seems to be fixed

ri...@homechef.com <ri...@homechef.com> #179Dec 11, 2020 02:22PM

Continuing to try - both manually running scripts and with triggers and still failing very frequently

al...@xappex.com <al...@xappex.com> #180Dec 11, 2020 02:36PM

Refreshed the browser page, the following code still fails in each of the 10 iterations:
function myFunction() {
for (var i =0; i<10; i++)
{
Logger.log(i.toString());

try {

UrlFetchApp.fetch("

https://www.xappex.com/downloads/UrlFetch_error.csv");
Logger.log("success");
}
catch (e) {Logger.log(e);}
Utilities.sleep(1000);
}
}

mh...@gmail.com <mh...@gmail.com> #181Dec 11, 2020 02:42PM

WHY GOOGLE, WHY?

st...@gmail.com <st...@gmail.com> #182Dec 11, 2020 02:49PM

I already refreshed the browser page and none of my codes are working.

I use:

const fetchRequest = UrlFetchApp.fetch(url);
const results = Utilities.parseCsv(fetchRequest);

sb...@remaxintegra.com <sb...@remaxintegra.com> #183Dec 11, 2020 02:52PM

UGH this was working yesterday and now is back to getting Unexpected Error

al...@xappex.com <al...@xappex.com> #184Dec 11, 2020 02:52PM

I'm sure there's some stupid error with fetching text/csv content type, it's just amazing how they can't fix it forth day in a row

ma...@ousedale.org.uk <ma...@ousedale.org.uk> #185Dec 11, 2020 02:55PM

This is still not working. I'm using this script - fails every time

var url =
"

https://docs.google.com/spreadsheets/d/" +
spreadsheetId +
"/gviz/tq?tqx=out:csv&gid=" +
sheetId +
"&access_token=" +
ScriptApp.getOAuthToken();
var res = UrlFetchApp.fetch(url);

dp...@redhat.com <dp...@redhat.com> #186Dec 11, 2020 02:57PM

still getting errors over here as well

ko...@uber.com <ko...@uber.com> #187Dec 11, 2020 02:59PM

Would love it if one of the largest companies in the world could get this issue fixed that so many of us rely on. Almost a week of things breaking and now I've resorted to stale data which is not what my customers have come to expect.

si...@tmx.com <si...@tmx.com> #188Dec 11, 2020 03:47PM

still getting the errors...

[Deleted User] <[Deleted User]> #189Dec 11, 2020 03:52PM

Still receiving Unexpected errors. this is halting our production environment and needs to be addressed immediately.

[Deleted User] <[Deleted User]> #190Dec 11, 2020 03:53PM

My dashboards are back up. Using xappex Salesforce -> Google Data Studio connector.

al...@xappex.com <al...@xappex.com> #191Dec 11, 2020 03:59PM

It's the workaround we deployed that is working. Pulling CSV directly from Apps Script is still down.

jo...@tinuiti.com <jo...@tinuiti.com> #192Dec 11, 2020 04:08PM

Unexpected error when pushing data into Salesforce. Causing widespread outages of processes at my company. Need this resolved ASAP or will be moving to a different platform.

ja...@zayo.com <ja...@zayo.com> #193Dec 11, 2020 04:09PM

Still only getting initial batch completion on bulk loaded - no completion reporting. scheduled refresh still getting unexpected errors at a high rate.

sh...@leenergy.com <sh...@leenergy.com> #194Dec 11, 2020 04:11PM

For those using G-Connector we are able to inset and update data in Salesforce. We are still receving an error message but the information is being edited. The URL it gives you in the error message can be used to download the results of your request. It is simply not updating the true false fields on the sheet but giving them back to you in that URL. Not ideal but a step in the right direction.

ma...@gmail.com <ma...@gmail.com> #195Dec 11, 2020 04:16PM

Same issue

ra...@mobilemaniacos.com.br <ra...@mobilemaniacos.com.br> #196Dec 11, 2020 04:21PM

Same issue here!

sm...@gmail.com <sm...@gmail.com> #197Dec 11, 2020 04:24PM

I've started getting this error every-time I try to open or refresh a report: "Unexpected error occured, please check your report in Salesforce. Joined reports are not supported.". These are NOT joined reports and have been working for months and months. I can't get access to any reports at all now

an...@donboscocare.ie <an...@donboscocare.ie> #198Dec 11, 2020 04:31PM

Be careful when uploading data to Salesforce with something like G-Connector. Just because you receive an error message, doesn't mean that the data didn't upload to Salesforce. For me it did, and did multiple times when I tried again and again to upload this data. So I had to work out how to delete everything that I uploaded.

Like sh...@leenergy.com said in message #194, the url in the error message can be used to download the report of what usually gets put into the results columns. You have to do a little bit of converting of this info, but you can still upload your data and have your results columns populated.

va...@sprinklr.com <va...@sprinklr.com> #199Dec 11, 2020 04:45PM

pls fix this

n....@gmail.com <n....@gmail.com> #200Dec 11, 2020 05:00PM

Same issue.

he...@gmail.com <he...@gmail.com> #201Dec 11, 2020 05:06PM

same issue

yu...@gmail.com <yu...@gmail.com> #202Dec 11, 2020 05:11PM

Same issue. Critical for business functions. Disappointed in Google's slow response.

yu...@wurl.com <yu...@wurl.com> #203Dec 11, 2020 05:12PM

What the guy above said. (Actually.. that's me, but padding this from my work account, too.)

me...@obm.ai <me...@obm.ai> #204Dec 11, 2020 05:16PM

still having this issue, critical to our business, please fix ASAP

ke...@redhat.com <ke...@redhat.com> #205Dec 11, 2020 05:17PM

The Google product team for docs need to do a full rollback to their previous version NOW. Then put in-place a regression test for this issue before releasing it again. They should also have a postmortem on this issue to learn from it (especially the fact that paying customers were out of action for 3+ days). That's scandalous for any company. It should be a downright embarrassment for Google. If the sheets product team have not read Google's SRE book's I'd recommend they do. Start by reading the post-mortem culture chapter

https://sre.google/sre-book/postmortem-culture/

sa...@mindtickle.com <sa...@mindtickle.com> #206Dec 11, 2020 05:29PM

Pulling CSV feeds from Urlfetch() is down. It gives Unexpected data: error every time I fetch. It is impacting a huge chunk of our prod scripts and reporting is affected. Please fix this ASAP.

t....@strategic-blue.com <t....@strategic-blue.com> #207Dec 11, 2020 05:35PM

Urlfetch() stopped working, which is causing major disruption to my team,
please roll back the latest changes and put in place appropriate testing
before deploying new stuff

On Fri, 11 Dec 2020 at 17:29, <buganizer-system@google.com> wrote:

- Show quoted text -

--

This email and any attachments to it may be confidential or proprietary
and are intended solely for the use of the individual to whom it is
addressed. Any views or opinions expressed are solely those of the author
and do not necessarily represent those of Strategic Blue. If you are not
the intended recipient of this email, you must neither take any action
based upon its contents, nor copy or show it to anyone. Please contact the
sender if you believe you have received this email in error, and then
delete this email and any attachments.

Strategic Blue Services Limited, a
company incorporated in England & Wales with registered number 07311921 and
whose registered office is 1 Mercer Street, Covent Garden, London WC2H 9QJ,
United Kingdom.

st...@li.me <st...@li.me> #208Dec 11, 2020 05:35PM

We got random failure of using the APIs since Tuesday afternoon. It got a lot worse yesterday. It affects a lot of our users who reply on the internal tools and reporting dashboards that are built on top of this API.

Google, please fix it as soon as possible, or simply rollback.

[Deleted User] <[Deleted User]> #209Dec 11, 2020 05:45PM

We're also facing this issue with UrlFetchApp.fetch(), Our tools for production system are affected.
Please, fix this.

Message last modified on Dec 11, 2020 06:22PM

fe...@creativelive.one <fe...@creativelive.one> #210Dec 11, 2020 05:58PM

Same here: facing this issue with UrlFetchApp.fetch(), Our tools in production are affected.
Please, fix this.

Message last modified on Dec 11, 2020 06:03PM

ll...@gmail.com <ll...@gmail.com> #211Dec 11, 2020 06:01PM

Hello, I've also been experiencing this error since December 8th. I am trying to pull a .CSV file using UrlFetchApp.fetch(). Please keep us posted with developments.

SH...@magnite.com <SH...@magnite.com> #212Dec 11, 2020 06:02PM

rm...@gmail.com <rm...@gmail.com> #213Dec 11, 2020 06:26PM

ma...@optimizely.com <ma...@optimizely.com> #214Dec 11, 2020 06:57PM

ye...@xappex.com <ye...@xappex.com> #215Dec 11, 2020 06:59PM

bo...@cwi.nl <bo...@cwi.nl> #216Dec 11, 2020 06:59PM

+1

it only triggers on CSV data... who was tinkering with a nice "optimization" for that??

ye...@gmail.com <ye...@gmail.com> #217Dec 11, 2020 07:01PM

pe...@gmail.com <pe...@gmail.com> #218Dec 11, 2020 07:02PM

+1
Occasionally I can fetch the CSV-files, but in 95-99% of the cases I get the Unexpected error. I have refreshed the browser (tried in multiple browsers and computers) and still not working. I can also verify that I get solid good responses from the server providing the CSV-files so there is no problem there. any ETA on when this will be resolved and is there any good workarounds?

ad...@wurl.com <ad...@wurl.com> #219Dec 11, 2020 07:03PM

jo...@scotts.com <jo...@scotts.com> #220Dec 11, 2020 07:10PM

Same here: facing this issue with UrlFetchApp.fetch(), Our tools in production are affected.

cf...@salesforce.com <cf...@salesforce.com> #221Dec 11, 2020 07:38PM

pa...@engelska.se <pa...@engelska.se> #222Dec 11, 2020 07:41PM

For everyone complaining about reliability, it's free and has no SLA: See the API Terms and Conditions:

https://developers.google.com/terms

Specifically, section 9: "... FOR EXAMPLE, WE DON'T MAKE ANY COMMITMENTS ABOUT THE CONTENT ACCESSED THROUGH THE APIS, THE SPECIFIC FUNCTIONS OF THE APIS, OR THEIR RELIABILITY, AVAILABILITY, OR ABILITY TO MEET YOUR NEEDS. WE PROVIDE THE APIS "AS IS"."

Basically, no one should be using Google App Script to build any critical business processes whatsoever. It's for pet projects, "extras", something which adds value but that you can live without.

For "critical" workloads, I recommend instead Google Cloud Platform and App Engine, at least, until Google acknowledge that this a product that many rely upon and only reflects badly on them that it's not reliable or properly supported.

ca...@gmail.com <ca...@gmail.com> #223Dec 11, 2020 07:52PM

engelska.se

Are you a google simp or?

Nothing is free in this world.
You are paying for it somehow or Google benefits from it somehow.

It being free doesn’t excuse a company like google breaking a feature without announcing it beforehand.

Besides, many companies pay for Google G Suite (Google Workspace) which includes Google Sheets.

ti...@gmail.com <ti...@gmail.com> #224Dec 11, 2020 07:57PM

Any update from @google ?

Same here: facing this issue with UrlFetchApp.fetch(), Our tools in production are affected.

Any ETA?

dh...@greenhouse.io <dh...@greenhouse.io> #225Dec 11, 2020 08:14PM

pe...@ibexestudio.com <pe...@ibexestudio.com> #226Dec 11, 2020 08:14PM

gu...@gmail.com <gu...@gmail.com> #227Dec 11, 2020 08:49PM

Same thing. I had to update my Fetch calls to JSON and update all my parsing methods in about a few hours because CSV fetch is broke

pe...@gmail.com <pe...@gmail.com> #228Dec 11, 2020 09:14PM

Likewise, we've had to switch to using JSON rather than CSV for data imports. Fortunately switching the response encoding was pretty trivial in our source system.

If it helps anyone, here's a snippet of code for appending rows from JSON that's fairly analogous to appending rows from CSV. This assumes a JSON response that's an array of objects with all the same keys.

var sheet = SpreadsheetApp.getActive().getSheetByName('YOUR SHEET');
    
var response = UrlFetchApp.fetch("path/to/json");
var data = JSON.parse(response);
if (data.length > 0) {
  var keys = Object.keys(data[0]);
  for (i in data) {
    var values = keys.map(function(key){ return data[i][key]});
    sheet.appendRow(values);
  }
}

Bit simplistic, but works in our case, and more importantly, successfully executes!

ji...@mccormick-services.com <ji...@mccormick-services.com> #229Dec 11, 2020 09:30PM

I agree with everyone else. I am seeing a 100% failure rate when using UrlFetchApp.fetch to fetch a CSV file. This is a serious bug that is causing serious pain to many companies and individuals. Google apparently agrees that it is serious since it is marked with a priority of P1 and a severity of S1.

Google, it would help you and us a lot if you publicized and executed a communication plan for your highest priority and severity bugs. Without communication, everyone is left to guess, and the vacuum is filled with confusion, anger, and suspicion. If you want businesses to trust you, communication is key. Make it so.

[Deleted User] <[Deleted User]> #230Dec 11, 2020 09:31PM

Hey Guys
I thik I found two possible solutions
the first is very simple:
previously there was a bug that needed a space after Bearer for the response to work:

'Authorization': 'Bearer ' + ScriptApp.getOAuthToken() //Bug was here needed a space after Bearer

if you delete the space it works just fine:

'Authorization': 'Bearer ' + ScriptApp.getOAuthToken()

the other solution is to getValues from the range you want to export to csv and then join it
like this

var vals = range.getValues();
var csvString = vals.join("\n");
var csv = DriveApp.createFile("mycsv.csv", csvString);

both solutions are working for me
hope it helps

ke...@telus.com <ke...@telus.com> #231Dec 11, 2020 09:36PM

+1. Please fix this ASAP as this is disrupting our business. I can also confirm that this error specifically happens when calling UrlFetchApp.fetch() on CSV files.

el...@gmail.com <el...@gmail.com> #232Dec 11, 2020 09:46PM

Same issue on CSV files..

jo...@titechllc.com <jo...@titechllc.com> #233Dec 11, 2020 10:00PM

+1. Major disruption to our ability to process a data feed that we've been able to use all year without problems. UrlFetchApp.fetch() returns "Unexpected error" within a second or two, pretty much right away.

yz...@gmail.com <yz...@gmail.com> #234Dec 11, 2020 10:17PM

experience this issue lately in the past few days for downloading CSV files

ma...@verneide.com <ma...@verneide.com> #235Dec 11, 2020 10:22PM

We started experiencing a bunch of errors this week with the UrlFetchApp.fetch() as well, thought maybe it was something on our server implemented a while..try...catch with it attempting to try it 3 times with a 5 sec sleep in between but been trying all afternoon and cannot get it to work. Keep getting an Exception on the URL.

na...@nathaniel-allen.com <na...@nathaniel-allen.com> #236Dec 11, 2020 10:38PM

In my testing this is related to fetching CSV data.
If you are able to change your data to JSON or TXT (tab delimited) the UrlFetchApp.fetch() should work.
TXT (tab delimited) was the easiest bandaid for me because it is plug and play with Utilities.parseCsv(csvString, '\t');
Good luck 👍

ac...@gmail.com <ac...@gmail.com> #237Dec 11, 2020 10:53PM

Same issue here, can download the CSV file when I hit the Url directly but have issues when using google script.

be...@gmail.com <be...@gmail.com> #238Dec 11, 2020 11:07PM

Same as for everyone. Functions using UrlFetchApp.fetch(csvUrl).getContentText() / Utilities.parseCsv(csvContent) are not working.
I managed to have some switched to json but for some I cannot since source is only csv :/

be...@titechllc.com <be...@titechllc.com> #239Dec 11, 2020 11:54PM

Facing the same issue every hour when the schedule runs. Even when I try to run manually, it returns the error and does not process.

pe...@broadcom.com <pe...@broadcom.com> #240Dec 12, 2020 01:18AM

Same issue here, consistently when using UrlFetchApp.fetch() with GET to read a .csv file, as well as with a POST to write a .csv file. Our build process is broken until this is fixed.

Is there a workaround until this is fixed?

Message last modified on Dec 12, 2020 01:19AM

jh...@gmail.com <jh...@gmail.com> #241Dec 12, 2020 02:35AM

Same issue here.
When I fetch

maps.google.com URL I have no problemi. But

facebook.com it doesn't work nor throw error.

br...@gmail.com <br...@gmail.com> #242Dec 12, 2020 03:22AM

Same here and many other friends

es...@gmail.com <es...@gmail.com> #243Dec 12, 2020 03:37AM

Please google Fix this issue

ASAP

is...@stemo.hu <is...@stemo.hu> #244Dec 12, 2020 04:35AM

Same here. Please fix it ASAP!

ja...@gmail.com <ja...@gmail.com> #245Dec 12, 2020 08:33AM

please fix

wh...@gmail.com <wh...@gmail.com> #246Dec 12, 2020 09:38AM

error screen shot attached

code:

var params = {muteHttpExceptions:true}; var ARKKcsv = UrlFetchApp.fetch(ARKKurl,params).getContentText();

Please fix, this is serious

Capture.PNG

55 KB

View

Download

an...@gmail.com <an...@gmail.com> #247Dec 12, 2020 09:56AM

Unexpected error:

https://storage.googleapis.com/dfp-report-export/0833a932-61ff-4835-8b7d-01c6bcc61222?GoogleAccessId=376921769015-q0sqoemp6u2bu3hopfa7husqdb5dvi8g@developer.gserviceaccount.com&Expires=1607767280&Signature=C2V4ws671m4DPyxGNVv6pe8oGJE9jZv5jPF0NTw9wzLsrGe0nwZCfiB57KKYZQr6EDacTQ8Ph7BeFz3JryA2rezKsQ%2Fvu7e5rrSdjmS%2F5jGgoDUU6sOuigTMrhal5BqW2hyZEPBlOHfQn0F0gTy5Xp2F0PKJEogYZYV1rEE8xAS292Zx38r1XZWbyJUaDJFBZBj1BKIZez4g%...

Message last modified on Dec 12, 2020 09:57AM

Sat Dec 12 2020 10:56:38 GMT+0100 (Central European Standard Time).png

49 KB

View

Download

da...@gamekit.com <da...@gamekit.com> #248Dec 12, 2020 10:37AM

The same here

issue.png

3.9 KB

View

Download

an...@healthify.co <an...@healthify.co> #249Dec 12, 2020 10:49AM

@google Please solve this issue ASAP, Its causing a lot of disruption on company internal functioning.

je...@farmurban.co.uk <je...@farmurban.co.uk> #250Dec 12, 2020 11:11AM

Please fix asap - this is breaking our internal systems.

na...@gmail.com <na...@gmail.com> #251Dec 12, 2020 11:30AM

Same here!

ge...@gmail.com <ge...@gmail.com> #252Dec 12, 2020 12:34PM

I'm also with this issue . Please fix this issue ASAP.

jo...@gmail.com <jo...@gmail.com> #253Dec 12, 2020 12:36PM

Same here, our entire company is affected and is breaking our internal systems as well

gp...@gmail.com <gp...@gmail.com> #254Dec 12, 2020 01:47PM

I have the issue, too.

ko...@gmail.com <ko...@gmail.com> #255Dec 12, 2020 02:11PM

in...@gmail.com <in...@gmail.com> #256Dec 12, 2020 02:54PM

same issue

gr...@googlemail.com <gr...@googlemail.com> #257Dec 12, 2020 03:59PM

#230 clearing of the space after Bearer worked for me...so I thought...a download is completed but it looks just like the website with whole html code itself...

Message last modified on Dec 12, 2020 04:01PM

sa...@gmail.com <sa...@gmail.com> #258Dec 12, 2020 03:59PM

I am also affected by this

to...@brainjocks.com <to...@brainjocks.com> #259Dec 12, 2020 04:10PM

Same for me - specifically for downloading a CSV. It works for regular API calls. The Download URL works fine outside Google env, when used in Postman to test

This is a huge blocker to running my daily business processes

Is there an ETA for resolving this?

Message last modified on Dec 12, 2020 04:11PM

br...@gmail.com <br...@gmail.com> #260Dec 12, 2020 05:34PM

can we get confirmation this is being looked at please

to...@brainjocks.com <to...@brainjocks.com> #261Dec 12, 2020 05:52PM

Please confirm this is being advanced/resolved over the weekend and you're not waiting til Monday

bo...@cwi.nl <bo...@cwi.nl> #262Dec 12, 2020 06:32PM

google still asleep at the wheel on this one

ad...@webdatahub.com <ad...@webdatahub.com> #263Dec 12, 2020 07:27PM

Dear Googlers,

This is a critical blocker. We need fix ASAP. Please revert the changes causing this issue.

[Deleted User] <[Deleted User]> #264Dec 12, 2020 08:24PM

Same for me. Getting same "Unexpected error" when trying to retrieve CSV file. My records show my scripts using "UrlFetchApp.fetch" all started failing Nov 10, 2020 @ 12:00pm MST.

Please fix asap!!

jr...@gmail.com <jr...@gmail.com> #265Dec 12, 2020 08:31PM

Same here. Huge issue for multiple clients, losing tens of thousands of dollars and redevelopment time.

ha...@gmail.com <ha...@gmail.com> #266Dec 12, 2020 08:46PM

This blocks my Sheets addon "Schedule & Send Emails" which exports and sends spreadsheets. CSV export is not working at all!

st...@gmail.com <st...@gmail.com> #267Dec 13, 2020 12:29AM

My script ran without issues for more than two weeks, but suddenly, it stopped working.

ya...@fwrbrands.com.au <ya...@fwrbrands.com.au> #268Dec 13, 2020 01:33AM

guys, i've found work around for this
remove .csv from your filename (you'll have to remove filename on your file source first)
should be ok until google fix it
cause it's been 3days and it's still error

var csvUrl = "https://yourwebsite.com/pathtocsv/importfile.csv";
var csvContent = UrlFetchApp.fetch(csvUrl).getContentText();

change it to

var csvUrl = "https://yourwebsite.com/pathtocsv/importfile";
var csvContent = UrlFetchApp.fetch(csvUrl).getContentText();

to...@brainjocks.com <to...@brainjocks.com> #269Dec 13, 2020 04:58AM

Please roll back

How did this get thru your QA before deployment?

na...@gmail.com <na...@gmail.com> #270Dec 13, 2020 08:33AM

As ridiculous as it sounds, removing the extension from the files did the trick for us. Thank you #268!

I guess Google's code is having trouble dealing with the mime type.

ba...@gmail.com <ba...@gmail.com> #271Dec 13, 2020 09:55AM

#268
Any workaround suggestions for an URL like this:

https://www.website.com/?q=thinks&download=csv
In this case I can't remove &download=csv because this actually tells the server to generate and return a csv file.

na...@gmail.com <na...@gmail.com> #272Dec 13, 2020 10:11AM

I guess the problem is not the extension (or the end of the URL in your case), but the mime-type that the server (in you case

www.website.com) is returning.

In my case, I understand that removing the extension from the file name makes the webserver stop identifying the mime-type as CSV. If you control the server side, you could try to not setting the mime-type to CSV when creating the response.

da...@gmail.com <da...@gmail.com> #273Dec 13, 2020 10:30AM

Pulling data from a 3rd-party site I do not control, so don't have some of the options for changing file name requested.
@Google I am surprised at your carelessness here. I blamed the 3rd party first instead of you. ETA to fix? Going on 5 days of issues now - for a while the problem was intermittent now it is 100% bad. Maybe it's time to port back to Microsoft apps.

[Deleted User] <[Deleted User]> #274Dec 13, 2020 12:40PM

ki...@turtleos.com <ki...@turtleos.com> #275Dec 13, 2020 01:10PM

I had to switch one of our scripts to fetch the data in .json and it works fine.

In case it could be helpful for anyone, this is the only code (except the link with .json in the end) I had to change:

before:
const freshData = Utilities.parseCsv(response, ',');

after:
let freshData = JSON.parse(response).values;
freshData.unshift(JSON.parse(response).fields);

The result is a 2D array that can be pasted to any sheet using setValues();

to...@brainjocks.com <to...@brainjocks.com> #276Dec 13, 2020 01:32PM

Please revert!!!!

al...@gadgetrecycling.ltd <al...@gadgetrecycling.ltd> #277Dec 13, 2020 02:23PM

We're also experiencing this issue when calling UrlFetchApp.fetch()

ma...@toofast.com <ma...@toofast.com> #278Dec 13, 2020 03:51PM

I have the same issue with the Schedule & Send Emails Addon

as...@gmail.com <as...@gmail.com> #279Dec 13, 2020 05:15PM

fix plz.

mr...@woolworths.com.au <mr...@woolworths.com.au> #280Dec 13, 2020 07:04PM

ti...@twofutures.co <ti...@twofutures.co> #281Dec 13, 2020 07:22PM

Here's a quick writeup on how we worked around this issue with a Cloudflare Worker:

https://twofutures.co/articles/how-to-work-around-unexpected-error-urlfetchapp

ad...@webdatahub.com <ad...@webdatahub.com> #282Dec 13, 2020 07:56PM

The workaround is changing content type response header from "text/csv" to "text/plain"

an...@phdmedia.com <an...@phdmedia.com> #283Dec 14, 2020 12:34AM

I have the same issue @googleTeam please fix it

bi...@ethirteen.com <bi...@ethirteen.com> #284Dec 14, 2020 02:14AM

Same issue from my side, affected since last week, maybe 12/11

ni...@redhat.com <ni...@redhat.com> #285Dec 14, 2020 02:31AM

same error: TypeError: Cannot find function close in object HtmlOutput.

br...@gmail.com <br...@gmail.com> #286Dec 14, 2020 02:32AM

whats the top workarounds now?

jj...@gmail.com <jj...@gmail.com> #287Dec 14, 2020 02:32AM

I have had this error since 12/11

ch...@prosperops.com <ch...@prosperops.com> #288Dec 14, 2020 04:04AM

Removing the csv file extension and changing the MIME type of the files we are downloading to "text/plain" fully resolved the issue for us as well.

[Deleted User] <[Deleted User]> #289Dec 14, 2020 07:38AM

Comment #288

works for us.

Message last modified on Dec 14, 2020 07:38AM

ma...@gmail.com <ma...@gmail.com> #290Dec 14, 2020 08:45AM

Same issue with Add-On „Schedule & Send Emails in Spreadsheets“. Please resolve!

la...@agapio.eu <la...@agapio.eu> #291Dec 14, 2020 08:48AM

I've migrated my scripts to retrieve another format (json) rather than csv in the meantime...

ke...@groupm.com <ke...@groupm.com> #292Dec 14, 2020 09:24AM

Nope, I can confirm that

Comment #288

doesn't help in this case.

var httpOptions = {
'headers': {'Authorization': 'Bearer ' + ScriptApp.getOAuthToken()}
}

var contents = UrlFetchApp.fetch(apiUrl, httpOptions).getContentText();

Where api url is Google's redirect url for csv file from the

https://www.googleapis.com/dfareporting/v3.4/reports API service.

Still returns the same error:

{
"error": {
"code": 401,
"message": "Request is missing required authentication credential. Expected OAuth 2 access token, login cookie or other valid authentication credential. See

https://developers.google.com/identity/sign-in/web/devconsole-project.",
"errors": [
{
"message": "Login Required.",
"domain": "global",
"reason": "required",
"location": "Authorization",
"locationType": "header"
}
],
"status": "UNAUTHENTICATED"
}
}

ni...@gmail.com <ni...@gmail.com> #293Dec 14, 2020 09:29AM

Any ETA on this issue ? :((

[Deleted User] <[Deleted User]> #294Dec 14, 2020 10:11AM

its been nearly a week already, hope everything gets fixed soon

yo...@gmail.com <yo...@gmail.com> #295Dec 14, 2020 10:12AM

also experiencing this since december 12 with content-type JSON

[Deleted User] <[Deleted User]> #296Dec 14, 2020 10:27AM

Tried revoking OAuth and re-authorizing, no change at all. How did something so basic get completely broken for days now?

[Deleted User] <[Deleted User]> #297Dec 14, 2020 10:43AM

Disable Chrome V8 Runtime Engine until Google fix this.

To disable:
From Menu click on Run > Disable new Apps Script runtime powered by Chrome V8

al...@rentokil-initial.com <al...@rentokil-initial.com> #298Dec 14, 2020 10:43AM

It seems this is not random, now it occurs EVERY TIME i try to access to files stored on AmazonAWS.
They work if accessed from Chrome even in private browsing (so no authenication is required).

It is about 4 days for me.

regards

[Deleted User] <[Deleted User]> #299Dec 14, 2020 10:49AM

same issue here

dr...@gmail.com <dr...@gmail.com> #300Dec 14, 2020 10:53AM

Same problem with CSV. Works fine with TSV. Hoping for solution soon.

st...@gmail.com <st...@gmail.com> #301Dec 14, 2020 11:11AM

Can you please update us all with a time line! This issue is impacting my work!

ba...@gmail.com <ba...@gmail.com> #302Dec 14, 2020 12:38PM

#297
That doesn't work for me. Does this work for others?

al...@gadgetrecycling.ltd <al...@gadgetrecycling.ltd> #303Dec 14, 2020 12:41PM

#297
Did not work for me

[Deleted User] <[Deleted User]> #304Dec 14, 2020 12:57PM

ip...@gmail.com <ip...@gmail.com> #305Dec 14, 2020 01:23PM

+1 Any idea when that will be solved ?

[Deleted User] <[Deleted User]> #306Dec 14, 2020 01:30PM

ni...@win-win-sports.com <ni...@win-win-sports.com> #307Dec 14, 2020 01:38PM

al...@anewspring.nl <al...@anewspring.nl> #308Dec 14, 2020 01:52PM

Same issue here. Seems to have started happening on 11 Dec for me, unfortunately the workaround with a PHP server is not an option for us.
We have a payed G Suite subscription and we use this for business processes.
Google, please solve this issue soon!

ma...@gmail.com <ma...@gmail.com> #309Dec 14, 2020 02:11PM

Hi all,

In my case, I'm using UrlFetchApp.fetch to generate a .csv file to send it be email to be used by our system.

I tried changing the exported file extension from csv to tsv :

var url = "

https://docs.google.com/spreadsheets/d/"+ ssID + "/export?format=csv&id="+ssID+"&gid="+shID;

To

var url = "

https://docs.google.com/spreadsheets/d/"+ ssID + "/export?format=tsv&id="+ssID+"&gid="+shID;

Then sending the file as .csv since our system only receives csv.

MailApp.sendEmail(email_ID,subject ,body, {attachments:[{fileName:"XXXXXXX"+".csv", content:contents, mimeType:"application//csv"}]});

Worked for me.

gf...@toverteam.nl <gf...@toverteam.nl> #310Dec 14, 2020 02:18PM

em...@travisperkins.co.uk <em...@travisperkins.co.uk> #311Dec 14, 2020 02:28PM

This is happening for all my scripts which export to CSV also. TSV or Excel seem to work fine but that's not an ideal workaround.

Any advice on expected resolution times would be great.

[Deleted User] <[Deleted User]> #312Dec 14, 2020 02:39PM

st...@gmail.com <st...@gmail.com> #313Dec 14, 2020 02:40PM

to...@brainjocks.com <to...@brainjocks.com> #314Dec 14, 2020 02:40PM

Please, can someone update us on an ETA? Please revert back to a stable version.

This is a PRODUCTION blocker

ri...@homechef.com <ri...@homechef.com> #315Dec 14, 2020 02:41PM

Google what does it mean this issue is blocked by 175298790?

Can you provide an update?

If you cannot find a fix, can we have reassurance the latest release will be rolled back?

We are at a 100% failure rate.

pa...@aperam.com <pa...@aperam.com> #316Dec 14, 2020 02:52PM

mi...@gmail.com <mi...@gmail.com> #317Dec 14, 2020 02:54PM

Wow, this is a mess. Can also confirm that I've been getting this issue for almost a week now.

pa...@aperam.com <pa...@aperam.com> #318Dec 14, 2020 02:57PM

I've been trying to fix this error for a week and I can't. What can I do?

jp...@gmail.com <jp...@gmail.com> #319Dec 14, 2020 03:00PM

same for me since Dec 11.... I tried a workaround by using basic authentication... but the result is not yet a CSV file... I don't have yet a working solution ! :(

Message last modified on Dec 14, 2020 03:26PM

lo...@hagergroup.com <lo...@hagergroup.com> #320Dec 14, 2020 03:14PM

Impossible to get the query returning anything on Datastudio using a 3rd party connector to an external website. While using an online API tester, the result is the expected one.

@Google, When can we expect to have a date for this issue to be solved?

st...@districttaco.com <st...@districttaco.com> #321Dec 14, 2020 03:27PM

Similar issue pulling csv file via UrlFetchApp.

st...@gmail.com <st...@gmail.com> #322Dec 14, 2020 03:51PM

So,Mr Google, when are you going to fix this_ It's seriously impacting my productivity

an...@gmail.com <an...@gmail.com> #323Dec 14, 2020 04:10PM

Also having this issue pulling a csv file via UrlFetchApp

[Deleted User] <[Deleted User]> #324Dec 14, 2020 04:17PM

As a paid GSuite user, I logged a support case and also Starred this bug which I think is the most impactful action we have. Does adding a comment only confirming you see it or '+1' add any more weight to this P1/S1 issue?
I wish Google would give us an update or ETA though. Very frustrating.

an...@sae.edu.au <an...@sae.edu.au> #325Dec 14, 2020 04:28PM

What the hell is going on at Google? After today's mass outage of systems clearly they have bigger problems to deal with, but for me, this issue is a complete show stopper.

Currently, every 15 minutes or so I have to manually import a 3rd party CSV file to another server where I can remove the .CSV file extension, and then redirect all my scripts to look at that file just to keep my company's systems alive on life support.

I feel like a fool for using Google Apps Script at all now, stupid me just assumed that support for it would have been included in the G Suite SLA. If this isn't fixed in the next day or so my only alternative will be to rebuild and recode from the ground up, and you can bet your ass I won't use a single Google service in the process.

If anyone knows of some software, or has a script that can automatically authenticate to a website and download a .CSV file I'd be very grateful if you shared it here.

mi...@googlemail.com <mi...@googlemail.com> #326Dec 14, 2020 04:28PM

I can confirm #297. After switching back from v8 to Rhino (including porting back the code and closing the editor window) it works.

to...@brainjocks.com <to...@brainjocks.com> #327Dec 14, 2020 04:30PM

Please, can someone update us on an ETA?

ha...@gmail.com <ha...@gmail.com> #328Dec 14, 2020 04:33PM

@ #326

I never used V8 and it still doesn't work.

to...@brainjocks.com <to...@brainjocks.com> #329Dec 14, 2020 04:56PM

I posted to our GSuite support team (paid account) and got the following - this is an excerpt from the complete chat conversation:

Google Workspace Support, Luis11:52 AM
Thanks, Tommy. The information given by the developers and the engineers is that the fix is already propagating, it is just a matter of two hours that you can have the issue fixed (however, it can take less). What they mention is that I can send them in the form your domain, so they push the fix quicker to your domain.

bl...@gmail.com <bl...@gmail.com> #330Dec 14, 2020 04:57PM

Re: #297 #326

I also tried switching back to Rhino and this did appear to temporarily help some of my scripts interacting with Google Sheets. However, they still fail most of the time, but using Rhino every so often one of them seems to run okay and actually fetches the CSV file correctly (why? how? there doesn't appear to be any consistency or logic to predict successful executions over the failures).

Unfortunately for scripts interacting with Google Docs, neither Rhino or V8 seem to allow the fetching of .CSV files at all :(

All these scripts have been running perfectly well for 3+ years, they must have handled hundreds of thousands of requests over that time. I need to know what broke and why? Throwing an "Unexpected error" is not enough information for me to troubleshoot anything!

an...@sae.edu.au <an...@sae.edu.au> #331Dec 14, 2020 05:03PM

Re: #329

Awesome, I will get our G Suite admin on this asap.
Can you please post an update here if they actually fix this issue for you!

[Deleted User] <[Deleted User]> #332Dec 14, 2020 05:14PM

Looks like the fix is in. I am now able to run the script with no issues. Thank you!

[Deleted User] <[Deleted User]> #333Dec 14, 2020 05:16PM

Confirmed fixed on my end

On Mon, Dec 14, 2020 at 11:14 AM <buganizer-system@google.com> wrote:

- Show quoted text -

--
<

http://www.arch-fab.com/>
2100 E Richmond Ave.
Fort Worth, TX 76104

Arch-Fab.com <

http://www.arch-fab.com/>
*Jarod McCarty*
Scheduling Coordinator
O: 817.926.7270 Ext 140
C: 417.576.6694
E: jarod.mccarty@arch-fab.com <jacob.sunderbruch@arch-fab.com>

<

https://www.linkedin.com/company/architectural-fabrication>
<

https://www.facebook.com/ArchitecturalFabricationInc/>
<

https://twitter.com/Arch_Fab_Inc>

ko...@uber.com <ko...@uber.com> #334Dec 14, 2020 05:26PM

Nothing on my end yet

ph...@philsebastian.com <ph...@philsebastian.com> #335Dec 14, 2020 05:35PM

Hi Everyone, until this issue is fixed, I highly recommend you implement the workaround posted by:

https://issuetracker.google.com/issues/175141974#comment45

Message last modified on Dec 14, 2020 05:37PM

ad...@districttaco.com <ad...@districttaco.com> #336Dec 14, 2020 06:03PM

Same Issue here. Still not working in apps script calling UrlFetchApp with ".csv" in the url

aa...@gmail.com <aa...@gmail.com> #337Dec 14, 2020 06:48PM

Ditto, same problem when fetching CSVs with UrlFetchApp.fetch()

pe...@gmail.com <pe...@gmail.com> #338Dec 14, 2020 07:17PM

Some users above is reporting that the problem is fixed, but is that only for some users/premium customers? I still see the same issue as previously.

jh...@gmail.com <jh...@gmail.com> #339Dec 14, 2020 07:18PM

Hello everyone

is this issue FIX?
Please Confirm

Best Regards

pr...@gmail.com <pr...@gmail.com> #340Dec 14, 2020 07:21PM

For me UrlFetchApp seems to be working but sparingly. Sometimes its working and sometimes not.

fr...@royaltechnologies.com <fr...@royaltechnologies.com> #341Dec 14, 2020 07:25PM

Still not working for us.

fr...@it-development.com <fr...@it-development.com> #342Dec 14, 2020 08:15PM

not working for us 99% of the time (runs every 15 minutes)

ti...@gmail.com <ti...@gmail.com> #343Dec 14, 2020 08:31PM

Full functionality seems to be restored for us at the moment. That was painful, though.

jo...@scotts.com <jo...@scotts.com> #344Dec 14, 2020 08:35PM

Still 100% failure rate here.

pe...@broadcom.com <pe...@broadcom.com> #345Dec 14, 2020 08:55PM

Not fixed for us, UrlFetchApp.fetch() still fails to GET or POST a CSV body.

[Deleted User] <[Deleted User]> #346Dec 14, 2020 09:03PM

hey guys
I have found a possible solution that is working for me
try inputting empty {} like this

UrlFetchApp.fetch(apiLink, {});

it worked for me

ma...@ousedale.org.uk <ma...@ousedale.org.uk> #347Dec 14, 2020 09:13PM

It is working for me now on the Old runtime but not on V8

fr...@gmail.com <fr...@gmail.com> #348Dec 14, 2020 09:21PM

In the V8 execution model it still doesn't work, but in the old model it is fully functional.

al...@rentokil-initial.com <al...@rentokil-initial.com> #349Dec 14, 2020 09:35PM

Hi,

I confirm that if you disable the V8 runtime the UrlFetchApp is working...

Regards

jo...@scotts.com <jo...@scotts.com> #350Dec 14, 2020 09:43PM

Confirmed - disabling v8 is now successful as a workaround (it previously failed as well).

pe...@gmail.com <pe...@gmail.com> #351Dec 14, 2020 09:49PM

Can confirm, in the legacy version it works for me as well now

sc...@cru.org <sc...@cru.org> #352Dec 14, 2020 09:51PM

Confirming disabling v8 fixed it for me. In the new script editor, from the Script Project Settings, make sure Enable Chrome V8 runtime is unchecked.

fr...@royaltechnologies.com <fr...@royaltechnologies.com> #353Dec 14, 2020 10:05PM

I just ran one of our scripts with the V8 runtime enabled and it finished for the first time in about a week.

ko...@uber.com <ko...@uber.com> #354Dec 14, 2020 10:08PM

Disabled V8 and it worked for me as well!

You can find the settings under Run if you're still in the legacy editor.

https://developers.google.com/apps-script/guides/v8-runtime#enabling_the_v8_runtime

[Deleted User] <[Deleted User]> #355Dec 14, 2020 11:35PM

Confirmed. Disabling V8 fixed our issue. Thanks to whomever figured this out!

Tr...@logicalposition.com <Tr...@logicalposition.com> #356Dec 15, 2020 12:07AM

With no changes (I do not currently have V8 enabled on any sheet), these requests stopped erroring around noon Pacific time today.

[Deleted User] <[Deleted User]> #357Dec 15, 2020 01:56AM

I disabled runtime Chrome V8 and now my script is running with no issues.

[Deleted User] <[Deleted User]> #358Dec 15, 2020 01:56AM

I tried #297 #326 to disable V8 too, it works for me so far!

br...@gmail.com <br...@gmail.com> #359Dec 15, 2020 02:07AM

Some of mine work with V8 disabled, but roughly half still get the error even with the legacy version.

fr...@gmail.com <fr...@gmail.com> #360Dec 15, 2020 03:38AM

Hi guys today work for my if disable V8

az...@gmail.com <az...@gmail.com> #361Dec 15, 2020 04:06AM

It started working today.

an...@sae.edu.au <an...@sae.edu.au> #362Dec 15, 2020 04:31AM

Working again here too, using Rhino, too scared to turn V8 on yet.

az...@gmail.com <az...@gmail.com> #363Dec 15, 2020 04:44AM

Its works only when with V8 disabled.

ma...@nordcloud.com <ma...@nordcloud.com> #364Dec 15, 2020 07:12AM

Hi, can also confirm,
UrlFetchApp.fetch(apiLink, {}); is working for me without any other changes to the code.

ni...@gmail.com <ni...@gmail.com> #365Dec 15, 2020 08:40AM

It's working again on our side, with errors happening sometimes

[Deleted User] <[Deleted User]> #366Dec 15, 2020 09:19AM

When I disabled runtime V8,
I got an error 'Service Spreadsheets failed while accessing document with id xxx' at moveActiveSheet(1).

al...@gadgetrecycling.ltd <al...@gadgetrecycling.ltd> #367Dec 15, 2020 11:32AM

Working for us with V8 disabled

mi...@googlemail.com <mi...@googlemail.com> #368Dec 15, 2020 12:25PM

Can confirm for me it's again working with V8

st...@gmail.com <st...@gmail.com> #369Dec 15, 2020 12:57PM

Working better now on v8 but not everytime

al...@datarevolt.agency <al...@datarevolt.agency> #370Dec 15, 2020 12:57PM

Working for us with V8.

si...@tmx.com <si...@tmx.com> #371Dec 15, 2020 12:59PM

it's working again even without disable runtime V8

si...@tmx.com <si...@tmx.com> #372Dec 15, 2020 01:20PM

actually, it still failed when the script is run by the trigger

pu...@gmail.com <pu...@gmail.com> #373Dec 15, 2020 05:00PM

IMPORTDATA() in google sheets also working again for us for the past 3 hours.

nf...@clustermarket.com <nf...@clustermarket.com> #374Dec 15, 2020 05:30PM

IMPORTDATA() is still not working for us. Still the same error: Could not fetch URL across all sheets.

da...@ask.com <da...@ask.com> #375Dec 15, 2020 07:05PM

importXML() is still not working for us. Throwing error: Could not fetch url

ga...@masabi.com <ga...@masabi.com> #376Dec 15, 2020 10:49PM

Same here. All api integrations we use which require basic auth getting error.

ja...@google.com <ja...@google.com> #377Dec 16, 2020 08:33AM

Hello!

A fix has rolled out. It should work for most of the users, but it might take some time to propagate to everyone.

Please let us know if you still experience this issue. If you do, make sure you are using the V8 runtime.

Thank you!

ra...@google.com <ra...@google.com> Dec 16, 2020 09:17AM

Marked as fixed.

nf...@clustermarket.com <nf...@clustermarket.com> #378Dec 16, 2020 09:24AM

Hi there,

=importdata() is still not working. A fix was promised 3 times now, always saying it will work within the next 24 hours. Still broken after 4 days.

ro...@gmail.com <ro...@gmail.com> #379Dec 16, 2020 03:03PM

Please let us know if you still experience this issue. If you do, make sure you are using the V8 runtime.

The V8 runtime has a large list of issues reported on this IssueTracker (https://issuetracker.google.com/issues?q=componentid:191640%20status:open%20V8%20runtime), that is preventing many users from migrating to it.

Until those issues are also resolved, we please ask that fixes are not contingent on using a specific runtime.

Specifically, we cannot migrate our applications to V8 due to our reliance on Time Based triggers which are not returned by ScriptApp.getUserTriggers(form) when using the V8 runtime (reported in this issue https://issuetracker.google.com/issues/149937798).

Message last modified on Dec 16, 2020 03:04PM

ji...@jimesteban.com <ji...@jimesteban.com> #380Dec 16, 2020 07:11PM

I understand that you have rolled out a solution. Just wanted to let you know that I'm still seeing this problem in only one file. It's giving me the error:Exception: Unexpected error while getting the method or property getContacts on object ContactsApp. (line 2, file "ag1") and the line of code is `var contactsA=ContactsApp.getContacts();A detailed explanation is available here on StackOverFlow.com It's a cloud platform project.

ji...@jimesteban.com <ji...@jimesteban.com> #381Dec 17, 2020 05:47PM

I'm sorry my recent comment was an issue that is unrelated to this problem. I was told that under the hood ContactApp.getContacts() utilized UrlFetch so we thought it was related but the problem was that I need to enable the Contacts API in the Cloud Project. So sorry for the mixup.

[Deleted User] <[Deleted User]> #382Dec 20, 2020 11:34PM

fi...@gmail.com <fi...@gmail.com> #383Dec 30, 2020 04:54PM

This stopped working for me on 27/12/2020 at 00.00. Any of the suggestions above dont work

fi...@gmail.com <fi...@gmail.com> #384Dec 30, 2020 05:02PM

Looks like my problem is a different one

Utilities.formatDate(new Date(), 'Europe/Dublin', 'YYYY-MM-0d')

returns

2021-12-030

Note 2021 instead of 2020

fi...@gmail.com <fi...@gmail.com> #385Dec 30, 2020 05:19PM

From

https://issuetracker.google.com/issues/175893289 it looks like intended behaviour

Apologies for distraction

cl...@gmail.com <cl...@gmail.com> #386Jan 12, 2021 12:38PM

First time I've used any fault reporting/tracking with Google - it appears to have been fixed but it's broken in the last few days for me! My script isnt used a lot at the moment and it last ran on 6th Jan but failed each time it was called today.

URL is called but header info doesnt appear to be being passed.

ca...@gmail.com <ca...@gmail.com> #387Feb 2, 2021 06:58PM

Fixed yet?

ma...@gmail.com <ma...@gmail.com> #388Aug 12, 2021 08:29AM

It's not fixed. As for August 2021 the error still occurs when using UrlFetch

[Deleted User] <[Deleted User]> #389Aug 12, 2021 08:30AM

Comment has been deleted.

Message last modified on Aug 12, 2021 05:13PM

qu...@gmail.com <qu...@gmail.com> #390Aug 25, 2021 02:35PM

ga...@google.com <ga...@google.com> Aug 26, 2021 08:05AM

Verified by ga...@google.com.

Issue 175141974

Description

Issue summary

Comments

al...@xappex.com <al...@xappex.com> #2Dec 9, 2020 01:58PM

al...@xappex.com <al...@xappex.com> #3Dec 9, 2020 01:58PM

ka...@kobler.no <ka...@kobler.no> #4Dec 9, 2020 02:18PM

na...@gmail.com <na...@gmail.com> #5Dec 9, 2020 02:56PM

ab...@brunswicknews.com <ab...@brunswicknews.com> #6Dec 9, 2020 03:18PM

[Deleted User] <[Deleted User]> #7Dec 9, 2020 03:19PM

ch...@telenetwork.com <ch...@telenetwork.com> #8Dec 9, 2020 03:35PM

mf...@redgobo.com <mf...@redgobo.com> #9Dec 9, 2020 03:41PM

jo...@elementum.com <jo...@elementum.com> #10Dec 9, 2020 03:42PM

sh...@leenergy.com <sh...@leenergy.com> #11Dec 9, 2020 03:45PM

mi...@futurezone.at <mi...@futurezone.at> #12Dec 9, 2020 03:46PM

ro...@avalon.au <ro...@avalon.au> #13Dec 9, 2020 03:55PM

ma...@sleeb.co.uk <ma...@sleeb.co.uk> #14Dec 9, 2020 04:03PM

dy...@homechef.com <dy...@homechef.com> #15Dec 9, 2020 04:06PM

pe...@gmail.com <pe...@gmail.com> #16Dec 9, 2020 04:16PM

rh...@letsgetready.org <rh...@letsgetready.org> #17Dec 9, 2020 04:23PM

pa...@fazwaz.com <pa...@fazwaz.com> #18Dec 9, 2020 04:25PM

a....@pyrexx.com <a....@pyrexx.com> #19Dec 9, 2020 04:33PM

[Deleted User] <[Deleted User]> #20Dec 9, 2020 04:56PM

[Deleted User] <[Deleted User]> #21Dec 9, 2020 05:00PM

[Deleted User] <[Deleted User]> #22Dec 9, 2020 05:01PM

je...@logicgate.com <je...@logicgate.com> #23Dec 9, 2020 05:02PM

[Deleted User] <[Deleted User]> #24Dec 9, 2020 05:09PM

[Deleted User] <[Deleted User]> #25Dec 9, 2020 05:16PM

[Deleted User] <[Deleted User]> #26Dec 9, 2020 05:17PM

[Deleted User] <[Deleted User]> #27Dec 9, 2020 05:52PM

sb...@remaxintegra.com <sb...@remaxintegra.com> #28Dec 9, 2020 06:20PM

sb...@remaxintegra.com <sb...@remaxintegra.com> #29Dec 9, 2020 06:20PM

sh...@leenergy.com <sh...@leenergy.com> #30Dec 9, 2020 07:11PM

jf...@softerware.com <jf...@softerware.com> #31Dec 9, 2020 07:21PM

pu...@gmail.com <pu...@gmail.com> #32Dec 9, 2020 07:28PM

sh...@caincentives.com <sh...@caincentives.com> #33Dec 9, 2020 08:03PM

rs...@gmail.com <rs...@gmail.com> #34Dec 9, 2020 08:15PM

sp...@stjosephhowell.org <sp...@stjosephhowell.org> #35Dec 9, 2020 08:36PM

rs...@gmail.com <rs...@gmail.com> #36Dec 9, 2020 08:37PM

[Deleted User] <[Deleted User]> #37Dec 9, 2020 08:42PM

[Deleted User] <[Deleted User]> #38Dec 9, 2020 08:47PM

di...@gmail.com <di...@gmail.com> #39Dec 9, 2020 08:51PM

ch...@beanbaginc.com <ch...@beanbaginc.com> #40Dec 9, 2020 09:11PM

sp...@stjosephhowell.org <sp...@stjosephhowell.org> #41Dec 9, 2020 09:22PM

ch...@beanbaginc.com <ch...@beanbaginc.com> #42Dec 9, 2020 09:25PM

ch...@beanbaginc.com <ch...@beanbaginc.com> #43Dec 9, 2020 09:34PM

ad...@sirum.org <ad...@sirum.org> #44Dec 9, 2020 09:50PM

ch...@beanbaginc.com <ch...@beanbaginc.com> #45Dec 9, 2020 10:17PM

al...@xappex.com <al...@xappex.com> #46Dec 9, 2020 10:57PM

ik...@salesforce.com <ik...@salesforce.com> #47Dec 9, 2020 11:10PM

pr...@prestonsmalley.com <pr...@prestonsmalley.com> #48Dec 9, 2020 11:32PM

iv...@alumnos.usm.cl <iv...@alumnos.usm.cl> #49Dec 10, 2020 12:38AM

ri...@homechef.com <ri...@homechef.com> #50Dec 10, 2020 02:02AM

ap...@tiltingfutures.org <ap...@tiltingfutures.org> #51Dec 10, 2020 02:27AM

vh...@gmail.com <vh...@gmail.com> #52Dec 10, 2020 04:21AM

vh...@gmail.com <vh...@gmail.com> #53Dec 10, 2020 04:21AM

go...@gmail.com <go...@gmail.com> #54Dec 10, 2020 05:58AM

ri...@gmail.com <ri...@gmail.com> #55Dec 10, 2020 07:33AM

t_...@reazon.jp <t_...@reazon.jp> #56Dec 10, 2020 07:59AM

wd...@gmail.com <wd...@gmail.com> #57Dec 10, 2020 08:03AM

ka...@rudel.jp <ka...@rudel.jp> #58Dec 10, 2020 08:05AM

[Deleted User] <[Deleted User]> #59Dec 10, 2020 08:25AM

gi...@officecoach.co.uk <gi...@officecoach.co.uk> #60Dec 10, 2020 09:20AM

hi...@c-fo.com <hi...@c-fo.com> #61Dec 10, 2020 10:11AM

jo...@google.com <jo...@google.com> #62Dec 10, 2020 10:34AM

[Deleted User] <[Deleted User]> #63Dec 10, 2020 10:40AM

gf...@bmj.com <gf...@bmj.com> #64Dec 10, 2020 11:02AM

[Deleted User] <[Deleted User]> #65Dec 10, 2020 11:02AM

ak...@mixedanalytics.com <ak...@mixedanalytics.com> #66Dec 10, 2020 11:55AM

a....@pyrexx.com <a....@pyrexx.com> #67Dec 10, 2020 12:10PM

pa...@engelska.se <pa...@engelska.se> #68Dec 10, 2020 12:43PM

al...@xappex.com <al...@xappex.com> #69Dec 10, 2020 12:55PM

si...@tmx.com <si...@tmx.com> #70Dec 10, 2020 01:03PM

ke...@redhat.com <ke...@redhat.com> #71Dec 10, 2020 01:26PM

ct...@nexamp.com <ct...@nexamp.com> #72Dec 10, 2020 01:31PM

ka...@vonage.com <ka...@vonage.com> #73Dec 10, 2020 01:31PM

al...@gmail.com <al...@gmail.com> #74Dec 10, 2020 01:33PM

sb...@remaxintegra.com <sb...@remaxintegra.com> #75Dec 10, 2020 01:42PM

ja...@zayo.com <ja...@zayo.com> #76Dec 10, 2020 01:53PM

sh...@leenergy.com <sh...@leenergy.com> #77Dec 10, 2020 01:59PM