G Suite Developers Blog: 3/1/11

OAuth 2.0 for Apps APIs

March 24, 2011

announcementGoogle Apps APIscontactscalendardocsPosted by Steve Bazyl, Google Apps Marketplace TeamWant to weigh in on this topic? Discuss on Buzz

Contact Sharing using Google Apps Script

March 23, 2011

Editor's Note:This article is written by Steve Webster and Vinay Thakker who work at Dito. Dito has developed applications such as Dito Directory which is available in the Google Apps Marketplace.How does it work?

Step 1 lists all the current contact groups in user’s account. The user can select the group he/she wants to share.

Step 2 allows user to select the colleagues with whom the user wants to share his/her personal contact group with.

Step 3 lets the user submit the sharing request.

Designing using Apps Script Services1. Security (guide)2. Spreadsheet ServiceSpreadsheet Service

// grab the group titled "Sales Department"
var group = ContactsApp.getContactGroup("Sales Department");
// from that group, get all of the contacts
var contacts = group.getContacts();
// get the sheet that we want to write to
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Contact Data");
// iterate through contacts
for (var i in contacts) {
//save each of the values into their own columns
sheet.getRange(i, 1, 1, 1).setValue(contacts[i].getGivenName());
sheet.getRange(i, 2, 1, 1).setValue(contacts[i].getFamilyName());
...
sheet.getRange(i, 13, 1, 1).setValue(contacts[i].getWorkFax());
sheet.getRange(i, 14, 1, 1).setValue(contacts[i].getPager());
sheet.getRange(i, 15, 1, 1).setValue(contacts[i].getNotes());
}

3. Ui ServiceUi Services

// create app container, chaining methods to set properties inline.
var app = UiApp.createApplication().setWidth(600).setTitle('Share The Group');
// create all of the structural containers
var tabPanel = app.createTabPanel();
var overviewContent = app.createFlowPanel();
var step1Content = app.createFlowPanel();
var step2Content = app.createFlowPanel();
var step3Content = app.createFlowPanel();
// create u/i widgets
var selectLabel = app.createLabel("Select one of your Contact Groups you want to share with others.");
var contactGroupDropdown = app.createListBox().setName('groupChooser');
// add all children to their parents
overviewContent.add(selectLabel);
overviewContent.add(contactGroupDropdown);
tabPanel.add(overviewContent,"Overview");
tabPanel.add(step1Content,"Step 1");
tabPanel.add(step2Content,"Step 2");
tabPanel.add(step3Content,"Step 3");
app.add(tabPanel);
// tell the spreadsheet to display the app we've created.
SpreadsheetApp.getActiveSpreadsheet().show(app);

// create a function to execute when the event occurs. the
// callback element is passed in with the event.
function changeEventForDrowdown(el) {
Browser.msgBox("The dropdown has changed!");
}
// create event handler object, indicating the name of the function to run
var dropdownHandler = app.createServerChangeHandler('changeEventForDrowdown');
// set the callback element for the handler object.
dropdownHandler.addCallbackElement(tabPanel);
// add the handler to the "on change" event of the dropdown box
contactGroupDropdown.addChangeHandler(dropdownHandler);

4. Contacts ServiceContacts Service

var group = ContactsApp.createContactGroup(myGroupName);
for (var i = 0; i < sheet.getLastRow(); i++) {
var firstName = sheet.getRange(i, 1, 1, 1).getValue();
var lastName = sheet.getRange(i, 2, 1, 1).getValue();
var email = sheet.getRange(i, 3, 1, 1).getValue();
var myContact = ContactsApp.createContact(firstName, lastName, email);
// ...
// set other contact details
// ...
myContact.addToGroup(group);
}

hereClick hereDito DirectoryGoogle Apps MarketplacePosted by Steve Webster and Vinay Thakker from DitoWant to weigh in on this topic? Discuss on Buzz

Last Call for Google I/O: Google Apps Challenge

March 22, 2011

announcedGoogle Apps ScriptGoogle Code BlogContest SitePosted by Ryan Boyd, Google Apps TeamWant to weigh in on this topic? Discuss on Buzz

Deprecating Tables and Records feeds of the Spreadsheets API

March 17, 2011

LabsTableRecordGoogle Spreadsheets APIListCellListSpreadsheets API forumPosted by Vic Fryzel, Google Spreadsheets API TeamWant to weigh in on this topic? Discuss on Buzz

Requiring SSL when using Google APIs

March 15, 2011

Google Documents List APISpreadsheets APISites APIthis post on the Google Code blog
Although we’re initially requiring SSL for only a few APIs, we strongly recommend that you convert all of your API clients as soon as possible to use SSL in order to help protect your users’ data.

Posted by Adam Feldman, Google Developer Team

Want to weigh in on this topic? Discuss on Buzz

Update on Marketplace Billing API

March 11, 2011

previewGoogle Apps Marketplace APIPosted by Steven Bazyl, Google Apps Marketplace Team

Celebrating 1 year of Integrated Goodness

March 9, 2011

Google Apps MarketplaceMy definition of deeply integratedStop making me create accounts and passwordsOpenID

Cohuman: Allows me to sign in with my Google Apps account directly from their site, in addition to providing Single Sign-On access from the universal navigation bar

Eliminate my data silosAuto-complete my ContactsGoogle Contacts API

Mavenlink:Allows me to send invitations to contacts or colleagues to collaborate on a project. They make it very easy by auto-completing addresses using my Google Contacts.

Connect with my Google Docs

Manymoon: Automatically manages the ACLs of docs I attach to a task or project, so new project members automatically get access to the project docs

creating folders

class.io: Creates a Google Docs folder and Google Calendar automatically when a teacher creates a new course. This allows students to access all the information about their class from within the tools they already use.

Manage my central calendar store data

TripIt: Has a Calendar Sidebar Gadget to give me a quick glance view of my upcoming trips

Make my data available on the goUS-101other devices

AffinityLive: Creates appointments in Google Calendar, making them available on the web and on your mobile device

TripItIntent Filtermobile appsConcur BreezeEnable me to take action in contextShow me relevant information next to my e-mailsGmail Contextual Gadgets

Harvest: If I forgot to submit my timesheets for the week, it sends me a reminder and I can file the timesheets right from within the email

Solve360: When I receive an e-mail from a potential customer, I can immediately capture the opportunity in my CRM

Become my friend in Google Talk

GQueues: Uses the XMPP functionality built into App Engine to allow me to IM the application to add a new task. So, if I have an e-mail open or am running around with my Android, I can pop open a Google Task and quickly add a task.

Make my dates more InterestingCalendar Sidebar Gadgets Let me pack my bags if we must part waysData Liberation FrontCalendarContactsDocs

Viewpath: If I want to get my data out of Viewpath, I can easily export it as a Microsoft Project file.

Earn your stars!Get startedshare the storyWant to weigh in on this topic? Discuss on Buzz

Ryan Boyd profile | twitter | events

Ryan is a Developer Advocate on the Google Apps Marketplace team, helping businesses build applications integrated into Google Apps. Wearing both engineering and business development hats, you'll find Ryan writing code and helping businesses get to market with integrated features.

Changes to minimum password length for Google Apps accounts

March 1, 2011

2-step verification for all Google accountsalready requireProvisioning API Developer’s GuidePosted by Claudio Cherubino, Google Apps APIs TeamWant to weigh in on this topic? Discuss on Buzz