Figure out how to import JSON-P data about importjson HOT 3 OPEN

Hi I was wondering if this would be applicable to ImportJSON as well? Is there any reason I couldn't use it there? I'm not that familiar with where this piece of code should be inserted in the larger code. Thanks for your help

from importjson.

So I got this to work - but only if I hard code the var object length.

http://live.nhle.com/GameData/20132014/2013020758/gc/gcbx.jsonp

Using this with 6989 hardcoded it imports the data. I don't know enough code to know why "content.length" doesn't work

function ImportJSONAdvanced(url, fetchOptions, query, parseOptions, includeFunc, transformFunc) {
var jsondata = UrlFetchApp.fetch(url, fetchOptions);
var content = jsondata.getContentText();
var ignoreStart = 10;
var ignoreEnd = 1;
var object = JSON.parse(content.substring(ignoreStart, 6989-ignoreEnd));

return parseJSONObject_(object, query, parseOptions, includeFunc, transformFunc);
}

from importjson.

I think this can be handled like this.

function ImportJSONAdvanced(url, fetchOptions, query, parseOptions, includeFunc, transformFunc) {
  var jsondata = UrlFetchApp.fetch(url, fetchOptions);
  
  try {
    var object   = JSON.parse(jsondata.getContentText());
    return parseJSONObject_(object, query, parseOptions, includeFunc, transformFunc);
  }
  catch(err) {
    var object   = jsondata.getContentText();
    var firstBr = object.indexOf("[") > object.indexOf("{") ? object.indexOf("{") : object.indexOf("[");
    var lastBr = object.lastIndexOf(")");
    var newObject=  JSON.parse(object.substring(firstBr, lastBr));
    return parseJSONObject_(newObject, query, parseOptions, includeFunc, transformFunc);
    
  }
}

from importjson.