Where does upload/create files get stored when using ApplicationIdAndSecret authentication type?
Issue Description: When using the Authentication Type as ApplicationIdAndSecret where(in SharePoint) one can upload files or create folders?
Resolution: When connecting as a Service Principal, "personal" OneDrive will not be suitable, as authentication can not happen on behalf of the user.
- Create a workbook or upload a file in a document library of a SharePoint site to which the Service Principal has access to
- Ensure Azure registered application have at least these Graph API application permissions
- Files.Read.All
- Files.ReadWrite.All
- Sites.Read.All
- Sites.ReadWrite.All.