Importing Artifacts¶

After creating the OAuth tokens, you have all the data needed to use the SharePoint for OData wizard. Click the menu File > New > Data source and select Microsoft SharePoint for OData.

Microsoft SharePoint for OData wizard¶

Enter the following parameters:

• Database. Name of the database in which the SharePoint data sources and views will be created.

• View name prefix. The name prefix of every view created in order to be able to relate VDP views to SharePoint Online sites. The max length of this parameter is 10 characters.

• SharePoint Online service name . Your SharePoint Online service name (tenant name).

• Realm . The realm obtained in the previous step.

• Client ID. The client id generated when registering the Azure app.

• Client Secret. The client secret generated when registering the Azure app.

• Access token . The access token generated in the previous step.

• Refresh token . The refresh token generated in the previous step.

• Site name. The site name of the specific SharePoint Online site you want to retrieve the OData entities.

Now, click Execute import to create the data sources and the views to query SharePoint.

SharePoint data source and views created¶

Query Example¶

Now, you can execute queries on the SharePoint Online views that have been created.

Querying bv_site2_sitepages view¶

bv_site2_sitepages query results¶