title: I am running into an issue using ImportJSON w/ Google Sheets to import data
body: <p>I am trying to set up a database of all player items with overalls and series. I can pull the top level (items) but anything below that I get an &quot;Error Getting Data&quot;.</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1BbIrzYJEqEw_eOqgKXBueDhTUKGLIlMaQVbwEIT5f9Q/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1BbIrzYJEqEw_eOqgKXBueDhTUKGLIlMaQVbwEIT5f9Q/edit?usp=sharing</a></p>
  <p>I tried using <a href="https://github.com/bradjasper/ImportJSON/blob/master/ImportJSON.gs" rel="nofollow noreferrer">bradjasper's</a> ImportJSON script but kept getting:</p>
  <p>Exception: Attribute provided with no value: url</p>
  <p>ImportJSONAdvanced  @ importJSON.gs:217</p>
  <p><code>var jsondata = UrlFetchApp.fetch(url, fetchOptions);</code></p>
  <p>ImportJSON  @ importJSON.gs:68</p>
  <p><code>return ImportJSONAdvanced(url, null, query, parseOptions, includeXPath_, defaultTransform_);</code></p>
  <p>The one I am currently using is below and I was able to pull &quot;items&quot; but &quot;items/name&quot; or anything else fails to retrieve data. I am new to this and have been dredging around the web trying to find a solution without success. You guys have been extremely helpful in the past, any insight would be much appreciated.</p>
  <pre><code>* Imports JSON data to your spreadsheet Ex: IMPORTJSON(&quot;http://myapisite.com&quot;,&quot;city/population&quot;)
  * @param url URL of your JSON data as string
  * @param xpath simplified xpath as string
  * @customfunction
  */
  function IMPORTJSON(url,xpath){
    
    try{
      // /rates/EUR
      var res = UrlFetchApp.fetch(url);
      var content = res.getContentText();
      var json = JSON.parse(content);
      
      var patharray = xpath.split(&quot;/&quot;);
      //Logger.log(patharray);
      
      for(var i=0;i&lt;patharray.length;i++){
        json = json[patharray[i]];
      }
      
      //Logger.log(typeof(json));
      
      if(typeof(json) === &quot;undefined&quot;){
        return &quot;Node Not Available&quot;;
      } else if(typeof(json) === &quot;object&quot;){
        var tempArr = [];
        
        for(var obj in json){
          tempArr.push([obj,json[obj]]);
        }
        return tempArr;
      } else if(typeof(json) !== &quot;object&quot;) {
        return json;
      }
    }
    catch(err){
        return &quot;Error getting data&quot;;  
    }
    
  } ```
  </code></pre>