Forum Discussion

elshadX's avatar
elshadX
Copper Contributor
May 18, 2020

How to access Sharepoint online list using API?

Hi,

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: https://contoso.sharepoint.com/sites/MyProject/Lists/EmployeeData

 

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.

No RepliesBe the first to reply