| var url = 'YOUR URL HERE'; | |
| function mainFunction() { | |
| getAllUseruid(); | |
| } | |
| function getAllUseruid(){ | |
| var sheet = SpreadsheetApp.getActiveSheet(); | |
| var startRow = 2; | |
| var numRows = sheet.getLastRow() - 1; | |
| //var numRows = 20; | |
| var dataRange = sheet.getRange(startRow, 3, numRows, 2) | |
| var data = dataRange.getValues(); | |
| //Logger.log(url+"Basil") | |
| for(i in data) { | |
| var row = data[i]; | |
| Logger.log(url+row) | |
| try { | |
| response_data = getUid(row); | |
| //Logger.log(response_date); | |
| status = response_data.userUid; | |
| } catch(err) { | |
| Logger.log(err); | |
| status = "error"; | |
| } | |
| sheet.getRange(startRow + Number(i), 4).setValue(status); | |
| } | |
| } | |
| function getUid(email) { | |
| //Logger.log(url+email) | |
| var emails = email.toString().replace(',', ''); | |
| var dataUrl = url+emails | |
| var response = UrlFetchApp.fetch(dataUrl); | |
| //Logger.log(response.getContentText()); | |
| if (response.getResponseCode() == 200) { | |
| var params = JSON.parse(response.getContentText()); | |
| Logger.log(params.userUid); | |
| return params; | |
| } else { | |
| Logger.log("Error from getUid()") | |
| return "error" | |
| } | |
| } |