I was trying to get a file from a SharePoint document library (host-web) with the .NET Client Object Model (CSOM) in a provider hosted app. I used the OpenBinaryDirect method from the File-class.
Code Snippet
- List spList = ctx.Web.Lists.GetByTitle(“Dokumente”);
- CamlQuery camlQuery = new CamlQuery {ViewXml = String.Format(@”<View>
- <Query>
- <Where><Eq><FieldRef Name=’FileLeafRef’ /><Value Type=’File’>{0}</Value></Eq></Where>
- </Query>
- <ViewFields><FieldRef Name=’ID’ /><FieldRef Name=’FileRef’ /><FieldRef Name=’FileLeafRef’ /><FieldRef Name=’FileSizeDisplay’ /><FieldRef Name=’Title’ /></ViewFields>
- </View>”, filename)};
- ListItemCollection listItems = spList.GetItems(camlQuery);
- ctx.Load(listItems);
- ctx.ExecuteQuery();
- if (listItems.Count != 1) return null;
- var item = listItems.First();
- File file = item.File;
- ctx.Load(file);
- ctx.ExecuteQuery();
- FileInformation fileInfo = File.OpenBinaryDirect(ctx, file.ServerRelativeUrl);
But I’m getting a 401 unauthorized error, while the credentials are correct in the ClientContext.
After searching, I found this post: http://tech-karma.blogspot.se/2013/05/sharepoint-2013-online-app-403-response.html. It explained that OpenBinaryDirect is unable to evaluate the AppToken and is therefore unable to access SharePoint.
The solution is to use the OpenBinaryStream method of the File class. The result is delivered as a ClientResult. The file access works with:
Code Snippet
- //FileInformation fileInfo = File.OpenBinaryDirect(ctx, file.ServerRelativeUrl);
- var clientResultStream = file.OpenBinaryStream();
- ctx.ExecuteQuery();
- var stream = clientResultStream.Value;
The article or information provided here represents completely my own personal view & thought. It is recommended to test the content or scripts of the site in the lab, before making use in the production environment & use it completely at your own risk. The articles, scripts, suggestions or tricks published on the site are provided AS-IS with no warranties or guarantees and confers no rights.
It works great. Thank you