var ss = SpreadsheetApp.openById('..............')
var sheet = ss.getSheetByName('.............')
function doGet(e) {
var action = e.parameter.action
if (action == 'getUsers') {
return getUsers(e)
}
}
function getUsers(e) {
var rows = sheet.getRange(2,1,sheet.getLastRow()-1,sheet.getLastColumn()).getValues()
var data =[]
for(var i=0; i<rows.length;i++){
var row = rows[i]
var record = {}
record['Name']=row[0]
record['nickName']=row[1]
record['Phone']=row[2]
record['Email']=row[3]
data.push(record)
}
var result = JSON.stringify(data)
return ContentService.createTextOutput(result).setMimeType(ContentService.MimeType.JSON)
}
var ss = SpreadsheetApp.openById('..............') var sheet = ss.getSheetByName('.............')
function doGet(e) { var action = e.parameter.action if (action == 'getUsers') { return getUsers(e) } }
function getUsers(e) { var rows = sheet.getRange(2,1,sheet.getLastRow()-1,sheet.getLastColumn()).getValues() var data =[] for(var i=0; i<rows.length;i++){ var row = rows[i] var record = {} record['Name']=row[0] record['nickName']=row[1] record['Phone']=row[2] record['Email']=row[3] data.push(record) } var result = JSON.stringify(data) return ContentService.createTextOutput(result).setMimeType(ContentService.MimeType.JSON) }