SharePoint And Retool
Jump to navigation
Jump to search
Introduction
May useful for other Azure questions but mostly to ensure I don't forget
Retool
This is a point and click App which you can create web front-end apps. It provides
- authentication
- connectors to other resources S3, Sharepoint etc
- controls which can be used
Here is the connector in Retool
- Base URL - https://graph.microsoft.com/v1.0/sites/<site id> /drives/<drive id>/
- Authorization URL - https://login.microsoftonline.com/<tenant id>/oauth2/v2.0/authorize
- Access Token URL - https://login.microsoftonline.com/<tenant id>/oauth2/v2.0/token
- Client Id - This is the Application (client) ID for the Azure App Registration
- Client Secret - On of the Client Secrets for the Azure App Registration
Getting the site id
Go to the SharePoint site. Right click and view source and search for siteId
Getting the driver id
We need to query the SharePoint site using MS Graph and the site id obtained above.
https://graph.microsoft.com/v1.0/sites/<siteId>/drives
We can use postman to get this information using the Token URL, Client Id and Client Secret obtained above.
This should return the drive id in the id json field
