C# to retrieve list items from sharePoint online

Question

I have console application running on my local machine, got error "System.Net.WebException: 'The remote server returned an error:(403) Forbidden.' " when executed below code Below code is working fine for SharePoint server sites but not for SharePoint online sites.

 var webUrl = new Uri("https://SharePointOnline123.com");
            using (ClientContext ctx = new ClientContext(webUrl))
            {              
                Web webObj = ctx.Web;
                List listObj = webObj.Lists.GetByTitle("AbcList");
                CamlQuery cqObj = CamlQuery.CreateAllItemsQuery(100);
                ListItemCollection colObj = listObj.GetItems(cqObj);

                ctx.Load(colObj);
                ctx.ExecuteQuery();

                if (colObj.Count != 0)
                {
                    foreach (ListItem item in colObj)
                    {
                        Console.Write($"ID: {item.Id}");
                        //Console.Write($"Title: {item.Client_Title}");
                    }
                }
             };

Answer 1

Hi @Bommisetty, Gayatri, I will recommend you to use CSOM to access SharePoint Online. You can refer to following code

            using (var clientContext = new ClientContext("https://company.sharepoint.com/sites/xxx")){
                // SharePoint Online Credentials
                var pwd = "************";
                var passWord = new SecureString();
                foreach (char c in pwd.ToCharArray()) passWord.AppendChar(c);
                clientContext.Credentials = new SharePointOnlineCredentials("******@wxx.onmicrosoft.com", passWord);
                // Get the SharePoint web
                Web web = clientContext.Web;
                clientContext.Load(web);
                clientContext.ExecuteQuery();
                List targetList = clientContext.Web.Lists.GetByTitle("List Name");
                CamlQuery oQuery = CamlQuery.CreateAllItemsQuery();

                ListItemCollection oCollection = targetList.GetItems(oQuery);
                clientContext.Load(oCollection);
                clientContext.ExecuteQuery();

                foreach (ListItem oItem in oCollection)
                {
                    Console.WriteLine(oItem["Title"].ToString());
                }
            }	

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.