ImportJsonFromSheet - SyntaxError: Unexpected token: a (line 616)

[ebolamonk3y]

Line 615 and 616: } Logger.log(jsonText); return JSON.parse(jsonText);

Not sure why this is throwing an error when just grabbing data from another sheet.

[iveskins]

if you try var jsonRange = source.getRange(1,1); /* var jsonRange = source.getRange(1,1,source.getLastRow()); */ and put all the json in A1 it seems to work

[ebolamonk3y]

I'm trying to have the new query append to existing sheet and build up a database of results overtime. It doesn't seem possible with GoogleSheets.

[rewaza]

Try to sringify it: var xxx = JSON.parse(JSON.stringify(jsonString));