CrushBank SharePoint Documentation

1. Open the following link: Sharepoint App Permission Link
   1.  The link will prompt the user to accept the application with the site.selected permission.  
        
   2.  Click Accept  
2. Open Graph Explorer Link. This is the link to the Graph API Explorer, a first-party Microsoft app that gives programmatic access to every API in Microsoft 365. The permission granted to the application is delegated, and no permission is logged by CrushBank in this process.  
3. Sign into the graph explorer (top right). Once you sign in you will see the tenant name in the graph explorer UI. 
     
4. After logging in, you will need to bring up all SharePoint sites, paste the link as shown https://graph.microsoft.com/v1.0/sites?search=* 
     
5. After pasting the link in the text field, select GET from the dropdown in the leftmost part where the text field is present. 
     
6. Click on Modify Permissions to verify whether the site.read.all permission is available. If it is not available, click the Consent button
     
7. Click Run Query 
     
8. Copy the id for the SharePoint site we want to integrate. 
     
9. Replace site_id with the id copied in the previous step. https://graph.microsoft.com/v1.0/sites/{site_id}/permissions
   1. Switch from the GET method to the POST method.  
         
10. Add the following to the request body — this grants the CrushBank application read-only access, scoped to this single site only 
    {"roles":["read"],"grantedToIdentities":[{"application":{"id":"d0ec37ba-d8fa-4388-b5db-e8a4d4a4f62e","displayName":"Sharepoint Site Access"}}]}
      
11. Click on Modify Permissions (middle of page), then Open the Permissions panel
    
12. Search for the site in the search permissions text box and click Consent on site.fullcontrol.all 
      
13. Click Run Query and you should get a Success Status
14. Repeat Steps 8-13 for each site you want to into into the datalake
15. Lastly, we need tenant id for your SharePoint. Paste following link https://graph.microsoft.com/v1.0/organization to the text box and switch the method to GET and click Run Query.  
      
16. Grab tenant id which is marked as id in the response as shown in the screenshot and copy it down to send to CrushBank.  

The following information should then be sent over for CrushBank to setup your SharePoint integration:

1. Base SharePoint URL
2. Site Collection URL for each site you granted above
3. Tenant ID from above