Connect to SharePoint Online without Basic Authentication from C# Console App

Question

Connect to SharePoint Online without Basic Authentication from C# Console App

Elmo 41

Hello,

I have developed a C# Windows Console app. In the past I could connect and write data to SharePoint Online using Basic Authentication very easily. See my (simplified) code here:

using Microsoft.SharePoint.Client;  
using System.Security;  
  
onlineCredentials = new SharePointOnlineCredentials(userName, securePassword);  
  
ClientContext ctx = new ClientContext(myWebsiteUrl)  
ctx.Credentials = onlineCredentials;  
Web web = ctx.Web;  
ctx.Load(web);  
ctx.ExecuteQuery();

Now, Basic Authentication is disabled in the target Sharepoint Online tenant.

What are the options to connect to SharePoint Online (from my Console application) now? Is the only way to create an Azure app to get ?

Thanks for any help! :)

Regards,
Elmo

0 comments

2 answers

Your answer

Answer 1

Elmo 41

Hi RobWindsor,

thanks a lot for your great answer. This helps me a lot.

A few points are still not clear to me:

Okay, I grant my Azure app specific permissions. And with the combination of the client ID and the certificate my console app can perform specific actions (in your example, the console app can read data from SharePoint sites.)

Does this mean, that the permissions of the console app are valid for each and every SharePoint site of the tenant?
What if I want to limit the permissions of the console app to a specific SharePoint site?

I hope you understand what's my point here: If you cannot limit the permissions of the app to certain SharePoint sites, then everybody who has the client ID and the certificate has read permissions to everything in the tenant, in the worst case to confidential data.

Regards,
Emmo

Rob Windsor 2,006 Reputation points

2022-10-31T17:05:37.1+00:00

Yes, in the example above the app has access to read from all sites in the tenant. You can limit that to selected site collections using the Sites.Selected permission scope.

Updates on controlling app specific access on specific SharePoint sites (Sites.Selected)
Elmo 41 Reputation points

2022-10-31T18:17:20.043+00:00

Thanks, perfect! That was the missing piece I was looking for.
Buse Kara 26 Reputation points

2024-03-07T19:00:19.1+00:00

Hi everyone, Where did you get the certificate password? Could you share your way?

Answer 2

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

6 deleted comments

Comments have been turned off. Learn more