SHAREPOINT INTEGRATION USING MULE4

Share on facebook
Share on twitter
Share on linkedin
If you want to store documents with large data, the Microsoft SharePoint connector is used for document management, and it enables integration with SharePoint through its REST API. 

Introduction 

If you want to store documents with large data, the Microsoft SharePoint connector is used for document management, and it enables integration with SharePoint through its REST API. 

Sharepoint Connector in Mule4 

MuleSoft provides the Sharepoint connector to allow the user to retrieve from and add the files to the SharePoint site. 

It supports operations for List and List Items API, Files, and Folders API to create, delete, retrieve, and update documents. 

The following steps are used to add the SharePoint connector in the Mule palette 

  1. From Anypoint Studio Go to -> Mule Palette -> Click Search in Exchange -> Sharepoint
  1. Add the Sharepoint into Mule Palette. 
  1. From Mule Palette, drag and drop Sharepoint connectors to your flow. 

Authentication

MuleSoft provides different authentication schemes for Microsoft Sharepoint Connector. 

  1. OAuth v2.0 Authorization Code 
  1. Sharepoint Online 
  1. Okta 
  1. Security Token 

Sharepoint Site

Get Sharepoint List Id from Your Sharepoint site 

Before start performing any operations on Sharepoint using MuleSoft, we need to get the List Id from the Sharepoint site. 

  1. Log into your SharePoint using your credential. 
  1. To click the Edit current view, select the All Documents option 
  1. The next page opens and now scroll down the page 
  1. The  Web address for this mobile view option is available to get ListId 
    https://metasofttechsolutions.sharepoint.com/sites/testsharepoint1/_layouts/15/mobile/viewa.aspx?List=98e77c5f%2D9ce8%2D487c%2Da1df%2Dd437d91067a1&View=895c1408%2D0a82%2D4ed0%2Db9f1%2Dd2acbf3ede38 

SharePoint Connector Configuration 

To create a new project in Anypoint studio, the following steps help to create it. 

  1. Click the Create button and filter the Sharepoint Online Connector
  1. Choose the connection type as Online
  1. The Example of SharePoint credential: 

Online username: samle@domain.com 

Online Password: XXXXXXXX 

Site url:  https://mstxyz.sharepoint.com/sites/testsharepoint 

  1. Ensure the connection is working by using Test connection button 

Test Flow1 

This is the sample flow to read a file from local and it is added in SharePoint using Sharepoint connector in Mule4 

Output: 

Test Flow – 2 

This is the second sample flow to read the file from Sharepoint using the Sharepoint connector in Mule4 

Output: 

   

About MST

At MST Solutions our cornerstone is to adapt, engage and create solutions which guarantee the success of our clients. The talent of our team and experiences in varied business verticals gives us an advantage over other competitors.

Recent Articles

Work with us.

Our people aren’t just employees, they are key to the success of our business. We recognize the strengths of each individual and allow them time and resources to further develop those skills, crafting a culture of leaders who are passionate about where they are going within our organization.