search

bradjasper / ImportJSON

Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet
GNU Lesser General Public License v3.0
2.11k stars 1.06k forks source link

#Error! in ImportJSON formula in google sheets #169

Open Sabuhi1993 opened 4 years ago

Sabuhi1993 commented 4 years ago

I have been successfully using the following ImportJSON formula in google sheets:

=ImportJSON(csgoempire.com/api/v2/metadata/roulette/history?seed=1997, "/", "noInherit,noTruncate,noPrefixHeaders",94)

But it was until recently that, the same formula started to give the below #ERROR! result. Could you please help? It has been working perfectly for almost 2 month, Some people say that, the server is blocking me. If so is there any way to bypass it?

Exception: Request failed for csgoempire.com returned code 403. Truncated server response: {"blocked":true,"country":"USA","ip":"107.178.193.127"}

Berdi2 commented 4 years ago

I have a similar Error Screenshot(56) "Fehler" just means error in german

autumnlooijen commented 4 years ago

It's a problem with the server; unfortunately, there's nothing ImportJSON can do to fix this.

Code 403 means that the server will not give you permission to see that page. Maybe your API key or login information is no longer valid; maybe they've seen too many requests from your IP address and decided to ban it. I'd check csgoempire.com and see whether they have restrictions on how often you can access their API.

Good luck!!

Berdi2 commented 4 years ago

When I try a new Api Key it doesn't work either but when I access it manually it's working just fine

autumnlooijen commented 4 years ago

In your case, the error says you've tried too many invalid API keys; they may have banned your IP address. You might try checking hypixel.net to see their API access policies, or try contacting them directly to explain your situation. Best of luck!

Berdi2 commented 4 years ago

I have that error but I can access it manually so idk

autumnlooijen commented 4 years ago

When you access it manually, are you using the same IP address and API key? If you are, I'd talk with the folks at hypixel.net and see if they can figure out what's up. It's unfortunately not an ImportJSON issue.

Berdi2 commented 4 years ago

OK Thank you

autumnlooijen commented 4 years ago

You're welcome! And I hope they can help you out. :-)