function doPost(e) {
  var ss = SpreadsheetApp
  .openById("19mJaMW8gC0x0M4FtjhA3bm9Sp4fMj1GHXYRti3H3X38");

  var tabelName = e.parameter.tabelName;
  var sheet = ss.getSheetByName(tabelName);
  var action = e.parameter.action;

  switch(action){
    case "insert":
      return insertData(e,sheet);
      break;
  }
}

function doGet(e){
  var ss = SpreadsheetApp
  .openById("19mJaMW8gC0x0M4FtjhA3bm9Sp4fMj1GHXYRti3H3X38");
  var tabelName = e.parameter.tabelName;
  var sheet = ss.getSheetByName(tabelName);
  var action = e.parameter.action;

  switch(action){
    case "read":
      return getData(sheet,tabelName);
      break;
  }
}

function getData(sheet,tabelName){
  var data = {};
  data[tabelName] = getObjectData(sheet);

  var hasil = JSON.stringify(data);
  return ContentService
  .createTextOutput(hasil)
  .setMimeType(ContentService.MimeType.JSON);
}

function getObjectData(sheet){
  var allData = [];
  var rangeObjek = sheet.getDataRange().getValues();
  var jumlahKolom = sheet.getLastColumn();
  for(var row = 1;row<rangeObjek.length;row++){
    var objek = {};
    for(var column = 0;column<jumlahKolom;column++){
      objek[rangeObjek[0][column]] = rangeObjek[row][column];
    }
    allData.push(objek);
  }
  return allData;
}






function insertData(request, sheet){
  var nis = request.parameter.nis;
  var nama = request.parameter.nama;
  var status = request.parameter.status;
  sheet.appendRow([nis,nama,status]);
  var hasil = "Data berhasil dimasukan";
  hasil = JSON.stringify(
    {
      "hasil": hasil
    }
  );

  return ContentService
  .createTextOutput(hasil)
  .setMimeType(ContentService.MimeType.JSON);
}