I have tried to create a connection to the sharepoint REST api. I’m struggling with the access to the sharepoint, as I need to gain an access token first. The reason I’m doing this, is I want to retrieve a file from a sharepoint drive to generate a data table from it. Has anyone ever done this, or has anyone ever had a similar task which could be solved in any other way. I’d appreciate an advice on this topic.
Thank you and all the best,
I have done a little bit of research on that topic. What I learned is, that you have to register an Application within the Azure AD Admin Center, which hast to be done by anyone with an administrative account. For this registration one gets a client id, which then can be used in a REST call to the Graph-API of Microsoft. Fron that you will receive an Access Token. By using this Access Token, you can gain access to the REST API of Sharepoint, and further more can access files on Sharepoint.
From my point of view, this is very powerful but yet also quite dangerous, as you could change the data using the API. Our topic was to load an Excel in OD automatically to create a data table.