Comments (9)
Also having the same issue, the script has been running well for a few years.
The issue started a few days ago.
Sheets that I have built using importxml queries have stopped functioning.
Sheets with importhtml have also stopped working.
Down yesterday morning, up for a short time then went down again.
This seems to be a global Google Docs issue, https://support.google.com/docs/thread/153166088?hl=en&msgid=153387464
Any call for web data is currently broken with intermittent hangs.
Brad Jasper's ImportJSON function is impacted by this issue.
Deving
Google Employee
Yet another Googler
23 hr. ago
"Dear all, just want you know that we've heard you! We are currently working on the issue. Sorry for the inconvenience and thank you for being Google Sheets users!"
We will just have to wait for Google to push a fix.
from importjson.
Same issue here, it's been happening since yesterday. Stuck on the loading data.
from importjson.
Interestingly, when I run it manually from the project editor it works and returns the result, but when I use it from a spreadsheet it just times out saying "Error: Loading data...". So maybe there's a new permission that needs to be added for it to work?
from importjson.
I have the same issue and it started today too. I've been using the tool for a couple of years now and it has been great.
from importjson.
Same issue here
from importjson.
These seem to be transient issues that come and go without any changes to importJSON. I've been using this for a couple of years now as well and experienced this many times. I wish Google would just natively support json import. Does anyone know why they would not do this?
EDIT: Forgot to say that it's also possible that ad blockers are breaking things and then whitelists are being updated. Always check that first.
from importjson.
Same issue here since 3 days :/
from importjson.
Google have acknowledged this open issue ticket on load times for custom functions https://issuetracker.google.com/issues/222342097#comment25
from importjson.
As a workaround, I have done this instead and it works:
function Refresh() {
var JSONData = ImportJSON("https://blablahblah");
SpreadsheetApp.getActiveSpreadsheet().getSheetByName("Sheet1").getRange('A2:J3').setValues(JSONdata);
}
Be sure to change the range to match the data array or calculate the range dynamically.
Then add Refresh() as a load and/or time trigger for the spreadsheet.
Works for me. YMMV. :-)
from importjson.
Related Issues (20)
- How to trigger ImportJSON with a script HOT 1
- ImportJSON & TriggerAutoRefresh Errors
- Function does not compile; Exception: Attribute provided with no value: url HOT 2
- Import JSON stops working! HOT 10
- Need help in changing item in an array
- How to use "allHeaders" option but only return row 1 (ie 2nd row) HOT 1
- How to add timer? HOT 2
- How to add Api Key header HOT 1
- Extract information from NSE website to Google sheet/ Excel spreadsheet
- Syntax for ImportJSONViaPost
- Read list of URLs from cell range HOT 1
- ERROR Attribute provided with no value: url
- How can I get this value? HOT 1
- Any way to import multiple URLs
- returned code 404 (line 220)
- Only outputting object Object Array
- Flatten JSON not create new rows
- Error message after initial loading...
- #ERROR! SyntaxError: Unexpected end of JSON input (Line 221)
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from importjson.