🔌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

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

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

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

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

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

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

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

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

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

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

sharepoint_12