Console Application For Office 365 – SharePoint Online


Sathish Nadarajan
SharePoint MVP
Published On :   09 Jul 2016
Visit Count
Today :  2    Total :   3603
Plan, Migrate, Secure, Report
SharePoint & Office 365 Tool. Simple & Easy to Use. 15-Day Trial!

SharePoint Office 365 Tool
Simple & Powerful Tool for Migration, Security & Reporting. Free Trial


In this article, let us see how to create a console application against an Office 365 in SharePoint.

The reason behind this is straight forward. I.e., we may need to create the client side object model against the Office 365. Hence, it will be very tedious to deploy many times on the O365 environment. During the development time, it will be easy for us, if we have a handy Console Application. On that, we will finish our functionality and copy the code, paste it in our actual Solution, then deploy the code.

With this brief introduction, let us proceed step by step.

1. Open the Visual Studio. In my Case, I am using VS 2015.

clip_image002

2. Create a Console Application.

3. Add the NuGET Package. Refer HERE to have a detailed view about NuGET Packages

clip_image004

4. Install the below Package. “Microsoft.SharePointOnline.CSOM”

clip_image006

5. Once, it is installed, the following DLLs were added automatically.

clip_image008

6. Now, let us open the Program.cs. We have done with our basics.

7. Add the Namespace Microsoft.SharePoint.Client and System.Security.

8. Now, add the below lines of codes.

 using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Text;
 using System.Threading.Tasks;
 
 using Microsoft.SharePoint.Client;
 using System.Security;
 
 namespace Console.Office365
 {
     class Program
     {
         static void Main(string[] args)
         {
             string siteURL = "https://sppals.sharepoint.com/sites/VariationPublishingSite";
             string userName = "sathish@sppals.onmicrosoft.com";
             string password = "*************";
 
             var clientContext = GetClientContext(siteURL, userName, password);
 
             Web web = clientContext.Web;
 
             clientContext.Load(web);
             clientContext.ExecuteQuery();
 
             System.Console.WriteLine(web.Title);
             System.Console.ReadLine();
         }
 
         static ClientContext GetClientContext(string siteURL, string userName, string password)
         {
             var credentials = new SharePointOnlineCredentials(userName, ToSecureString(password));
             var context = new ClientContext(siteURL);
             context.Credentials = credentials;
 
             return context;
 
 
         }
 
         public static SecureString ToSecureString(string Source)
         {
             if (string.IsNullOrWhiteSpace(Source))
                 return null;
             else
             {
                 SecureString Result = new SecureString();
                 foreach (char c in Source.ToCharArray())
                     Result.AppendChar(c);
                 return Result;
             }
         }
     }
 }
 

9. Press F5.

10. We will get the result as

clip_image010

11. Like this, we can do various activities and get the functionality implemented.

Happy Coding,

Sathish Nadarajan.

SharePoint Usage Reports
Usage reports, collaboration and audit for SharePoint.
Categories

SharePoint Analytics