How to download document from SharePoint document library

Question

Hello Everyone While developing I stuck to download the single document and also multiple document from SharePoint document library which is in Office 365 site. I have created Sandbox Solution while developing such things i observed SPFile.OpenBinaryStream is not available into sandbox solution (namespace Microsoft.SharePoint.dll ).to get the file. Do how to download single and multiple document from document library? -- I tired also zip functionality using http://www.sharepointanalysthq.com/2012/10/download-multiple-documents-for-sharepoint-2010/ --DeviantPoint.DownloadZip also but not getting any result. Many Thanks Sumit

Krishna Murthy · Answer

Sumit were you able to resolve the issue?

Krishna Murthy · Answer

Hi Sumit Can you try with this code please using ( var ctx = new ClientContext ( siteUrl ) ) { ctx . Credentials = new SharePointOnlineCredentials ( userName  secureStringPassword ); var query = new CamlQuery { ViewXml =   +   +   +   +   +  0  +   +   +   +   }; var web = ctx . Web ; var list = web . Lists . GetByTitle ( library ); var items = list . GetItems ( query ); ctx . Load ( items  collection => collection . Include ( i => i . File . ServerRelativeUrl  i => i . File . Name ) ); ctx . ExecuteQuery (); if ( items != null ) foreach ( var item in items ) { using ( var fi = File . OpenBinaryDirect ( ctx  item . File . ServerRelativeUrl ) ) { FileStream fileStream ; using ( fileStream = new FileStream ( @ fileDestination  FileMode . Create ) ) { if ( fi != null ) fi . Stream . CopyTo ( fileStream ); } } } }

Sumit Deshmukh · Answer

Hi Krishna Many Thanks for your prompt reply. I am working on Office 365 Online SharePoint Environment I believe do we not have access or modify the web.config file for public-facing site with SharePoint Online.Meanwhile i checked with on Premise SharePoint 2013 web.conf file which already have trust level =Full... Do you please let me know any way we can get the solution.. Thanks you Sumit

Krishna Murthy · Answer

Hi Sumit make the below changes in web.config and try system.web > customErrors mode = Off / > trust level = Full / > / system.web >

Sumit Deshmukh · Answer

Hi Krishna I did try using file stream and file path I got below error Security exception was unhandled by user code Request for the permission of type 'System.Security.Permissions.SecurityPermission mscorlib Version=4.0.0.0 Culture=neutral PublicKeyToken=b77a5c561934e089' failed. and did try several way to workout but still stuck. Thanks Sumit

Krishna Murthy · Answer

Hi Sumit Can you use array of filestream object for multiple files?

Sumit Deshmukh · Answer

How we can download multiple document from SharePoint Document library?As I am using Sandbox Solution. For single document we can download by hyperlink redirection we do need to download multiple functionality.Any solution appreciate.

Sumit Deshmukh · Answer

Hi Krishna How we can download multiple document from SharePoint Document library?As I am using Sandbox Solution. For single document we can download by hyperlink redirection we do need to download multiple functionality.Any solution appreciate. Thanks Sumit

Krishna Murthy · Answer

Hi Sumit did you try with File.OpenBinaryDirect(clientcontext fileref) Here is the solution using (var clientContext = new ClientContext(url)) { var list = clientContext.Web.Lists.GetByTitle(listTitle); var listItem = list.GetItemById(listItemId); clientContext.Load(list); clientContext.Load(listItem i => i.File); clientContext.ExecuteQuery(); var fileRef = listItem.File.ServerRelativeUrl; var fileInfo = Microsoft.SharePoint.Client.File.OpenBinaryDirect(clientContext fileRef); var fileName = Path.Combine(filePath(string)listItem.File.Name); using (var fileStream = System.IO.File.Create(fileName)) { fileInfo.Stream.CopyTo(fileStream); } }

Manoj Bhoir · Answer

Hi Sumit Check these links : MSDN Blog: How to download files from a SharePoint document library remotely [ ^ ] SharePoint: Download document Library file From Remote Client [ ^ ]