Hey guys!
I have a JSON file which I have to get into a Google Spreadsheet.
To convert the data, I want to use a script from github (https://gist.github.com/chrislkeller/5719258).
The script also works fine, I tried it with some examples but with my data there is a problem.
The JSON file has the following structure:
item 1 item 2 item 3
data 11 data 21 data 31
data 12 data 22 data 32
data 13 data 23 data 33
...and so on
If I now want to give the file to the file to the script via ImportJSON(), which worked well with the examples, I get the error message "SyntaxError: empty JSON string (line 132)"
Has anyone any idea how to solve this or how to convert the file (is in a URL)?
Thanks a lot in advance, best
Hannibal
Bookmarks