🔌Setting up a Sharepoint connector

Credentials setting in Azure

In this part, we will connect to Azure in order to authorize the Toucan App.

  • Connect to Azure with an admin account : Azure Active Directory admin center.

  • Click on Azure Active Directory, then on App registrations and then on New registration

sharepoint_1
sharepoint_1
  • Give a name to your app (for instance : Toucan) & define who can have access to this app. Click then on Register

sharepoint_2
sharepoint_2

Your app has been now declared on Azure. In the Overview screen you can have access to several informations :

  • Application (client) ID -> it will correspond to the “Client ID” in Toucan.

  • Directory (tenant) ID -> it will correspond to the “Tenant ID” in Toucan.

Now we will create a Client secret. To do so, go on the Certificated & secrets section, and click on New client secret:

sharepoint_3
sharepoint_3

Give a name (field Description) to the client secret and set the validity period:

sharepoint_4
sharepoint_4

The secret will appear just one time, so copy it now. You won’t be able to copy it again after !

sharepoint_5
sharepoint_5

Now that we created the client secret, we will define the “redirect URIs”. To do this, go on the Authentication section, then click on Add a platform, and select Web in the window on the right.

sharepoint_6
sharepoint_6

Set the URI following your configuration (sub-domain, application name & connector_name):https://api-{sub_domain}.toucantoco.com/{application_name}/oauth/redirect?connector_name={connector_name}

sharepoint_7
sharepoint_7

Note that the connector_name will be the one that we will specify after in Toucan as “name”. Once the URI has been defined, click on “Configure”.

  • Go on the API permissions section, then click on Add a permission. Click on Microsoft Graph, then on Application permissions.

sharepoint_8
sharepoint_8

Add these 2 permissions : Files.Read.All & User.Read

sharepoint_9
sharepoint_9

Sharepoint connector setting in Toucan:

Configuring a Sharepoint connection¶

Field
Format / Type
Description
Example

Name (mandatory)

String

Use it to identify your connection

Client ID (mandatory)

String

corresponds to “Application (client) ID” in Azure

Client Secret (mandatory)

String

corresponds to the secret displayed after having added a new secret in Azure

Scope (mandatory)

String

The scope determines what type of access the app is granted when the user is signed in it can be set as “offline_access Sites.Read.All”

Tenant (mandatory)

String

The tenant determines what part of your organisation you want to signed in corresponds to “Directory (tenant) ID” in Azure

Retry Policy (optional)

Boolean

Boolean allows to configure a retry policy if the connection is flaky.

  • max attempts: maximum number of retries before giving up

  • max_delay: in seconds, above the connection is dropped

  • wait_time: time in seconds between each retry

Slow Queries' Cache Expiration Time (optional)

Integer

Slow queries' cache expiration time in seconds

Create a dataset from a Sharepoint connection

Fields description :

DOMAIN : domain name of the dataset. SITE URL : URL of the sharepoint. DOCUMENT LIBRARY : library. FILE : file path. SHEET : sheet name in the file.

Misc

Error handling

When you get an error while configuring the connection, it might be a misleading information (fix in progress), try to move to the next step anyway. Click on Close, and then click on Save.

sharepoint_11
sharepoint_11

You might be redirected to Microsoft in order to authorize access. Accept the authorization:

sharepoint_12
sharepoint_12

Last updated

Was this helpful?