How to access Sharepoint online list using API?

Copper Contributor


Could you please explain how to setup an API connection to a Sharepoint list?

I am using UI Path RPA software and it has an activity for handling Http requests.

The window looks like this:


What is the API endpoint if SP list URL is the following:


Do I need Client Cert and Pass? If yes, how to obtain those from Azure AD?


Should I use OAuth2 method for authentication? If yes, how to obtain Access Token from Azure AD?

Another authentication options are: None, Simple HTTP with username and password, OAuth1.


In Azure AD I already have an app registration with required permissions (Microsoft Graph) which I use for connection to Excel 365. Can I modify it for using with Sharepoint either?
Here is Azure AD app registration screenshot.



Thank you.

0 Replies