Import JSON data into Google Spreadsheet
- by Jeremy Petzold
I am pulling data down from a webservice and it is formated as JSON. I am writing a google apps script for google spreadsheet that will populate the data form me. my problem is, I can't seem to get it to parse out.
doing:
var dataset = myJSONtext;
Browser.msgbox(dataset.item[0].key);
errors out, saying item[0] is not defined.
Is there some built in way I should be doing this?
Any help would be apreciated.