Where Does Upload Files / Create Folder Gets Stored When Using ApplicationIdAndSecret Authentication Type

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.

  1. Create a workbook or upload a file in a document library of a SharePoint site to which the Service Principal has access to.
  2. Ensure Azure registered application have at least these Graph API application permissions
  • Files.Read.All
  • Files.ReadWrite.All
  • Sites.Read.All
  • Sites.ReadWrite.All.