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.



KeywordsSharePoint   Doc ID137235
OwnerLearning Systems SupportGroupUI Training and Development Resources
Created2024-05-09 14:08:38Updated2024-07-02 11:20:57
SitesUniversity of Illinois Training and Development Resources
Feedback  0   0