ImportJSON "Loading..." Issue

[axelgfelix]

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.

[calanger]

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]

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.

[rektosaure]

Same issue here

[patniemeyer]

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]

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

[h6w]

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?

[ZipploW]

Same issue here since 3 days :/

[mhawksey]

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

[h6w]

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