This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters. Learn more about bidirectional Unicode characters
| /* Route | |
| * All Request with Method Get will be proces here | |
| */ | |
| function doGet[req] { | |
| var action = req.parameter.action; | |
| var db = SpreadsheetApp.openById["YOUR SPREADSHEET ID"]; | |
| // Don't forget to change your Sheet Name by default is 'Sheet1' | |
| var sheetUsers = db.getSheetByName["Users"]; | |
| switch[action] { | |
| case "read": | |
| return doRead[req, sheetUsers]; | |
| break; | |
| case "insert": | |
| return doInsert[req, sheetUsers]; | |
| break; | |
| case "update": | |
| return doUpdate[req, sheetUsers]; | |
| break; | |
| case "delete": | |
| return doDelete[req, sheetUsers]; | |
| break; | |
| default: | |
| return response[].json[{ | |
| status: false, | |
| message: 'silent!' | |
| }]; | |
| } | |
| } | |
| /* Read | |
| * request for all Data | |
| * | |
| * @request-parameter | action | |
| * @example-request | ?action=read | |
| */ | |
| function doRead[request, sheetObject] | |
| { | |
| var data = {}; | |
| data.records = _readData[sheetObject]; | |
| return response[].json[data]; | |
| } | |
| /* Insert | |
| * | |
| */ | |
| function doInsert[req, sheet] { | |
| var id = req.parameter.id; | |
| var username = req.parameter.username; | |
| var email = req.parameter.email; | |
| // all data your needed | |
| var flag = 1; | |
| var Row = sheet.getLastRow[]; | |
for [var i = 1; i
Chủ Đề |