Mentors list generator

2239073-google-script-5.gs

function generateHtmlList() {
  var offset = 2;
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheets()[0];
  var range = sheet.getRange(1,1,(sheet.getLastColumn() - offset),3);
  var data = range.getValues();
  var stringToDisplay = '';
  
  for (var i = offset; i < data.length; i++) {
    stringToDisplay += data[i][1] + ' (';
    
    // Check if profile address exists
    if ((data[i][2] != null) && (data[i][2] != '#ERROR!')) {
      stringToDisplay += '<a href="' + data[i][2] + '">' + data[i][0] + '</a>';
    } else {
      stringToDisplay += data[i][0];
    }
    stringToDisplay += '), ';
  }
  
  // Display box with code
  Browser.msgBox(stringToDisplay);
}

function getTopUrl(query, extra) {
  if (query == null) {
    throw 'Argument required';
  }
  if (extra == null) {
    extra = 'site:drupal.org inurl:/user/';
  }
  var url = 'http://ajax.googleapis.com/ajax/services/search/web?v=1.0&rsz=1&q=' + encodeURI(query + " " + extra);
  var response = UrlFetchApp.fetch(url);
  var json = response.getContentText();
  var object = Utilities.jsonParse(json);
  
  if (object["responseStatus"] == '403') {
    throw 'Quota Exceeded! Check again later.';
  }
  if (object["responseData"]["results"].length == null) {
    throw 'No results. Try add second parameter to the function (set alternative query string).';
  }
  return object["responseData"]["results"][0]["unescapedUrl"];
}