Skip to content
This repository was archived by the owner on Feb 2, 2023. It is now read-only.
This repository was archived by the owner on Feb 2, 2023. It is now read-only.

Read list of URLs from cell range #238

@yodog

Description

@yodog

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions