How to download upload files from to SharePoint 2013 using CSOM

Question

I am developing a Win8  WinRT  C   XAML  client application  CSOM  that needs to download upload files from to SharePoint 2013   How do I do the Download Upload

User · Answer

Though this is an old post and have many answers, but here I have my version of code to upload the file to sharepoint 2013 using CSOM(c#)

I hope if you are working with downloading and uploading files then you know how to create Clientcontext object and Web object

/* Assuming you have created ClientContext object and Web object*/
string listTitle = "List title where you want your file to upload";
string filePath = "your file physical path";
List oList = web.Lists.GetByTitle(listTitle);
clientContext.Load(oList.RootFolder);//to load the folder where you will upload the file
FileCreationInformation fileInfo = new FileCreationInformation();

fileInfo.Overwrite = true;
fileInfo.Content = System.IO.File.ReadAllBytes(filePath);
fileInfo.Url = fileName;

File fileToUpload = fileCollection.Add(fileInfo);
clientContext.ExecuteQuery();

fileToUpload.CheckIn("your checkin comment", CheckinType.MajorCheckIn);
if (oList.EnableMinorVersions)
{
    fileToUpload.Publish("your publish comment");
    clientContext.ExecuteQuery();
}
if (oList.EnableModeration)
{
     fileToUpload.Approve("your approve comment"); 
}
clientContext.ExecuteQuery();

And here is the code for download

List oList = web.Lists.GetByTitle("ListNameWhereFileExist");
clientContext.Load(oList);
clientContext.Load(oList.RootFolder);
clientContext.Load(oList.RootFolder.Files);
clientContext.ExecuteQuery();
FileCollection fileCollection = oList.RootFolder.Files;
File SP_file = fileCollection.GetByUrl("fileNameToDownloadWithExtension");
clientContext.Load(SP_file);
clientContext.ExecuteQuery();                
var Local_stream = System.IO.File.Open("c:/testing/" + SP_file.Name, System.IO.FileMode.CreateNew);
var fileInformation = File.OpenBinaryDirect(clientContext, SP_file.ServerRelativeUrl);
var Sp_Stream = fileInformation.Stream;
Sp_Stream.CopyTo(Local_stream);

Still there are different ways I believe that can be used to upload and download.

User · Answer

File OpenBinaryDirect may cause exception when you are using Oauth  accestoken Explained in This Article  Code should be written as below to avoid exceptions   Uri filename   new Uri filepath           string server   filename AbsoluteUri Replace filename AbsolutePath                         string serverrelative   filename AbsolutePath           Microsoft SharePoint Client File file            this ClientContext Web GetFileByServerRelativeUrl serverrelative           this ClientContext Load file           ClientResult lt Stream gt  streamResult   file OpenBinaryStream            this ClientContext ExecuteQuery            return streamResult Value

User · Answer

Just a suggestion SharePoint 2013 online  amp  on-prem file encoding is UTF-8 BOM  Make sure your file is UTF-8 BOM  otherwise your uploaded html and scripts may not rendered correctly in browser

User · Answer

A little late this comment but I will leave here my results working with the library of SharePoin Online and it is very easy to use and implement in your project  just go to the NuGet administrator of  Net and Add Microsoft SharePoint CSOM to your project    https   developer microsoft com en-us office blogs new-sharepoint-csom-version-released-for-office-365-may-2017   The following code snippet will help you connect your credentials to your SharePoint site  you can also read and download files from a specific site and folder   using System  using System IO  using System Linq  using System Web  using Microsoft SharePoint Client  using System Security   using ClientOM   Microsoft SharePoint Client   namespace MvcApplication Models Home       public class SharepointModel               public ClientContext clientContext   get  set            private string ServerSiteUrl    https   somecompany sharepoint com sites ITVillahermosa           private string LibraryUrl    Shared Documents Invoices            private string UserName    someone surname somecompany com           private string Password                       private Web WebClient   get  set             public SharepointModel                         this Connect                       public void Connect                         try                               using  clientContext   new ClientContext ServerSiteUrl                                         var securePassword   new SecureString                        foreach  char c in Password                                                securePassword AppendChar c                                              clientContext Credentials   new SharePointOnlineCredentials UserName  securePassword                       WebClient   clientContext Web                                              catch  Exception ex                                throw  ex                                    public string UploadMultiFiles HttpRequestBase Request  HttpServerUtilityBase Server                        try                               HttpPostedFileBase file   null                  for  int f   0  f  lt  Request Files Count  f                                          file   Request Files f  as HttpPostedFileBase                       string   SubFolders   LibraryUrl Split                           string filename   System IO Path GetFileName file FileName                       var path   System IO Path Combine Server MapPath    App Data uploads    filename                       file SaveAs path                        clientContext Load WebClient  website   gt  website Lists  website   gt  website ServerRelativeUrl                       clientContext ExecuteQuery                           https   somecompany sharepoint com sites ITVillahermosa Shared Documents                      List documentsList   clientContext Web Lists GetByTitle  Documents      Shared Documents - gt  Documents                     clientContext Load documentsList  i   gt  i RootFolder Folders  i   gt  i RootFolder                       clientContext ExecuteQuery                         string SubFolderName   SubFolders 1    Get SubFolder  Invoice                      var folderToBindTo   documentsList RootFolder Folders                      var folderToUpload   folderToBindTo Where i   gt  i Name    SubFolderName  First                         var fileCreationInformation   new FileCreationInformation                          Assign to content byte   i e  documentStream                     fileCreationInformation Content   System IO File ReadAllBytes path                         Allow owerwrite of document                     fileCreationInformation Overwrite   true                        Upload URL                     fileCreationInformation Url   ServerSiteUrl   LibraryUrl   filename                       Microsoft SharePoint Client File uploadFile   documentsList RootFolder Files Add fileCreationInformation                          Update the metadata for a field having name  DocType                      uploadFile ListItemAllFields  Title      UploadedCSOM                        uploadFile ListItemAllFields Update                        clientContext ExecuteQuery                                       return                               catch  Exception ex                                throw  ex                                    public string DownloadFiles                         try                               string tempLocation     c  Downloads Sharepoint                    System IO DirectoryInfo di   new DirectoryInfo tempLocation                   foreach  FileInfo file in di GetFiles                                          file Delete                                       FileCollection files   WebClient GetFolderByServerRelativeUrl this LibraryUrl  Files                  clientContext Load files                   clientContext ExecuteQuery                     if  clientContext HasPendingRequest                      clientContext ExecuteQuery                     foreach  ClientOM File file in files                                        FileInformation fileInfo   ClientOM File OpenBinaryDirect clientContext  file ServerRelativeUrl                       clientContext ExecuteQuery                         var filePath   tempLocation   file Name                      using  var fileStream   new System IO FileStream filePath  System IO FileMode Create                                                 fileInfo Stream CopyTo fileStream                                                            return                               catch  Exception ex                                throw  ex                                       Then to invoke the functions from the controller in this case MVC ASP NET is done in the following way      using MvcApplication Models Home  using System  using System Web Mvc   namespace MvcApplication Controllers       public class SharepointController   MvcBoostraBaseController                HttpPost          public ActionResult Upload FormCollection form                        try                               SharepointModel sharepointModel   new SharepointModel                    return Json sharepointModel UploadMultiFiles Request  Server   JsonRequestBehavior AllowGet                             catch  Exception ex                                return ThrowJSONError ex                                    public ActionResult Download string ServerUrl  string RelativeUrl                        try                               SharepointModel sharepointModel   new SharepointModel                    return Json sharepointModel DownloadFiles    JsonRequestBehavior AllowGet                             catch  Exception ex                                return ThrowJSONError ex                                     If you need the source code of this project you can request it to israelz11 hotmail com

User · Answer

Private Sub DownloadFile relativeUrl As String  destinationPath As String  name As String      Try         destinationPath   Replace destinationPath         name                     Dim fi As FileInformation   Microsoft SharePoint Client File OpenBinaryDirect Me context  relativeUrl          Dim down As Stream   System IO File Create destinationPath          Dim a As Integer   fi Stream ReadByte           While a  lt  gt  -1             down WriteByte CType a  Byte               a   fi Stream ReadByte           End While     Catch ex As Exception         ToLog Type ERROR  ex Message      End Try End Sub

User · Answer

This article describes various options for accessing SharePoint content  You have a choice between REST and CSOM  I d try CSOM if possible  File upload   download specifically is nicely described in this article   Overall notes         First construct client context  the object which will be responsible for       communication with SharePoint      var context   new ClientContext   http   site absolute url          then get a hold of the list item you want to download  for example     var list   context Web Lists GetByTitle  Pipeline        var query   CamlQuery CreateAllItemsQuery 10000       var result   list GetItems query          note that data has not been loaded yet  In order to load the data       you need to tell SharePoint client what you want to download       context Load result  items  gt items Include          item   gt  item  Title            item   gt  item  FileRef                  now you get the data     context ExecuteQuery           here you have list items  but not their content  files   To download file       you ll have to do something like this       var item   items First           get the URL of the file you want      var fileRef   item  FileRef           get the file contents      FileInformation fileInfo   File OpenBinaryDirect context  fileRef ToString          using  var memory   new MemoryStream                    byte   buffer   new byte 1024   64             int nread   0            while   nread   fileInfo Stream Read buffer  0  buffer Length    gt  0                            memory Write buffer  0  nread                         memory Seek 0  SeekOrigin Begin                    here you have the contents of your file in memory                do whatever you want         Avoid working with the stream directly  read it into the memory first  Network-bound streams are not necessarily supporting stream operations  not to mention performance  So  if you are reading a pic from that stream or parsing a document  you may end up with some unexpected behavior   On a side note  I have a related question re  performance of this code above  as you are taking some penalty with every file request  See here  And yes  you need 4 5 full  NET profile for this

User · Answer

I would suggest reading some Microsoft documentation on what you can do with CSOM  This might be one example of what you are looking for  but there is a huge API documented in msdn      Starting with ClientContext  the constructor requires a URL to the     server running SharePoint   ClientContext context   new ClientContext  http   SiteUrl         Assume that the web has a list named  Announcements    List announcementsList   context Web Lists GetByTitle  Announcements         Assume there is a list item with ID 1   ListItem listItem   announcementsList Items GetById 1        Write a new value to the Body field of the Announcement item  listItem  Body      This is my new value      listItem Update      context ExecuteQuery       From  http   msdn microsoft com en-us library fp179912 aspx

User · Answer

Upload a file  Upload a file to a SharePoint site  including SharePoint Online  using File SaveBinaryDirect Method   using  var clientContext   new ClientContext url          using  var fs   new FileStream fileName  FileMode Open                   var fi   new FileInfo fileName            var list   clientContext Web Lists GetByTitle listTitle            clientContext Load list RootFolder            clientContext ExecuteQuery             var fileUrl   String Format   0   1    list RootFolder ServerRelativeUrl  fi Name             Microsoft SharePoint Client File SaveBinaryDirect clientContext  fileUrl  fs  true              Download file  Download file from a SharePoint site  including SharePoint Online  using File OpenBinaryDirect Method   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   gt  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

[c#] How to download/upload files from/to SharePoint 2013 using CSOM?

Examples related to c#

Examples related to windows-8

Examples related to sharepoint-2013

Examples related to csom