# 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
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs-v3.toucantoco.com/data-management-in-datahub/datasources-in-toucan/managing-connectors/setting-up-a-connector/online-services-connectors/setting-up-a-sharepoint-connector.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
