c# - Accessing Sharepoint online with MFA through C#

Question

I'd like to download a file from Sharepoint online using a non-interactive C# program. Recently MFA was enabled, and since then I'm unable to get the files with any user through my code, though I can still access it through the portal web access.

At first I have tried using the following, getting an The sign-in name or password does not match one in the Microsoft account system. when executing the query (using either [e-mail] or [e-mail])

var ctx = new ClientContext(Properties.Settings.Default.SharepointBaseUrl)
{
    Credentials = credentials,
};

var web = ctx.Web;

ctx.Load(web);
try
{
    ctx.ExecuteQuery();
}
catch (Exception ex)
{
    return string.Empty;
}

var fileUrl = $"{web.ServerRelativeUrl}/{file.Location}";
var fi = Microsoft.SharePoint.Client.File.OpenBinaryDirect(ctx, fileUrl);

Then I generated an AppId and AppSecret, and used the following code:

var authenticationManager = new OfficeDevPnP.Core.AuthenticationManager();
var ctx = authenticationManager.GetAppOnlyAuthenticatedContext(
                                            "https://mydomain.sharepoint.com/sites/defaultcollection/MyDir",
                                            appId,
                                            appSecret);

But got a 401 unauthorized when trying to access the file with SharePoint.Client.File.OpenBinaryDirect(ctx, fileUrl);

标签： c#sharepoint

Answer 1

像这样使用 File.OpenBinaryStream() 代替：

    using Microsoft.SharePoint.Client;
    using OfficeDevPnP.Core;
    using System.IO;
    
    
    string siteUrl = "https://tenant.sharepoint.com/";
    using (var ctx = new AuthenticationManager().GetAppOnlyAuthenticatedContext(siteUrl, "yourappid", "yourappsecret"))
    {
        ctx.Load(ctx.Web, p => p.Title);
        ctx.ExecuteQuery();
        Console.WriteLine(ctx.Web.Title);
        Microsoft.SharePoint.Client.File file = ctx.Web.GetFileByUrl("https://tenant.sharepoint.com/Shared%20Documents/test.txt");
        ctx.Load(file);
        ctx.ExecuteQuery();
        string filepath = @"C:\temp\" + file.Name;
        Microsoft.SharePoint.Client.ClientResult<Stream> mstream = file.OpenBinaryStream();
        ctx.ExecuteQuery();

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

    };