How to download document from SharePoint document library

Sumit Deshmukh

11y4.4k

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

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Krishna Murthy11y ago
Sumit, were you able to resolve the issue?

Krishna Murthy11y ago

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 Deshmukh11y ago
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 Murthy11y ago
Hi Sumit,
make the below changes in web.config and try
<system.web> <customErrors mode="Off"/> <trust level="Full" /> </system.web>
Sumit Deshmukh11y ago
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 Murthy11y ago
Hi Sumit,

Can you use array of filestream object for multiple files?
Sumit Deshmukh11y ago
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 Deshmukh11y ago
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 Murthy11y ago
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 Bhoir11y ago
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[^]