bradjasper/ImportJSON

ImportJSON "Loading..." Issue

axelgfelix opened this issue · 9 comments

axelgfelix commented

Good day, everyone!

Because yesterday's issue from JuanFirmino #228 was closed, I'm starting a new ticket.

I've been using the ImportJSONBasicAuth method with a JSON link for months. But, unfortunately, it has stopped working today.

Is anyone else having this problem? I saw that there were several persons in the initial problem.

Thank you community, hopefully we will find a solution.

Screen Shot 2022-03-04 at 1 16 10 p m

calanger commented

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.

FanaticalR43 commented

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.

  • 👍3
rektosaure commented

Same issue here

patniemeyer commented

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.

Rose2395 commented

Same issue here, it's been happening since yesterday. Stuck on the loading data.

  • 👍2
h6w commented

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?

  • 👍1
ZipploW commented

Same issue here since 3 days :/

mhawksey commented

Google have acknowledged this open issue ticket on load times for custom functions https://issuetracker.google.com/issues/222342097#comment25

h6w commented

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