Denodo - Generating a Base URL for a SharePoint App

This article provides step-by-step instructions on how to generate a base URL for a custom SharePoint app in Denodo.

Generate the URL by combining the following components:

  1. https://uillinoisedu.sharepoint.com/sites/
  2. [SiteName]
    1. For [SiteName] in the Base URL, use the name of a SharePoint site (without spaces) that you have access to.
    2. Example: TestSiteforDenodoImplementation.
  3. /_api/Web/GetFileByServerRelativePath(decodedurl=''@sp_path'')/$value
    NOTE: This uses an interpolation variable for the “path”. This is what will make the connection reusable.

Example Base URL: https://uillinoisedu.sharepoint.com/sites/TestSiteforDenodoImplementation/_api/Web/GetFileByServerRelativePath(decodedurl=''@sp_path'')/$value

Best Practice: Only use the SharePoint App credentials in a single Denodo connection. Creating more than one Denodo connection that re-uses the same SharePoint Client ID will cause the access tokens associated with that Client ID to interrupt one another and your integration will become unstable.


Keywords:
SharePoint 
Doc ID:
137235
Owned by:
Learning Systems Support in UI Training and Development Resources
Created:
2024-05-09
Updated:
2024-07-02
Sites:
University of Illinois Training and Development Resources