ImportJSON icon indicating copy to clipboard operation
ImportJSON copied to clipboard

Read list of URLs from cell range

Open yodog opened this issue 2 years ago • 1 comments

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();
}

yodog avatar Jun 24 '22 22:06 yodog

it's not work . sad :《

wenson avatar Jul 30 '22 11:07 wenson