Fixed
Status Update
No update yet.
Comments
xa...@google.com
the error happens when calling UrlFetchApp.fetch()
pa...@google.com
This happens in a published add-in
hu...@google.com
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?
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?
hu...@google.com
same for me, got same problems
[Deleted User] <[Deleted User]>
same here, got same issue - it affect all our users and not just random.
hu...@google.com
We're also experiencing this issue when calling UrlFetchApp.fetch()
Our production system is down.
jt...@temp.thunderhead.com
[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.
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.
ms...@gmail.com
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.
We confirmed that the same files are being fetched without an issue outside of AppScript.
pa...@google.com
same
hu...@google.com
Same
st...@gmail.com
Same issue here when trying to fetch public CSV files with code that worked before
im...@google.com
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
Used to work fine few days ago
st...@gmail.com
same issue
jt...@temp.thunderhead.com
hu...@google.com
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 herehttps://support.google.com/docs/thread/87544571?hl=en
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
ne...@gmail.com
Huge issue for us; all of our operations are down as a result
hu...@google.com
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( ))
var csvData = Utilities.parseCsv(UrlFetchApp.fetch('
ne...@gmail.com
same here, it seems to be also affecting direct use of ImportData inside a google sheet function
hu...@google.com
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.
Also If i Check my web server logs, It does returns response successfully.
ri...@gmail.com
Having the same issue running G-connector with Salesforce Reporting Queries
hu...@google.com
This happens for us with =IMPORTDATA() fetching cached CSVs from an application that we use. It has been happening since early on December 8th.
ri...@gmail.com
This is affecting me as well. Running into a lot of issues where we have relied on Sheets for business processes.
ri...@gmail.com
Issue with API calls (g-connector for Salesforce)
hu...@google.com
Same issue with the Salesforce G-Connector. Causing major problems for my team
em...@gmail.com
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.
hu...@google.com
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.
eb...@netflix.com
Also having the same problem when i try to refresh the reports on google sheets from salesforce
me...@thomaskeller.biz
Also having the same problem when i try to refresh the reports on google sheets from salesforce
hu...@google.com
@google any update to provide? Hard to believe this issue was reported at 7:48 AM and there has been no response yet?
hu...@google.com
The same issue with the Salesforce G-Connector still having issues with some calls. Any idea on when a fix may be determined?
Description
Example failures:
(1)
Execution failed for task ':app:kaptGenerateStubsDebugKotlin'.
> Could not resolve all files for configuration ':app:kapt'.
> Failed to transform file 'butterknife-compiler-9.0.0-SNAPSHOT.jar' to match attributes {artifactType=processed-jar} using transform JetifyTransform
> Failed to transform '...\.gradle\caches\modules-2\files-2.1\com.jakewharton\butterknife-compiler\9.0.0-SNAPSHOT\d5efd0795737d4523044335a7faa82b0e3d984c9\butterknife-compiler-9.0.0-SNAPSHOT.jar' using Jetifier.
Reason: The given artifact contains a string literal with a package reference 'android.support.v4.content' that cannot be safely rewritten. Libraries using reflection such as annotation processors need to be updated manually to add support for androidx.
(2)
Execution failed for task ':app:kaptGenerateStubsDebugKotlin'.
> Could not resolve all files for configuration ':app:kapt'.
> Failed to transform file 'jetifier-core-1.0.0-alpha10.jar' to match attributes {artifactType=processed-jar} using transform JetifyTransform
> Failed to transform '/Users/nkotula/.gradle/caches/modules-2/files-2.1/com.android.tools.build.jetifier/jetifier-core/1.0.0-alpha10/9eb7027c383061de12f93aae7a22cbeb97832d2a/jetifier-core-1.0.0-alpha10.jar' using Jetifier. Reason: The given artifact contains a string literal with a package reference 'android/support/v4' that cannot be safely rewritten. Libraries using reflection such as annotation processors need to be updated manually to add support for androidx.
(In this example, Jetifier even tries to jetify itself!)
(3)
Execution failed for task ':app:kaptGenerateStubsDebugKotlin'.
> Could not resolve all files for configuration ':app:kapt'.
> Failed to transform file 'kotlin-compiler-embeddable-1.2.21.jar' to match attributes {artifactType=processed-jar} using transform JetifyTransform
> Failed to transform '/root/.gradle/caches/modules-2/files-2.1/org.jetbrains.kotlin/kotlin-compiler-embeddable/1.2.21/39456b64a42dc359e385697e2e93b5cba52e197f/kotlin-compiler-embeddable-1.2.21.jar' using Jetifier.
Reason: Malformed input or input contains unmappable characters: javaslang/?.class.
(In this example, kotlin-compiler-embeddable-1.2.21.jar does not need to be jetified but was jetified and then failed.)
We need a way to determine whether a third-party library should be jetified or not. There are a couple of approaches:
1. The library adds some metadata stating that it is AndroidX-ready and therefore should not be jetified. (The Android Gradle plugin can also help to add this information automatically for libraries that are built using the AGP.)
2. Jetifier automatically detects the presence of AndroidX (e.g., import statements and strings containing references to AndroidX), and if AndroidX is present, assumes that the library is AndroidX-ready and skips converting it.
3. The users need to specify a blacklist of libraries that should not be jetified.
We'll need to weigh the pros and cons of these approaches and select the best one (or a combination of them).