SharePoint List as Data Source

Setup AzureAD

Add New App Registration

Add a new registration under App registrations > New registration.

Tipp: When naming the new app, choosing a recognisable name like External Data for Confluence can help you to properly identify the application later.

Certificates & Secret

Go to Certificates & secrets > Client secrets > New client secret

Add a meaningful description and set an expiration date. Keep in mind that you’ll have to update the data source once the secret expires.

Important: Please make sure to note down the secret value, which is only visible immediately after creation. You will need this value later when setting up the data source

API Permissions

Go to API permissions > Add a permission

Select Microsoft Graph > Application permissions

Now select the API / Permission Sites.Read.All permission.

This permission needs Admin consent so we allow Grant admin consent for ...

Collect Endpoint & ClientID

Go to Overview > Endpoints and copy the following endpoint:

CODE

OAuth 2.0 token endpoint (v2)

Go to Overview > Application (client) ID and note the value.

Setup External Data

Create New Data Source

Create a new data source under External Data for Jira Fields > Data Sources > Add Data Source.

Authentication:

Select Authentication OAuth2 > Grant Type > Client Credentials

Client ID & Client Secret

Enter the Client ID, which you can find at Overview > Application (client) ID

The Client Secret is the secret value created in the Certificates & secrets section. Please insert the noted value here.

Endpoints

Endpoints are service specific URLs for receiving an access token. Since we are using the client credentials flow, we only need the token endpoint.

Token Endpoints:

CODE

Token Url: https://login.microsoftonline.com/{tenant}/oauth2/v2.0/token

Scopes

Scopes define the permission to specific parts of the data. Since we are using the Client Credentials Flow, we simply set the scope to:

CODE

https://graph.microsoft.com/.default

Make sure that an administrator grants you the required permissions that you need for setting up the Azure backend configuration.

Authenticate

Click Authenticate to retrieve your access token.

URL

We need 2 steps to get the correct endpoint for one file.

Our example SharePoint List looks like this.

Step 1: Get SharePoint Site ID

Now we need to get the SharePoint Site ID where the list is located by using the following url:

CODE

https://graph.microsoft.com/v1.0/sites/{host-name}:/{server-relative-path}

In our example:

https://graph.microsoft.com/v1.0/sites/w04ss.sharepoint.com:/sites/w04ss

Result:

Copy the value of id.

Step 2: Get List from a SharePoint Site

CODE

https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-name}/items?expand=fields

Replace {site-id} with the result value of id from the "Get SharePoint Site ID" request.

Replace{list-name} with the name of the list.

In our example:

CODE

https://graph.microsoft.com/v1.0/sites/w04ss.sharepoint.com,6769358c-5ce8-40be-bb78-bd8e4269d577,8ba6337a-c6a9-4b24-aa0e-b1d722ad302f/lists/Customers/items?expand=fields

Result:

Save and test the data source to ensure that everything works as intended.