Skip to Content
Technical Articles

Connect to SharePoint Online via SAP Cloud Platform Open Connectors

SAP Cloud Platform Open Connectors simplifies and accelerates connectivity to third-party cloud applications. It provides robust, feature rich, connectors to an extensible library of over 160 of the most popular third-party cloud applications.

In this blog, we showcase steps to connect to your SharePoint account using SAP Cloud Platform Open Connectors.

Prerequisites

Configuration on SharePoint Online

For using the SharePoint connector from SAP Cloud Platform Open Connectors, you will need an OAuth key and Secret to connect to your SharePoint Online account. In this section, configurations required to connect to your SharePoint Online account has been covered.

  • Logon to your Azure Portal using your SharePoint online credentials.
  • Navigate to Azure Active Directory and select App Registrations. Click New registration to create an OAuth application.

 

  • In the application registration prompt, enter an application name say SharePointOAuthApp, select the supported account types and in the Redirect URI enter the redirect URI for SAP Cloud Platform Open Connectors, which is https://auth.cloudelements.io/oauth

 

  • The registered application by default only has the User.Read permission from Microsoft Graph APIs and you will need to add in the required permission to access SharePoint REST APIs. Select API permissions tab and then click on Add a permission to add in the permissions for SharePoint REST APIs.

 

  • Select SharePoint to add in the API permissions for SharePoint.

  • In SAP Cloud Platform Open Connectors, access to the API is via the signed-in user. Select Delegated Permissions for accessing APIs as signed-in user.

  • Select the Permissions as shown in the screenshot below and select Add permissions

  • Some of the selected permissions would require administrator consent.  After the permission is selected, click on Grant admin access .  The permission may take some time to updated as shown in the warning, so wait for few minutes before selecting the Grant admin consent option.

  • You may be prompt to confirm the administrator consent. Select Yes.

  • After successful operation, the status would change to Granted for your user.

  • For connecting to your SharePoint Online account from SAP Cloud Platform Open Connectors, OAuth secret is required.To get your OAuth Secret, select Certificates & secrets tab, click on New client secret.

 

  • Enter a description for your OAuth secret say oauthsecret, select the expiry time, select Add.

  • Copy and note down the generated client secret, you will need to provide this while creating SharePoint connector instance from SAP Cloud Platform Open Connectors.The generated client secret cannot be retrieved later.

 

  • For connecting to your SharePoint Online account from SAP Cloud Platform Open Connectors, OAuth client ID is required.To get your OAuth client ID , select Overview tab, copy the Application (client) ID value.

 

Create SharePoint connector instance from SAP Cloud Platform Open Connectors

In this section, steps to create SharePoint connector instance from SAP Cloud Platform Open Connectors is captured.

SAP Cloud Platform Open Connectors is available for test, explore and try out in SAP Cloud Platform trial. If you have not enabled SAP Cloud Platform Open Connectors in your trial tenant, refer this blog to enable it.

 

 

  • From the services tab, search and select Open Connectors tile and click on the Go to Service link.

 

  • You would be navigated to SAP Cloud Platform Open Connectors Home or Landing page.

  • Click on the Connectors tab to view all the available pre-built, feature rich connectors. Search for the SharePoint connector by entering SharePoint in the search region.

  • Hover over the Sharepoint connector and select the option Authenticate to connect to your own SharePoint account.

  • In the connection wizard, enter a name for your connector instance say mysharepointdemo, Enter your Sharepoint Site Address in the format {your_sharepoint_domain}.sharepoint.com, Enter your copied OAuth Client ID in the API Key text field, Enter your copied OAuth secret in the API Secret text field. Select Create Instance

  • You may be prompted to enter your SharePoint user credentials. In case, you are already logged into your SharePoint account the logged in session may be automatically taken by the browser.

  • You may be prompted to trust the SharePoint OAuth application. Select Trust It

  • After the authenticated connection to your SharePoint account has been created successfully you would be able to test out the connection from SAP Cloud Platform Open Connectors. To try out the SharePoint connector APIs, click on the option Test in the API Docs.

 

  • This would launch the integrated OpenAPI specification based API Documentation for your SharePoint connector, so that you can test and try out the connector from SAP Cloud Platform Open Connectors.
  • Select any of the available Resources say /sites/list-by-title/{title}/items and click on Try it Out to test the connectivity to SharePoint connector and then click on the Execute Button

 

With this you have successfully created a SharePoint connector instance from SAP Cloud Platform Open Connectors. You would be able to use this connector instance from your SAP Cloud Platform Integration to integrate data from SAP system to SharePoint or build an application connecting to your SharePoint account.

More information about Pre-built connectors features like normalized search, pagination, bulk, eventing is available in help documentations

To know more about SAP Cloud Platform Open Connectors visit us at SAP Community

Be the first to leave a comment
You must be Logged on to comment or reply to a post.