-
Notifications
You must be signed in to change notification settings - Fork 2
Expand file tree
/
Copy pathCode.gs
More file actions
30 lines (24 loc) · 680 Bytes
/
Code.gs
File metadata and controls
30 lines (24 loc) · 680 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
function doGet(request) {
let result = {};
let users = SpreadsheetApp
.getActiveSpreadsheet()
.getSheetByName('Users')
.getDataRange()
.getValues()
users.shift()
result.users = createObject(users)
.filter(el => el.Role == request.parameter.role)
result.params = request.parameters
return ContentService.createTextOutput(JSON.stringify(result))
.setMimeType(ContentService.MimeType.JSON)
}
function createObject(dataArr) {
let obj = []
obj = dataArr.map(el => ({
FirstName: el[0],
LastName: el[1],
Email: el[2],
Role: el[3],
}))
return obj
}