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

Question

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

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.

Answer 1

Deva-MSFT 2,231 Microsoft Employee

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.

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,231 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

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();
}

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

1 answer

Activity