OneDrive / Sharepoint

This document describes the Dataworkz connector configuration required to access OneDrive/Sharepoint. It lists the steps needed to setup OneDrive/Sharepoint connected app and to configure a connector for the same in Dataworkz.

Connected App Setup

Following steps need to be followed to configure a connected app for OneDrive.

1. Register your OneDrive app on azure platform. Login to Microsoft Entra admin center for the purpose.

2. If you have access to multiple tenants, use the Settings icon in the top menu to switch to the tenant for which you want to register the application from the Directories + subscriptions menu.

User Directories and Subscriptions

1. Browse to Identity > Applications > App registrations and select New registration.

Register New App

1. Enter a display Name for your application.

Create New Connected App

1. Enter the redirect URI. This URI can be obtained by following the instructions in Creating OneDrive Connector
2. Select Register to complete the initial app registration. For more details refer Register an application with the Microsoft identity platform - Microsoft Graph to create new app.

Registered Connected App

1. Select “Add a certificate or secret“ to assign secret to the connected app that was configured above.

New Client Secret

1. Click on “New Client Secret“ to create secret.

Add Secret

1. Click on “Add“ button to create secret. Once created copy secret value as this will not be accessible later.

Connected App Secret

1. Instead of secret, you can also upload public key of key-value pair certificate. In this case private key will be used while creating configuration through Dataworkz admin UI.

Upload Certificate

1. Click the "API Permissions" link to assign permissions. Click on Microsoft Graph and then select “Application Permissions” to assign resource permissions for the connected app.

1. Add “File.Read.All“ to read and download from OneDrive

2. Add “Sites.Read.All“ for sharepoint sites files retrieval.

3. Click on “Overview“ link to go back to the connected app. Copy client Id and tenant id required to connect to OneDrive from Dataworkz admin UI.

Created Connected App

Creating OneDrive Connector in Dataworkz

1. Login to Dataworkz Application

2. Goto Configuration -> SaaS Applications -> OneDrive

3. Click the + icon to add a new configuration

   
4. Enter name for the connector (OneDrive Instance Name)

5. Select the OAuth option (currently Private Connected App is the only supported option)

Redirect URL

Connected App Exists

1. select "Yes"

2. Add Client ID/Secret & tenant ID that were copied during creation of the connected app.

3. Click "Save". This would created the OneDrive connector for the purpose of file selection during the creation of the AI applications

Connected App Doesn't Exist

1. select "No" and screen below would pop-up

2. 
3. copy the redirect URL and goto Connected App Setup. In connected app setup redirect URL should be pasted in step # 5.