How to access Sharepoint online list using API?

%3CLINGO-SUB%20id%3D%22lingo-sub-1398552%22%20slang%3D%22en-US%22%3EHow%20to%20access%20Sharepoint%20online%20list%20using%20API%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1398552%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3ECould%20you%20please%20explain%20how%20to%20setup%20an%20API%20connection%20to%20a%20Sharepoint%20list%3F%3C%2FP%3E%3CP%3EI%20am%20using%20UI%20Path%20RPA%20software%20and%20it%20has%20an%20activity%20for%20handling%20Http%20requests.%3C%2FP%3E%3CP%3EThe%20window%20looks%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22httprequest.png%22%20style%3D%22width%3A%20753px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F192491i41765B712A041248%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22httprequest.png%22%20alt%3D%22httprequest.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EWhat%20is%20the%20API%20endpoint%20if%20SP%20list%20URL%20is%20the%20following%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fcontoso.sharepoint.com%2Fsites%2FMyProject%2FLists%2FEmployeeData%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcontoso.sharepoint.com%2Fsites%2FMyProject%2FLists%2FEmployeeData%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20I%20need%20Client%20Cert%20and%20Pass%3F%20If%20yes%2C%20how%20to%20obtain%20those%20from%20Azure%20AD%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EShould%20I%20use%20OAuth2%20method%20for%20authentication%3F%20If%20yes%2C%20how%20to%20obtain%20Access%20Token%20from%20Azure%20AD%3F%3C%2FP%3E%3CP%3EAnother%20authentication%20options%20are%3A%20None%2C%20Simple%20HTTP%20with%20username%20and%20password%2C%20OAuth1.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20Azure%20AD%20I%20already%20have%20an%20app%20registration%20with%20required%20permissions%20(Microsoft%20Graph)%20which%20I%20use%20for%20connection%20to%20Excel%20365.%20Can%20I%20modify%20it%20for%20using%20with%20Sharepoint%20either%3F%3CBR%20%2F%3EHere%20is%20Azure%20AD%20app%20registration%20screenshot.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22azure.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F192496i11E264F4A2F6BA8A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22azure.png%22%20alt%3D%22azure.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1398552%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAPIs%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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:

httprequest.png

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.

azure.png

 

Thank you.

0 Replies