Sharepoint online spoke - 401 - Invalid username/password combo

[magnushedlu]

We are trying to set up the Sharepoint Online API (Spoke) but are having issues.

We have followed all steps as described in the guide (Configure Microsoft SharePoint Online connection record) and we are getting the oauth token successfully.
But when doing a simple actions such as "get list" we get "method failed" with the message "401 - Invalid username/password combo". 

Any ideas on what the issue could be? We have tried to grant the api with as high permissions as possible in Azure but still same problem.

Can it be an issue that we are using a mid server? 

[tsramkumar]

Hello Paul

Anything else you had to do apart from the above? We did grant FullControl role to the selected site but we are still getting this error "Sharepoint site URL is invalid or you don't have sufficient permissions to access it" I don't see any other http codes. Not sure what else is missing. We have both the Sharepoint and Graph spokes have been configured and i can see successful certificate based authentication in EntraID sign in logs. 

Since you had used sites.selected, thought of running by you.

For the Folder path, do you provide the "/" in front of it?

[Paul Kunze]

Hello, we also had to do a lot of trial and error. One additional thing we had to change was to select "Authorization Code" as the Default Grant type. It was needed for a personal (user-based) authentication.

Let me share our setup of the Application Registry (table oauth_entity):

For the folder path in the Spoke Action we don't need the /