title: importJSON returns error code 429 (rate limited) from the server while I'm not
body: <p>I am using an unmodified version of the ImportJSON library by Brad Jasper and Trevor Lohrbeer (<a href="https://github.com/bradjasper/ImportJSON" rel="nofollow noreferrer">https://github.com/bradjasper/ImportJSON</a>)</p>
  <p>With this library, I am trying to import cryptocurrency prices into a Google Sheet, as follows:</p>
  <pre><code>importJSON(&quot;https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&amp;ids=bitcoin&quot;,
  &quot;0.current_price&quot;)
  </code></pre>
  <p>For your reference, this is the JSON response at the endpoint given:</p>
  <pre><code>[
      {
          &quot;id&quot;:&quot;bitcoin&quot;,
          &quot;symbol&quot;:&quot;btc&quot;,
          &quot;name&quot;:&quot;Bitcoin&quot;,
          &quot;image&quot;:&quot;https://assets.coingecko.com/coins/images/1/large/bitcoin.png?1547033579&quot;,
          &quot;current_price&quot;:49101,
          &quot;market_cap&quot;:917650396614,
          &quot;market_cap_rank&quot;:1,
          &quot;fully_diluted_valuation&quot;:1029890733176,
          &quot;total_volume&quot;:64288903539,
          &quot;high_24h&quot;:49826,
          &quot;low_24h&quot;:46682,
          &quot;price_change_24h&quot;:289.93,
          &quot;price_change_percentage_24h&quot;:0.59398,
          &quot;market_cap_change_24h&quot;:2244251078,
          &quot;market_cap_change_percentage_24h&quot;:0.24516,
          &quot;circulating_supply&quot;:18711362.0,
          &quot;total_supply&quot;:21000000.0,
          &quot;max_supply&quot;:21000000.0,
          &quot;ath&quot;:64805,
          &quot;ath_change_percentage&quot;:-24.58992,
          &quot;ath_date&quot;:&quot;2021-04-14T11:54:46.763Z&quot;,
          &quot;atl&quot;:67.81,
          &quot;atl_change_percentage&quot;:71969.04088,
          &quot;atl_date&quot;:&quot;2013-07-06T00:00:00.000Z&quot;,
          &quot;roi&quot;:null,
          &quot;last_updated&quot;:&quot;2021-05-16T07:57:37.155Z&quot;
      }
  ]
  </code></pre>
  <p>I am expecting a return of <code>49101</code>, but instead get an error:</p>
  <pre><code>Exception: Request failed for https://api.coingecko.com returned code 429. 
  Truncated server response: error code: 1015 (use muteHttpExceptions option to 
  examine full response (line 220).
  </code></pre>
  <p>I did some Googling and <code>error 429</code> seems to mean that you have queried the API too many times from your IP. From the Coingecko website:</p>
  <pre><code>4.2 Rate limit for the CoinGecko API is 10 calls each second per Internet Protocol 
  (“IP”) address, although such rate limit may be varied by CoinGecko at any time 
  in its sole discretion without notice or reference to you or any Users
  </code></pre>
  <p>But this does not apply to me. First, I only did about 50 API calls (trying to get this to work) in the past hour and second, if I go to the endpoint in my browser, I'm getting this JSON response there without issue, telling me that I'm really not rate limited.</p>
  <p>I would like to debug further, but do not understand how I can &quot;use muteHttpExceptions option to examine full response&quot;. What would my <code>importJSON</code> call then look like? I tried below, but it changed nothing to the returned error:</p>
  <pre><code>=importJSON(&quot;https://api.coingecko.com/api/v3/coins/markets?vs_currency=usd&amp;ids=bitcoin&quot;,&quot;0.current_price&quot;, &quot;muteHttpExceptions=true&quot;)
  </code></pre>
  <p>Does anyone know what I'm doing wrong to invoke <code>muteHttpExceptions</code> or why at all I get this this error returned? Could someone please run the same formula, and see if they get the same error?</p>