List_SharePoint_Sites() returns error 404

[En-On-Git]

One of my users is experiencing an issue with this package when using the List_SharePoint_Sites() command.
The command always returns the following error:

Using authorization_code flowWaiting for authentication in browser...
Press Esc/Ctrl + C to abortAuthentication complete.Error in process_response(res, match.arg(http_status_handler), simplify) :
Not Found (HTTP 404). Failed to complete operation. Message:
Requested site could not be found.

Retrieving individual sites works as expected, and the user can retrieve their followed sites via Graph using the GET https://graph.microsoft.com/v1.0/me/followedSites endpoint via PowerShell and Graph Explorer.

Troubleshooting steps taken:

• Re-installed the package.
• Cleared the cached credentials via AzureAuth::clean_token_directory() and AzureGraph::delete_graph_login()
• Tried running List_SharePoint_Sites with explicit app id of AzureR/Microsoft365R default Enterprise Registration.
• Tried running List_SharePoint_Sites with explicit app id of a custom App Registration.
• Tested https://graph.microsoft.com/v1.0/me/followedSites Graph endpoint via Graph Explorer.
• Tested https://graph.microsoft.com/v1.0/me/followedSites Graph endpoint via PowerShell with the AzureR/Microsoft365R Enterprise Registration Application (Client) ID.

[hongooi73]

This is likely to be a problem with the server. Wait 24 hours and see if it persists.

[En-On-Git]

This is likely to be a problem with the server. Wait 24 hours and see if it persists.

The issue has been happening since November 2024 and we have tried everything to troubleshoot it.
Microsoft has also helped from their end in investigating any possible Graph or user identity issues with no success (everything is fine on those ends).

[hongooi73]

Did you create your own app ID? If so, can you show me the permissions?

[En-On-Git]

Did you create your own app ID? If so, can you show me the permissions?

The error occurs the same way with the official AzureR/Microsoft365R Enterprise Application (d44a05d5-c6a5-4bbb-82d2-443123722380) and with a custom App Registration.
Both applications have been given the required permissions listed in the app_registration.md guidance:

• User.Read
• Files.ReadWrite.All
• Group.ReadWrite.All
• Directory.Read.All
• Mail.Send
• Mail.ReadWrite
• Sites.Manage.All
• Sites.ReadWrite.All
• email, profile, openid, offline_access

The user is able to retrieve the list of sites they follow when using Graph over PowerShell.
Could you confirm if List_SharePoint_Sites() uses the following MS Graph endpoint?

https://graph.microsoft.com/v1.0/me/followedSites

[hongooi73]

Yes, it uses the followedSites endpoint. This is the documentation:

https://learn.microsoft.com/en-us/graph/api/sites-list-followed?view=graph-rest-beta&tabs=http

@elipousson you probably know more about Sharepoint than me, have you had any problems with listing sites?

[En-On-Git]

Yes, it uses the followedSites endpoint. This is the documentation:

https://learn.microsoft.com/en-us/graph/api/sites-list-followed?view=graph-rest-beta&tabs=http

@elipousson you probably know more about Sharepoint than me, have you had any problems with listing sites?

Does the package use the Beta endpoint or the v1.0?

[hongooi73]

It uses the beta endpoint. You can change to the 1.0 endpoint by running options(azure_graph_api_version="v1.0")

[En-On-Git]

It uses the beta endpoint. You can change to the 1.0 endpoint by running options(azure_graph_api_version="v1.0")

Thanks. We tried testing the List_SharePoint_Sites() with the V1.0 option but it still returns the same error.
Any other ideas on how to troubleshoot it?

[hongooi73]

I suspect this is something peculiar to your install. It doesn't seem like anyone else is affected.

Does this happen to everyone, or just that particular user?

You can try running just the underlying AzureGraph code, without MS365R loaded:

library(AzureGraph)
gr <- get_graph_login(tenant=*, app=*, ...)
call_graph_endpoint(gr$token, "me/followedSites")

[elipousson]

Huh, I tried using the AzureGraph code and I wasn't able to list the followed sites. I did not get the "Requested site could not be found" error — just an "Access denied" message. My permissions are locked down in some weird ways, though, e.g. I can't use get_business_onedrive(), so I expect this is just one of those things that isn't enabled for me.

[hongooi73]

@elipousson does the regular list_sharepoint_sites() work? The AzureGraph call may be incorrect, it's been some time since I looked at that package.

[En-On-Git]

I suspect this is something peculiar to your install. It doesn't seem like anyone else is affected.

Does this happen to everyone, or just that particular user?

You can try running just the underlying AzureGraph code, without MS365R loaded:

library(AzureGraph)
gr <- get_graph_login(tenant=*, app=*, ...)
call_graph_endpoint(gr$token, "me/followedSites")

I confirmed with the user that they are able to retrieve the list of Followed Sites using the AzureGraph package directly with this snippet:

library(AzureGraph)
graph <- get_graph_login()
operation <- "me/followedSites"
response <- call_graph_endpoint(graph$token, operation, http_verb = "GET")
print(response)

The output is a list of all the SharePoint sites they follow containing site ID, Display Name, Description, and Web URL.

So something might be happening with the way the Microsoft365R package handles it?

[hongooi73]

That should be exactly the same code that Microsoft365R uses. Does anyone else in your org have this problem, or is it just this user?

[En-On-Git]

That should be exactly the same code that Microsoft365R uses. Does anyone else in your org have this problem, or is it just this user?

It affects a couple of my users. Both tried re-installing RStudio and the whole package and its dependencies, but the issue is still the same.

[hongooi73]

Ok, but are there people for whom it works?