SharePoint And Retool: Difference between revisions
Jump to navigation
Jump to search
Created page with "=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 ==Settings in Retool (SharePoint)== Here is the connector in Retool<br> File:Retool SharepointAPI Hidden.png" |
|||
| (5 intermediate revisions by the same user not shown) | |||
| Line 9: | Line 9: | ||
Here is the connector in Retool<br> | Here is the connector in Retool<br> | ||
[[File:Retool SharepointAPI Hidden.png]] | [[File:Retool SharepointAPI Hidden.png]] | ||
*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 | |||
<br> | |||
'''Getting the site id'''<br> | |||
Go to the SharePoint site. Right click and view source and search for siteId<br> | |||
[[File:SharePointSiteId hidden.png]]<br> | |||
'''Getting the driver id'''<br> | |||
We need to query the SharePoint site using MS Graph and the site id obtained above. | |||
<syntaxhighlight lang="bash"> | |||
https://graph.microsoft.com/v1.0/sites/<siteId>/drives | |||
</syntaxhighlight> | |||
We can use postman to get this information using the Token URL, Client Id and Client Secret obtained above.<br> | |||
[[File:Postman Sharepoint hidden.png |300px]]<br> | |||
This should return the drive id in the id json field<br> | |||
[[File:Postman Graph Result hidden2.png| 300px]] | |||
Latest revision as of 02:05, 24 February 2022
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
