• Everything everywhere is connected with each other via cloud hosted web services and people can access these services from anywhere in globe, anytime.
• But is everything really connected as is expected? Not every cloud based service can be connected with every other service,
• But fortunately most popular Apps can be integrated And so can Salesforce and Microsoft SharePoint
• Salesforce with SharePoint How to integrate
• Integrate Salesforce with SharePoint Microsoft has not released any API to facilitate direct Salesforce SharePoint interactions so we need to involve a third-party adapter or service.
• Integrate Salesforce with SharePoint There are a number of ways you can integrate SharePoint with Salesforce. However most of these ways can be categorized into three approaches.
• Integrate Salesforce with SharePoint The different ways are: 1. Integrating using a third party system installed adapter. 2. Integrating using a Custom Coded Adapter. 3. Integrating using a third party integration service.
• Integrate Salesforce with SharePoint The first way involves building a third-party adapter that had to be physically installed on a computer system and therefore severely limits the cloud based capabilities.
• The third way involves using a paid integration product usually in a SaaS format. It is easy to use but it is not as flexible as a custom adapter and may prove to be a security risk. Integrate Salesforce with SharePoint
• Integrate Salesforce with SharePoint So the best cloud integration method left is to use a custom coded integration solution that is hosted on Microsoft Azure service to integrate your Salesforce and SharePoint.
• The main point for cloud-based integration is to host a running service on Microsoft’s cloud app platform Azure, and leveraging it to interact with SharePoint. How Salesforce Performs Step 1
• Since the service is hosted on a cloud platform, we usually access it via web- based URL. Like How Salesforce Performs Step 1 http://testingalgoworks.azurewebs ites.net/Api/Values/GetAuthToken
• How Salesforce Performs Step 1 So our methods from Salesforce side to request authentication token look something like this:
• How Salesforce Performs Step 2,3,4 Once Salesforce has sent the request for authentication token, here’s how Azure platform service authenticates login.
• How Salesforce Performs Step 5 Once Salesforce has authentication token, it uses that to request files and folders from the adapter. Once again it uses the Azure service URL to hit the service. Here’s a method to request files and a method to request folders
• How Azure Services Handle Requests The code for how Azure service handle requests is a little long. So i request you to checkout our blog on the same. Our Blog: How to integrate SharePoint with Salesforce? There you will also find the code to actually display Sharepoint files in Visual force page.

public static String getToken(){
        String token;
      if(!Test.isRunningTest()){
        token = SharePointAPIUtility.SharePointAPIGet
          ('http://testingalgoworks.azurewebsites.net/Api/Values/GetAuthToken',
           'Test@test.com','TestingPassword');
        }
      system.debug('token>>> '+token);
           if(token != null){
        return EncodingUtil.urlEncode(token.replaceAll('"',''), 'UTF-8');
        }
        return null;
        }
        public static String SharePointAPIGet(String endpointUrl,String username, String password){
        try{
          HttpRequest httpRequestObject = new HttpRequest();
          httpRequestObject.setEndPoint(endpointUrl);
          httpRequestObject.setmethod('GET');
        Blob headerValue = Blob.valueOf(username + ':' + password);
        String authorizationHeader = 'BASIC ' + EncodingUtil.base64Encode(headerValue);
          httpRequestObject.setHeader('Authorization', authorizationHeader);
          httpRequestObject.setTimeout(120000);
          system.debug('httpRequestObject>> '+httpRequestObject);
        Http http = new Http();
          HttpResponse httpResponse ;
          if(!test.isRunningTest())
              httpResponse = http.send(httpRequestObject);
          if(httpResponse != null && httpResponse.getStatus() == 'OK' 
             && httpResponse.getStatusCode() == 200){
              system.debug('httpResponse.getBody();
                           >>>>'+httpResponse.getBody()+'httpResponse.getBody();>>>>');
        return httpResponse.getBody();
        }else if(httpResponse != null){
        return 'SharePoint Server Error: Status '+ httpResponse.getStatus()+'
          Status Code '+ httpResponse.getStatusCode() +' Body 
          '+httpResponse.getBody();
        }
      }catch(CalloutException ce){
        throw ce;
      }catch(Exception ex){
        throw ex;
        }
        return null;
        }

public bool Login(string email, string password)
     {
      //throw new Exception("This is error!!");
      bool validateLogin = false;
      List<string> MessageList = new List<string>();
      //string decryptedPassword = Encryption.Decrypt(encryptedPassword);
      if (email == ConfigurationManager.AppSettings["Email"] 
          && password == ConfigurationManager.AppSettings["Password"])
      {
     string authInfo = email + ":" + password;
     authInfo = Convert.ToBase64String(System.Text.Encoding.Default.GetBytes(authInfo));
     //authInfo = Encryption.Encrypt(authInfo);
     System.Web.HttpContext.Current.Response.AppendHeader("Authorization", "Basic " + authInfo);
     // Insert User Token
     MessageList.Add("Login Successful");
     validateLogin = true;
      }
      else
      {
     MessageList.Add("Invalid Username Or Password");
      }
      return validateLogin;
     }

public static List<String> getAllFolders(SharePoint365APIParser objSharePoint365APIParser){
        try{
          list<String> objFolders = new list<String>();
        if(objSharePoint365APIParser.folders != 
           null && objSharePoint365APIParser.folders.size()>0)//null check
        for(SharePoint365APIParser.folders sp:objSharePoint365APIParser.folders){
                  objFolders.add(sp.name);
        }
        return objFolders;
      }catch(Exception ex){
        throw ex;
        }
        return null;
        public static List<String> 
          getFilesByFolder(String folderName, SharePoint365APIParser objSharePoint365APIParser){
      //if(!test.isRunningTest()){
        try{
        if(objSharePoint365APIParser.folders != null && objSharePoint365APIParser.folders.size()>0)
        for(SharePoint365APIParser.folders sp:objSharePoint365APIParser.folders){
                  if(sp.name.equalsIgnoreCase(folderName)){
                      if(sp.files.size() > 0){             
                          return sp.files;
                      }else{
                          return new list<String>();
                      }
                    }
        }
          }catch(Exception ex){
        throw ex;
        }
        //}//end running test loop
        return null;
        }

[AuthorizeWebAPI()]
     [HttpGet]
     public Folders GetResourceData()
     {
      Folders fld = new Folders();
      try
      {
          using (ClientContext clientContext = 
                 new ClientContext("https://yourprojectname.SharePoint.com/Resources"))
            {
             SecureString passWord = new SecureString();
             foreach (char c in "TestPassword".ToCharArray()) passWord.AppendChar(c);
             clientContext.Credentials = new SharePointOnlineCredentials("Test@test.com", passWord);
             Web rootweb = clientContext.Web;
             var folders =
   rootweb.GetFolderByServerRelativeUrl("/Resources").Folders;
             string pString = @"\Resources\";
                 clientContext.Load(folders);
             clientContext.ExecuteQuery();
             fld.folders = new List<Folders>();
             fld.name = "Resources";
             foreach (Microsoft.SharePoint.Client.Folder myFolder in folders)
             {
                  fld.folders.Add(GetFoldersAndFiles(myFolder, clientContext, pString));
             }
     }
   }
      catch (Exception)
      { fld.name = "Some error happened."; }
      return fld;
     }
     private Folders GetFoldersAndFiles(Microsoft.SharePoint.Client.Folder mainFolder,
                                        ClientContext clientContext, string pathString)
     {
      Folders fldr = new Folders();
      List<string> fls = new List<string>();
      fldr.folders = new List<Folders>();
          clientContext.Load(mainFolder, k => k.Files, k => k.Folders);
     clientContext.ExecuteQuery();
      foreach (var folder in mainFolder.Folders)
      {
     string folderPath = string.Format(@"{0}{1}\", pathString, folder.Name);
     if (folder.Name != "Forms")
             fldr.folders.Add(GetFoldersAndFiles(folder, clientContext, folderPath));
      }
      foreach (var file in mainFolder.Files)
      {
     fls.Add(file.Name);
      }
      fldr.files = fls;
      if (mainFolder.Name != "Forms")
     fldr.name = mainFolder.Name;
      return fldr;
     }