Getting 403 error when trying to read PowerApps List in Microsoft Graph Explorer.

Janardan Kortikere 1

Using GET https://graph.microsoft.com/v1.0/sites/{site-id}/lists/{list-id} in Microsoft Graph Explorer to read PowerApps List, but I a getting 403 error. However, I can read the same list using the same user in Visual Studio console project with CSOM.

1 answer

Deva-MSFT 2,256 Reputation points Microsoft Employee

2020-11-30T12:29:50.94+00:00
Do you use the same user context in Microsoft Graph Explorer/POSTMAN & Visual Studio console project as well?

Validate the token using https://jwt.ms and see if there is any difference available.
Please sign in to rate this answer.
Janardan Kortikere 1 Reputation point

2020-12-02T00:19:38.28+00:00

Sorry for the delay in reply. I use the same user id and password. I am not sure what else would be different in user context. I viewed the token that was in the Microsoft Graph Explorer using https://jwt.ms and I found that it did have the required permission "Sites.Read.All". I am unable to see token details in Visual Studio console project with CSOM.

Deva-MSFT 2,256 Reputation points Microsoft Employee

2020-12-03T13:39:30.227+00:00

Which permission (delegated/application) you used in your custom app? Have you tried the same in Graph explorer as well?

Janardan Kortikere 1 Reputation point

2020-12-03T14:00:00.403+00:00

Here is the code in my custom Console app using CSOM. You can see I am not providing permissions.

using (var ctx = new ClientContext("https://...")) { string userId = ConfigurationManager.AppSettings["sharePointUserId"]; string userPassword = ConfigurationManager.AppSettings["sharePointUserPassword"]; SecureString password = new SecureString(); foreach (char c in userPassword) { password.AppendChar(c); } ctx.Credentials = new SharePointOnlineCredentials(userId, password); var web = ctx.Web; List list1 = web.Lists.GetByTitle("List1"); CamlQuery query = CamlQuery.CreateAllItemsQuery(); query.ViewXml = "<View><Query><Where>....</Where></Query></View>"; ListItemCollection items = list1.GetItems(query); ctx.Load(items); ctx.ExecuteQuery(); foreach (ListItem listItem in items) { Console.WriteLine(.....) } Console.ReadKey(); }
Sign in to comment