Sharepoint REST HTTP 401 for specific actions

%3CLINGO-SUB%20id%3D%22lingo-sub-743607%22%20slang%3D%22en-US%22%3ESharepoint%20REST%20HTTP%20401%20for%20specific%20actions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-743607%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3ENot%20entirely%20sure%20this%20is%20the%20right%20site%20to%20even%20ask%20this%20question.%26nbsp%3B%20We%20are%20having%20an%20integration%20issue%20with%20Sharepoint%20REST%20API's.%26nbsp%3B%20We%20are%20using%20a%20tool%20similar%20to%20SSIS.%26nbsp%3B%20The%20goal%20is%20find%20all%20excel%20sheets%20in%20a%20specific%20folder%20and%20download%2Fprocess%20those%20excels.%26nbsp%3B%20We%20are%20using%20Oath%202.0%20for%20authentication.%26nbsp%3B%20We%20start%20by%20using%20an%20end%20point%20similar%20to%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehttps%3A%2F%2F%3CHOST%3E%2Fsites%2F%3CMYSITE%3E%2F_api%2Fweb%2FGetFolderByServerRelativeUrl('Shared%2520Documents%2FSomeFolderPath')%2FFiles%3C%2FMYSITE%3E%3C%2FHOST%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20produces%20us%20with%20the%20desired%20JSON%2FXML%20for%20each%20file(s)%20in%20the%20folder%20path.%26nbsp%3B%20The%20response%20contains%20the%20field%20%22ServerRelativeURL%22%20which%20is%20something%20similar%20to%20the%20below%20%3A%3C%2FP%3E%3CP%3E%2Fsites%2F%3CMYSITE%3E%2FShared%20Documents%2FFolder%20Path%2FFileName.xlsx%3C%2FMYSITE%3E%3C%2FP%3E%3CP%3EAppending%20this%20to%20the%20Host%20should%20provide%20me%20with%20each%20file.%26nbsp%3B%20Instead%20when%20I%20call%20this%20ServerRelative%20URL%20I%20get%20a%20response%20HTTP%20401.%26nbsp%3B%20I%20have%20been%20told%20that%20the%20service%20account%20created%20for%20this%20is%20a%20site%20owner%20and%20should%20have%20access%20to%20any%20documents%20read%20or%20write.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20anything%20I%20could%20be%20missing%20from%20a%20development%20standpoint%3F%26nbsp%3B%20Is%20there%20anything%20I%20could%20be%20missing%20from%20a%20sharepoint%20permissions%20standpoint%3F%26nbsp%3B%20Thanks%20for%20any%20insight%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello,

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 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) in the 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 

0 Replies