SAP Cloud Platform Open Connectors

SharePoint API Provider Setup

API Provider Setup

To authenticate a Sharepoint connector instance, you must register an app with Microsoft. When you authenticate, use the Client Id, Client Secret, and Redirect URI as the API Key (oauth.api.key), API Secret (oauth.api.secret), and Callback URL (oauth.callback.url). You'll also need your Sharepoint Site Collection URL as the Sharepoint Site Address (sharepoint.site.address). The Sharepoint Site Collection URL is the initial portion of your URL, for example in https://cloudelements1.sharepoint.com/SitePages/DevHome.aspx, cloudelements1 is the Sharepoint Site Collection URL.

Note the following: * Even though OAuth has security inherent in the protocol, OAuth authentication with SharePoint must use https, so your version of Sharepoint must have https enabled for OAuth to work. You can use OAuth internally as a dev environment without https, but it will not connect externally to the SharePoint connector. * Note that our SharePoint connector works with the Sharepoint REST API. Not all versions of SharePoint support the 2013 API so verify the level supported by the endpoint you’re connecting to.

See the latest setup instructions in the Microsoft documentation.

Register an Application

These steps include instruction to register by using AppRegNew.aspx. Microsoft provides other ways, including registration through Microsoft Visual Studio. See their documentation for more details.

To register an application:

  1. Go to https://<site collection url>/_layouts/15/AppRegNew.aspx, replacing <site collection url> with your actual url. For example in https://cloudelements1.sharepoint.com/SitePages/DevHome.aspx, cloudelements1.sharepoint.com is the Sharepoint Site Collection URL.
  2. Complete the forms by entering your information or generating the id and secret.
  3. Enter the callback URL for your application in Redirect URI.
  4. Click Create.
  5. Record the Client Id and Client Secret.
  6. Record the Redirect URI for your app. Key secret and URL

Enable Sharing

When enabling the SharePoint connector, be sure that sharing is enabled by your admin in the instance of SharePoint you are connecting with. Sharing is disabled by default when Sharepoint is initially started.

For detailed steps from Microsoft, see https://support.office.com/en-us/article/turn-external-sharing-on-or-off-for-sharepoint-online-6288296a-b6b7-4ea4-b4ed-c297bf833e30.

To turn on External Sharing:

  1. Select the app launcher icon launcher, and the click Admin to open the Office 365 admin center.
  2. In the left pane, choose Admin centers > SharePoint. Admin
  3. On the Sharepoint Admin Center page, click sharing in the left menu.
  4. Under Sharing outside your organization, select Allow sharing to authenticated external users and using anonymous access links.
  5. Set up any additional settings that you want, and then click OK.

In the left pane, click sharing.