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 below #ERROR! result. Could you please help? It has been working perfectly for almost 2 month:

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

enter image description here

  • Have you seen this resource? support.geckoboard.com/hc/en-us/articles/… – 24601 Aug 29 '20 at 15:19
  • @User24601, yes, i have seen that. ImportJSON is active in my google sheet. I think the reason of error should be something related to the server of csgoempire.com. Maybe they are blocking or something? – Sabuhi Aug 29 '20 at 15:24
  • Thanks Ruben, added the error description as text. I tried to google the error description, but could not find any solution. – Sabuhi Aug 29 '20 at 16:08
  • @Glorfindel, any ideas how this issue can be resolved? – Sabuhi Aug 31 '20 at 4:33
  • 1
    Request failed for csgoempire.com returned code 403 ==> the server is blocking you – Sathyajith Bhat Aug 31 '20 at 6:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.