How to access Sharepoint list using API?

[elshad (Elshad Shabanov)]

Hi guys,

Could you please explain how to access Sharepoint list using API?
I tried to use “Http Request” activity, but got lost in settings.
Also I read Microsoft’s docs page with Sharepoint API explanation, but got confused even more.

In Http Request activity we have the following window:

What should I put in End point if my Sharepoint link is 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 it from Azure AD?

In Azure AD I already have an app registration with required permissions (Microsoft Graph) for “UiPath.MicrosoftOffice365.Activities”, and I use it for Excel 365. Can I modify it for using with Sharepoint either?
Here is Azure AD app registration screenshot.

Any help appreciated.

[sravani22 (Hasini)]

are you able to solve this ?