#Error! in ImportJSON formula in google sheets

[Sabuhi1993]

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]

I have a similar Error "Fehler" just means error in german

[autumnlooijen]

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]

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

[autumnlooijen]

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]

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

[autumnlooijen]

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]

OK Thank you

[autumnlooijen]

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