Ryan 2009-11-17 41 <p>At MITA, we use Google Apps for email, and online documents, spreadsheets, forms, chat, and more. I've been weaving Applications together in an Intranet, using Ruby & Rails. Ruby is a pleasure to work with - it is logical, flexible, and powerful object-oriented scripting-type language. The "Staff Listing" on the Intranet list the 50+ employees in the organization, and the data is pulled from PowerSchool, the school's Student Information System (SIS) [where all Employees are centrally managed anyway]. </p> <p> Using Ruby and Google's API, I've put together the following pages: <ul> <li>Index</li> <li>Login<br /> Using a webform, submit Google login information (username and password) to https://www.google.com/accounts/ClientLogin , which returns the "token": <pre>SID=DQAAAIUAAAAfSngN... LSID=DQAAAIcAAAAinnV... Auth=DQAAAIcAAAAinnV...</pre> </li> <li>Reports<br /> The "Reports" page uses the SID from the token, and submits a request to google.com/hosted/services/v1.0/reports/ReportingData. Using Google's API, I can grab * accounts * activity * disk_space * email_clients * quota_limit_accounts * summary * suspended_accounts (described <a href="http://code.google.com/apis/apps/reporting/google_apps_reporting_api.html">here</a>). <pre> @token = SID @domain = your Google Apps domain name (this assumes you are using Google Apps for <b>your domain</b>) @date = "2009-11-14" # This XML String will be posted to the URL below xml_req =<<EOF <?xml version="1.0" encoding="UTF-8"?> <rest xmlns="google:accounts:rest:protocol" xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance "> <type>Report</type> <token>#{@token}</token> <domain>@domain</domain> <date>@date</date> <reportType>daily</reportType> <reportName>accounts</reportName> </rest> EOF # This actually posts the Request http = Net::HTTP.new('www.google.com', 443) http.use_ssl = true req = http.post('/hosted/services/v1.0/reports/ReportingData', xml_req) </pre> </li> </ul> <p> I've also touched the surface pulling feeds from the domain, using google.com/a/feeds/domain_name - this is something to explore a bit more. </p> 2009-11-18T20:00:28Z