Not able to access Sharepoint O365 list from my Local System

I want to access sharepoint list from my local machine VS2012 using CSOM but getting The remote server returned an error: (401) Unauthorized. error message

My Code:

using Microsoft.SharePoint.Client;
using System;
using System.Security;
using System.Configuration;
namespace SP_Console
{
class Program
{
static void Main(string[] args)
{
ClientContext clientContext = new ClientContext("http://sphkcl.sharepoint.com/");
clientContext.Credentials = new SharePointOnlineCredentials(GetSPOAccountName(), GetSPOSecureStringPassword());
// Get the SharePoint web
Web web = clientContext.Web;
// Get the SharePoint list collection for the web
ListCollection listColl = web.Lists;
// Retrieve the list collection properties
clientContext.Load(listColl);
clientContext.ExecuteQuery();
// Loop through all the list
foreach (List list in listColl)
{
// Display the list title and ID
Console.WriteLine("List Name: " + list.Title + "; ID: " + list.Id);
}
Console.ReadLine();
}
private static SecureString GetSPOSecureStringPassword()
{
try
{
var secureString = new SecureString();
foreach (char c in ConfigurationManager.AppSettings["SPPass"])
{
secureString.AppendChar(c);
}
return secureString;
}
catch
{
throw;
}
}
private static string GetSPOAccountName()
{
try
{
return ConfigurationManager.AppSettings["SPAccount"];
}
catch
{
throw;
}
}
}
}

I have added username and password in app.config.

<appSettings>
<add key="SPAccount" value="[email protected]"/>
<add key="SPPass" value="*********"/>
appSettings>

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Aakash Maurya7y ago
Accepted answer
There are only 2 possible error that is possible here.
The first, you have ensure that the user details that you have provided into configuration file should have access to SharePoint Online site.
The site url should begin with HTTPS:// instead of HTTP://.
I tried your code,and just changed the site Url look like https:// and the code worked.
Kumar Sourabh7y ago
Thanks a lot for pointing out the error. My issue was URL, now able to access.