Prepare Your Microsoft SharePoint Unstructured Connection

To set up your Microsoft SharePoint unstructured content with Data 360, configure details in the Microsoft Azure Portal.

  • Configure a Microsoft Azure app to establish a connection between Salesforce and Microsoft.
    • Make note of the Application (client) ID, Client Secret Value, and Directory (tenant) ID.
    • Add these additional permissions to the App
      • Option A - Broad Access
        This option grants your application broad access to all SharePoint Sites, which is simpler to set up. Add following permissions:
        • Files.Read.All
        • Sites.Read.All
      • Option B - Secure Workaround (Restricted Access)
        This option uses the more restrictive Sites.selected permission, requiring an extra step to explicitly grant the application access to specific sites.

        • Files.Read.All

        • Sites.Selected

          Be sure to click Grant Admin Consent for [your organization] to apply the permissions for whichever option you choose.

Grant App Access to a Specific SharePoint Site (For Option B Only)

If you choose the Sites.Selected permission, your application can’t access any site by default. Explicitly grant it access to the target site(s) before proceeding. This step requires a SharePoint or Global admin account with the Sites.FullControl.All scope.

  1. Retrieve Site ID: Go to your SharePoint site and append /_api/site/?$select=id to the site URL, for example, https://yourcompany.sharepoint.com/sites/dottedcloud-integration-testing/\_api/site/?$select=id. This returns a short-form Site ID.
  2. Request App Permission: Use an API client like Postman, and send a POST request with the admin's access token to grant your app read access.
    • Request URL: POST https://graph.microsoft.com/v1.0/sites/{siteId}/permissions
    • Headers:
      • Authorization: Bearer <admin_access_token>
      • Content-Type: application/json
    • Body (JSON):
      JSON

Locate Your SharePoint Site ID

You need your SharePoint Site ID to create an unstructured data lake object. Ask your SharePoint administrator, or do one of the following:

  • Go to the SharePoint site and click Settings. Select Site information. The ID is under the URL heading.
  • Alternatively, place the URL of your SharePoint site within a browser and append /_api/site/id/ to the end of the URL. For example: https://yoursite.sharepoint.com/sites/dir/\_api/site/id. The API returns a message. Note the value for Edm.Guid, as this is your Site ID.