I am currently utilizing a script called "ImportJSON" developed by paulgambill https://gist.github.com/paulgambill/cacd19da95a1421d3164
The URL I am working with contains quotes characters
For instance:
http://SomeAPIULR?{"Type": "SomeType"}&APIKEY=keyIt has been observed that removing {"Type": "SomeType"} from the URL results in the script functioning flawlessly.
function ImportJSONAdvanced(url, query, options, includeFunc, transformFunc) {
var jsondata = UrlFetchApp.fetch(URL);
var object = JSON.parse(jsondata.getContentText());
return parseJSONObject_(object, query, options, includeFunc, transformFunc);
}
Is there any way to resolve this issue and make it work as intended?