title: Return a value from json in Google Sheets script editor
body: <p>I'm trying to get a value from a json object from a URL for use in a Google Sheet.</p>
  
  <p>This is the script:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>function ccprice()
  {
  var url = "https://acx.io//api/v2/tickers/btcaud.json"
  var response = UrlFetchApp.fetch(url);
  var json = response.getContentText();
  var data = JSON.parse(json);
  
  var price = data.buy
                                      
  return price
  }</code></pre>
  </div>
  </div>
  </p>
  
  <p>When I call the function in Google Sheet, it has an error:</p>
  
  <p>Error
  Unknown range name: 'CCPRICE'</p>