Forked from KartikTalwar/google-apps-script-json-parser.gs
Created
March 10, 2021 03:24
-
-
Save vicdecode/c6a8cdbe533bb00f831586369cab44bb to your computer and use it in GitHub Desktop.
Google Apps Script JSON Parser
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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; | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment