Sharepoint

Updated on

Oct 19, 2023

{% docs-informer warning title="Available by request only" %}

Please, contact your Customer Success Manager for more information.

{% docs-informer-end %}

Description

‍Sharepoint is a web-based collaborative platform that integrates natively with Microsoft Office.

Schema information

Setup guide

Follow our setup guide to connect Sharepoint to Improvado.

‍Step 1. Click the Data Sources in the left navigation bar.
Categories on the Data sources page group all available platforms. Use a search to find the required one.

‍Step 2. Click on the Sharepoint tile.

Step 3. To authorize your account, you need to fill in the required fields below following steps 3.1 - 3.14:

Tenant
Resource
Tenant ID
Client ID
Client Secret

Step 3.1. Go to Azure Active Directory > Enterprise applications > Consent and permissions in the Azure Portal.

‍Step 3.2. Go to User consent settings. Select Allow user consent for apps from verified publishers for selected permissions. Click Save.

‍Step 3.3. Go to Permission classifications. Click Add permissions.

‍Step 3.4. Select Microsoft Graph. Add the following permissions:

Permission	Additional information
```Sites.Read.All```	Read items in all site collection
```Files.Read```	Read user files
```offline_access```	Maintain access to data you have given it access to
```profile```	View users' basic profile
```openid```	Sign users in
```email```	View users' email address

Step 3.5. Go to Admin consent settings.

‍Step 3.6. Set the Users can request admin consent to apps they are unable to consent to toggle to Yes.

‍Step 3.7. Go to Azure Active Directory > App Registrations > New Registration the Azure Portal. Enter the name and click Register.

‍Step 3.8. In the Overview section of your app, copy the Application (Client) ID and Tenant ID values.

‍Step 3.9. Go to API permissions > Add a permission > Microsoft Graph > Application permissions > Add Sites.FullControl.All permission.

‍Step 3.10. Click Grant Admin Consent for your tenant name, and then click Yes.

‍Step 3.11. Go to Certificates & secrets > Add New client secret. Make a note of the value. You will need this Client Secret value in the next step.

Step 3.12. Tenant value is your organization identifier: ```https://{your-tenant-prefix}-admin.sharepoint.com```.

‍Step 3.13. Resource is the following fixed value that you need to copy: ```00000003-0000-0ff1-ce00-000000000000```.

‍Step 3.14. Enter copied values into the Improvado authorization form.

Also, you can find the additional information and in-depth step-by-step guide at the links here:

Step 4. After completing the connection process, the Sharepoint connection will appear in your Connected sources list.

‍Step 5. When the connection status is Active and the account status column shows a number of accounts, you can move on to data extraction.