ImportJSON
ImportJSON copied to clipboard
Read list of URLs from cell range
enhancement: read list of URLs from cell range
/**
* Read list of URLs from range
* Ex1: ImportJSON_RASG("sheet9!C2:C7")
* Ex2: ImportJSON_RASG("myNamedRange")
*/
function ImportJSON_RASG(cellRange, query, parseOptions) {
var arr = [];
SpreadsheetApp.getActiveSheet().getRange(1,1).activate();
const arrURL = SpreadsheetApp.getActiveSheet().getRange(cellRange).getValues().join().split(',');
for (var url of arrURL) {
try { arr.push(ImportJSON(url, query, parseOptions)); }
catch { SpreadsheetApp.getActiveSpreadsheet().toast(url, 'Error fetching data', 3); }
}
return arr.flat();
}
it's not work . sad :《