G Suite Developers Blog: 6/1/14

Introducing the new Gmail API

June 25, 2014

new Gmail APIhttps://developers.google.com/gmail/api/Eric DeFriez

Guest Post: Integrating with Google Drive via a Chrome Web Store App

June 24, 2014

Nina GorbunovaAbout Teamlab PersonalTeamlab PersonalWhy Google Drive integrationIntegration goals

Integrate Teamlab editors and viewers with Google Drive.

Provide co-editing opportunities.

Enable file conversion and creating new files in the common Office Open XML format.

Enable users to login with Google to use Teamlab Personal.

Five steps to achieve two-way integration

We registered with Google’s developer console, added our project and connected the Drive API and Drive SDK to the app.

Then we needed to decide what scopes our app needed to access the Google Drive API. We chose the minimal set, ample for us to access the files to edit without trespassing the user’s privacy (most users are not likely to provide full access to 3rd party apps)

Because we work with traditional office apps, we chose docx, xlsx and pptx formats as default file extensions for our app. We also added secondary formats: ppt, pps, odp, doc, odt, rtf, txt, xls, csv, ods, mht, html, htm, fb2, epub, pdf, djvu.

The current listing for the pre-existing app, we modified the code and added the following to the manifest: "container" : "GOOGLE_DRIVE","api_console_project_id" : "YOUR_APP_ID". Once a user installs Teamlab Personal app from Chrome Web Store, it automatically connects to their Google Drive account.

Finally, Teamlab Personal uses OAuth 2.0 for authorization and file access. The application processes requests for creating and opening files.

How it works

Requests processing at personal.teamlab.comRequest code:string CreateFile(Stream content, string fileName, string mimeType, string folderId, string accessToken){ var bytes = Encoding.UTF8.GetBytes( "\r\n--boundary\r\nContent-Type: application/json; charset=UTF-8\r\n\r\n{\"title\":\"" + fileName + "\",\"parents\":[{\"id\":\"" + folderId + "\"}]}" + "\r\n--boundary\r\nContent-Type: " + mimeType + "\r\n\r\n"); var tmpStream = new MemoryStream(); tmpStream.Write(bytes, 0, bytes.Length); content.CopyTo(tmpStream); bytes = Encoding.UTF8.GetBytes("\r\n--boundary--\r\n"); tmpStream.Write(bytes, 0, bytes.Length); var request = WebRequest.Create("https://www.googleapis.com/upload/drive/v2/files?uploadType=multipart"); request.Method = "POST"; request.Headers.Add("Authorization", "Bearer " + accessToken); request.ContentType = "multipart/related; boundary=boundary"; request.ContentLength = tmpStream.Length; var buffer = new byte[2048]; int readed; tmpStream.Seek(0, SeekOrigin.Begin); while ((readed = tmpStream.Read(buffer, 0, 2048)) > 0) { request.GetRequestStream().Write(buffer, 0, readed); } return request.GetResponse().GetResponseStream(); }Conclusion

Google Chrome Web Store Impressions&Installations Statistics. Launch - April.About the authorNina

Deprecating Script Gallery in the old version of Google Sheets

June 20, 2014

add-ons for Google Docs and Sheetsadd-on publication instructionsPosted by Saurabh Gupta, Google Apps Script Team. As the product manager for Google Apps Script, Saurabh is responsible for Apps Script’s overall vision and direction.

A One-Two Punch for Getting Even More out of Google Apps APIs

June 2, 2014

Editor’s Note: Guest author Steve Ziegler is a senior architect at BetterCloud—Arun NagarajanFlashPanelControlling Throttle Rates with Guava’s RateLimiterRateLimiterfinal RateLimiter driveApiRateLimiter = RateLimiter.create(QUOTA_RATE_PER_SECOND);public Result performDriveApiCall(driveApiRateLimiter, otherParams){ driveApiRateLimiter.acquire(); // blocks according to rate // make API call...Reducing Impact of Network Traffic Issues Through Configured BackoffsGoogle suggests that API clients use an exponential backoff strategyGoogle HTTP Client for JavaExponentialBackOff1, 2, 4, 8, 16, 32, 60, 60, 60ExponentialBackOff backoff = new ExponentialBackOff.Builder() .setInitialIntervalMillis(ONE_SECOND) .setMultiplier(2.0) .setMaxIntervalMillis(ONE_MINUTE) .setMaxElapsedTimeMillis(FIVE_MINUTES) .build();1.04, 1.9, 4.23, 7.8, etc..98, 2.04, 4.1, 8.15, etc.builder.setRandomizationFactor(RANDOMIZATION_FACTOR);HttpBackOffUnsuccessfulResponseHandlerHttpRequestinitializationprivate HttpBackOffUnsuccessfulResponseHandler handler = new HttpBackOffUnsuccessfulResponseHandler(backoff); public void initialize(HttpRequest request){ request.setUnsuccessfulResponseHandler(handler); }Final ThoughtsSteve is Senior Architect at BetterCloud, the makers of FlashPanel, the number one security and management application for Google Apps. Follow BetterCloud on Google+ at plus.google.com/+Bettercloud.Posted by Greg Knoke, Googler