Applies to:
Denodo 8.0
Last modified on: 25 Jan 2022
Tags:
Azure
DF data sources
OAuth
SharePoint
In this document we explain how to create an Excel data source in Denodo that retrieves an Excel file stored in SharePoint 365 using the Sharepoint API. The same steps can be performed for JSON, XML or Delimited files as well.
It is also possible to access SharePoint lists using OData following the steps described in How to connect Denodo to Sharepoint Online using OData with OAuth authentication. Unless you need to access SharePoint using OData the procedure explained in this document is the recommended approach.
For the SharePoint application to be accessible, API permissions have to be configured. A client application token has to be generated for the access token. In order to generate the token the following has to be done in the Azure Portal:
After having registered the app, we have to generate a new client secret key. In order to generate the key:
The API access is now set up to connect Denodo to SharePoint.
In the App Registration page in the Azure portal, select the app that has been registered for the SharePoint integration with Denodo:
In this section we will explain how to create an Excel data source in Denodo to read Excel files from SharePoint.
https://<tenant_name>.sharepoint.com/sites/site/_api/Web/GetFileByServerRelativePath(decodedurl='<location of an Excel file in the sharepoint>')/$value Note: For some scenarios, the site parameter of the URL may need to be modified according to the company’s Sharepoint structure. Review this URL with your Sharepoint administrator to make sure you use the correct one for your specific installation. |
https://login.microsoftonline.com/<tenant_id>/oauth2/v2.0/authorize |
Remember to replace <tenant_name> with your actual tenant name. The value offline_access is required in order to obtain the refresh token.
https://localhost:9443/oauth/2.0/redirectURL?code=<>&state=<>&session_state=<># |
Once the OAuth 2.0 Credentials are obtained , test the connection to check if the connection can be established.
Now you will be able to create a new Base view from this Excel data source.
Quickstart: Register an application with the Microsoft identity platform