Alternative Save/OpenBinaryDirect methods for CSOM for SharePoint Online

Question

Alternative Save/OpenBinaryDirect methods for CSOM for SharePoint Online

10031103 41

Based on the doc from MS
https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/using-csom-for-dotnet-standard

So for .NET core app, what is the alternative way to read/write files stored in SharePoint online? what is the regular file API? does anyone done this? any example code/documentation?

Accepted answer

2 additional answers

Your answer

Answer 1

MichaelHan-MSFT 18,126

You could use the file.OpenBinaryStream() to read/write files stored in SharePoint, below is my demo code for your reference:

        Microsoft.SharePoint.Client.File file = context.Web.GetFileByUrl("https://tenant.sharepoint.com/sites/michael/Shared%20Documents/aa.txt");
        context.Load(file);
        context.ExecuteQuery();       

        Microsoft.SharePoint.Client.ClientResult<Stream> mstream = file.OpenBinaryStream();
        context.ExecuteQuery();

        using (System.IO.StreamReader sr = new System.IO.StreamReader(mstream.Value))
        {
          String line = sr.ReadToEnd();
          Console.WriteLine(line);
        }

Fabio Brandão 6 Reputation points

2021-03-03T00:11:24.13+00:00

Very useful! Thank you!

But I would like to know how to upload a (local) file to a Folder.

The key is before the BinaryWriter, but I couldn't figure out.

Can you help me?
MichaelHan-MSFT 18,126 Reputation points

2021-03-08T07:07:43.693+00:00

Hi @Fabio Brandão ,

For your new question, I would suggest you ask a new question in the forum.
Steve Cochrane 6 Reputation points

2022-06-22T08:15:54.477+00:00

Hello! Since this original post helped, I thought I'd "pay it forward" (if you're still looking for help). Here's how:

At line 7, add the following snippet of code:

using (var fileStream = new System.IO.FileStream(destFilepath, System.IO.FileMode.Create))
{
mstream.Value.CopyTo(fileStream);
}

The "destFilepath" string is where you want to have the file name and folder structure locally (or in OneDrive). For example, it can be "C:\tmp\DownloadedFiles\folder1\filename.pdf" or similar, anywhere on your local computer. If a folder doesn't exist (e.g., "folder1"), the script will add it.

Good luck!

Steve in Spain

Answer 2

Grmacjon-MSFT 19,301 Moderator

Hi @10031103 ,

Welcome to Microsoft Q&A! Currently, Microsoft Q&A supports the products listed over here (more to be added later on).

Your question about Alternative Save/OpenBinaryDirect methods for CSOM for SharePoint Online is not yet supported on this platform. You could ask about this in the SharePoint Developers forums:https://techcommunity.microsoft.com/t5/sharepoint-developer/bd-p/SharePointDev

Thanks,

Grace

Answer 3

trevorseward 11,711

.NET Standard CSOM is now available as of June 23rd on NuGet. You should be able to use this CSOM binary with your .NET Core app.

10031103 41 Reputation points

2020-07-16T05:28:01.333+00:00

Unfortunately, MS drop some features, including this one, you can check this video: https://youtu.be/mb6OEDOhVW4, @ 2:35

Share via

Alternative Save/OpenBinaryDirect methods for CSOM for SharePoint Online

2 additional answers

Your answer