Not entirely sure this is the right site to even ask this question. We are having an integration issue with Sharepoint REST API’s. We are using a tool similar to SSIS. The goal is to find all excel sheets in a specific folder and download/process those excels. We are using Oath 2.0 for authentication. We start by using an end point similar to: https://<HOST>/sites/<MYSITE>/_api/web/GetFolderByServerRelativeUrl(‘Shared%20Documents/SomeFolderPath’)/Files
This produces us with the desired JSON/XML for each file(s) int he folder path. The response contains the field “ServerRelativeURL” which is something similar to the below :
/sites/<MYSITE>/Shared Documents/Folder Path/FileName.xlsx
Appending this to the Host should provide me with each file. Instead, when I call this ServerRelative URL I get a response HTTP 401. I have been told that the service account created for this is a site owner and should have access to any documents read or write.
Is there anything I could be missing from a development standpoint? Is there anything I could be missing from a SharePoint permissions standpoint? Thanks for any insight
How have you set up the OAuth? Did you create an application registration for your SSIS code to run? Are you retrieving a valid Authentication Token and passing it as a Bearer in your Authorization header?
