Skip to content

Instantly share code, notes, and snippets.

@KartikTalwar
Created January 10, 2017 02:07
Show Gist options
  • Save KartikTalwar/dfee4be5fe4cdf88ff0ff671af32f6c4 to your computer and use it in GitHub Desktop.
Save KartikTalwar/dfee4be5fe4cdf88ff0ff671af32f6c4 to your computer and use it in GitHub Desktop.
Google Apps Script JSON Parser
// call this function on a cell via =ImportJSON("http://...") and data will show up verbatim
function ImportJSON(url) {
var response = UrlFetchApp.fetch(url);
var data = JSON.parse(response.getContentText());
if (!data.length) {
return [];
}
var rows = [];
var headers = Object.keys(data[0]);
rows.push(headers);
for (var i=0; i<data.length; i++) {
var row = [];
for (var j=0; j<headers.length; j++) {
row.push(data[i][headers[j]]);
}
rows.push(row);
}
return rows;
}
@emonteiroD1
Copy link

Tanks, you save me.

@emonteiroD1
Copy link

Congratulations !!!

@divinofire
Copy link

Thanks

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment