Google Apps Script – Adding Company Directory with Pictures to Google Sites

google-apps-scriptgoogle-sites

I'm using this code to pull the name and emails of my users into an intranet page on Google Sites. I was just wondering, is there some code that I can add to this so I can retrieve pictures? I would imagine it goes in below flexTable.setWidget(parseInt(i), 1, app.createLabel(user.getEmail())); but I'm not sure what I can add there to retrieve their picture from their profile. I would also like to do the same for phone number.

function doGet() {
  var app = UiApp.createApplication(); 
  var users = UserManager.getAllUsers();  
  var flexTable = app.createFlexTable().setBorderWidth(1);

  for (var i=0, len=users.length; i<len; i++) {
    var user = users[i];
    flexTable.setWidget(parseInt(i), 0, app.createLabel(user.getGivenName()
      + ' ' + user.getFamilyName()));
    flexTable.setWidget(parseInt(i), 1, app.createLabel(user.getEmail()));
  }
  app.add(flexTable);
  return app;
}

Edit: I tried adding flexTable.setWidget(parseInt(i), 2, app.createLabel(user.getPhones())); but that gives me an error in the code. I got this from the API reference for scripts.

Best Answer

That's not possible I'm afraid with the API used. The API that's being used doesn't allow for more (basic) info to be retrieved.

There's however a new API released under Google Apps Script that can help you out:
Admin SDK Directory Service

This allows for much more tweaking !!

Related Solutions

Google Sites Intranet – How to Pull Company Directory

The following code retrieves the users, present within the Google Apps Domain:

function doGet() {
  var app = UiApp.createApplication(); 

  var users = UserManager.getAllUsers();  
  var flexTable = app.createFlexTable().setBorderWidth(1);

  for (var i=0, len=users.length; i<len; i++) {
    var user = users[i];
    flexTable.setWidget(parseInt(i), 0, app.createLabel(user.getGivenName()
      + ' ' + user.getFamilyName()));
    flexTable.setWidget(parseInt(i), 1, app.createLabel(user.getEmail()));
  }

  app.add(flexTable);

  return app;
}

Add this script, via the Google Apps Script gadget, to your page and the people will appear. See working example: domain users by script

There are however some prerequisites:

Be an administrator
Enable the provisioning API: dashboard/domain settings/user settings

You can also use a script within a spreadsheet and display the users in a spreadsheet:

function getdomainUsers() {
  // set spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();

  // set sheet
  var sheet = ss.getSheets()[0];

  // set range
  var range = sheet.getRange(2, 1, sheet.getLastRow(), 2);

  // clear range
  range.clear();

  // retrieve all users and create array
  var users = UserManager.getAllUsers(), auserInfo = new Array();  

  // itterate through users  
  for (var i=0, len=users.length; i<len; i++) {
    // instantiate user
    var user = users[i];

    // add info to array
    auserInfo.push([user.getGivenName() + ' ' + user.getFamilyName(),user.getEmail()]);
  }

  // set values to sheet
  sheet.getRange(2,1,len,2).setValues(auserInfo); 
}

Set a trigger on the script, to refresh the users for lets say every 12 hours. An administrator needs to prepare the sheet once. See working example: domain users by spreadsheet

Google-apps-script – How to share Company’s directory with all users using Google Apps shared Directory

Have you considered using the Shared Contacts API? This would put these additional contacts into your users' Google Contacts (accessible via Gmail). If you would prefer not to work with APIs, there are 3rd-party products in the Google Apps Marketplace that do this - https://www.google.com/enterprise/marketplace/search?query=shared+contacts

Related Topic