SharePoint Online CSOM执行报错求助：凭据及站点信息已确认无误

先贴出修正了转义引号后的原代码：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Net;
using System.Security;
using System.Text;
using System.Threading.Tasks;
using Microsoft.SharePoint.Client;

namespace Testmyproject
{
    class Program
    {
        static void Main(string[] args)
        {
            string userName = "pratapbangosavi@xqsnt.onmicrosoft.com";
            Console.WriteLine("Enter Your Password Please  ------- ");
            SecureString password = GetPasswordOfYourSite();
            // ClientContext - Get the context for the SharePoint Online Site  
            using (var clientContext = new ClientContext("https://xqsnt.sharepoint.com/sites/mysite/"))
            {
                // SharePoint Online Credentials  
                clientContext.Credentials = new SharePointOnlineCredentials(userName, password);
                // Get the SharePoint web  
                Web web = clientContext.Web;
                // Load the Web properties  
                clientContext.Load(web);
                // Execute the query to the server.  
                clientContext.ExecuteQuery();
                // Web properties - Display the Title and URL for the web  
                Console.WriteLine("Title: " + web.Title);
                Console.WriteLine("URL: " + web.Url);
                Console.WriteLine("Template: " + web.WebTemplate);
                Console.ReadLine();
            }
        }
        private static SecureString GetPasswordOfYourSite()
        {
            ConsoleKeyInfo info;
            //Get the user's password as a SecureString  
            SecureString securePassword = new SecureString();
            do
            {
                info = Console.ReadKey(true);
                if (info.Key != ConsoleKey.Enter)
                {
                    securePassword.AppendChar(info.KeyChar);
                }
            }
            while (info.Key != ConsoleKey.Enter);
            return securePassword;
        }
    }
}

针对clientContext.ExecuteQuery()报错的情况，按以下步骤排查：

• 先捕获具体异常信息
  原代码无异常处理，无法定位问题根源。先给代码添加try-catch块，输出详细错误：

  using (var clientContext = new ClientContext("https://xqsnt.sharepoint.com/sites/mysite/"))
  {
      try
      {
          clientContext.Credentials = new SharePointOnlineCredentials(userName, password);
          Web web = clientContext.Web;
          clientContext.Load(web);
          clientContext.ExecuteQuery();
          Console.WriteLine("Title: " + web.Title);
          Console.WriteLine("URL: " + web.Url);
          Console.WriteLine("Template: " + web.WebTemplate);
      }
      catch (ClientRequestException ex)
      {
          Console.WriteLine($"错误详情: {ex.Message}");
          Console.WriteLine($"错误堆栈: {ex.StackTrace}");
          if (ex.InnerException != null)
          {
              Console.WriteLine($"内部错误: {ex.InnerException.Message}");
          }
      }
      Console.ReadLine();
  }
  

  根据输出的错误信息，可直接定位核心问题（比如401未授权、404站点不存在、MFA限制等）。

• 排查常见问题

  1. CSOM版本不兼容
     确认项目引用的Microsoft.SharePoint.Client和Microsoft.SharePoint.Client.Runtime包是适配SharePoint Online的最新稳定版，避免使用老旧SDK版本。
  2. 账号MFA或权限问题
     • 若账号开启了多因素认证（MFA），SharePointOnlineCredentials方式无法直接登录，需改用租户后台生成的应用密码，或切换到PnP CSOM的认证方式。
     • 确认账号拥有目标站点的访问权限（至少为访客级别），未被站点权限组排除或租户级别的访问限制。
  3. 站点URL格式问题
     尝试去掉URL末尾的斜杠，改为https://xqsnt.sharepoint.com/sites/mysite，部分场景下斜杠会导致地址解析异常。
  4. 网络或代理问题
     若运行环境有代理，需添加代理配置确保代码能访问SPO服务：

     WebProxy proxy = new WebProxy("代理地址", 端口);
     proxy.Credentials = new NetworkCredential("代理账号", "代理密码");
     clientContext.Proxy = proxy;
     

内容的提问来源于stack exchange，提问作者winners11