Connecting to O365 Contents

Integrating Office Email, People and Calendar in SharePoint solutions

While Microsoft Office365 does provides excellent interfaces for the common contents such as Email, people and calendar events, these content are often required in business solutions as well. That is why Webparts360 provides a means to create, update and read these contents from within our solutions.

This is done by leveraging on Office365 API (see ) Once you have activated the Office 365 integration option from the solution properties, Webparts360 will retrieve the latest content via the API calls whenever data is added or changed.


Figure 1: Webparts360 Solution Properties – Integration Option

Once you have activated this integration, a private set of databases of these contents will be created for each user. The purpose of this cached data set is to improve the performance and to eliminate round trips when querying these data. The following special tables will be created:

Type Description Remarks
#Office365_Contacts People Only returns data that are owned by user
#Office365_Events Calendars Only returns data that are owned by user
#Office365_Emails Emails Only returns data that are created or received by user

You can use these table in your data source for creating reports, (e.g. SELECT * FROM #Office365_Events) to return all your calendar events.

In your data source, you can access this data when you select the Office 365 data option.


Then you can use these contents as if it were a SQL database table to filter or analyze the data.

If you wish to add to these contents, you will need to create custom lists or database tables to store the fields that you want to use. Under Actions, you can choose the required API calls to integrate to the contents, for example:

Email (Send Only)


Figure 2: Email Integration


Figure 3: Email Integration Actions

This allows you to send an email using the user credentials. Since this is scheduled service, it will take a minute or two before you see this in your system.

People Integration

You can also choose to create your own interface to manage your contact information using the People integration options.


Figure 4: People Integration Options


Figure 5: People Integration Properties

Calendar Integration

For calendar, you can call the actions to manage the calendar event.


Figure 6: Calendar Integration Options



Figure 7: Calendar Event Integration Options

Demo Solution

The purpose of this demo is to show how your personal contents within Office365 can be retrieved and analyzed. Gain better insight over your contents.

O365 Home

Figure 8: Home Page


Figure 9: Email (Inbox)


Figure 10: Calendar (with Create Option)


Figure 11: Reports & Analysis

You can create search screens for your contacts and drill down to see related activities, such as this:


Figure 12: Search for contacts


Figure 13: Contacts with related emails

Thanks to Microsoft for finally releasing the Office 365 API so that we can re-use these contents for our applications. I am sure they will continue to improve and stabilize these API. Please note that these are BETA API’s and as such, may require tweaking from time to time. We cannot guarantee that these features will continue to work and thus we are not responsible for any consequences from the use of these features. Please exercise caution when experimenting with this features. Check out this video below to see it in action.

We love to hear your feedback and ideas on creative way to use these features.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s