Web App URL:

🍔 Menu, Items

Loading...

App Script: 

function doGet(e) {

  const ss = SpreadsheetApp.getActiveSpreadsheet();

  const sheet = ss.getSheetByName("StockItems"); // exact tab name

  const rows = sheet.getDataRange().getValues(); // get all data including headers

  const headers = rows.shift(); // remove first row (headers)

  const data = rows.map(r => {

    let obj = {};

    headers.forEach((h,i) => obj[h] = r[i]); // map each row into key-value object

    return obj;

  });

  return ContentService.createTextOutput(JSON.stringify(data))

                       .setMimeType(ContentService.MimeType.JSON);

}

🍔 Menu, Items

Loading...