UiPath to access SharePoint List for Get and Update Operation

Help Activities
,
1

Hello Friends,

I am trying to automate and access the Sharepoint custom list - to get the item and update the item.
I know sharepoint has option to access the SharePoint list data using the SharePoint API. for example: _api/web/lists/GetByTitle(“MyList”)

I need to know how to get the Authentication details of SharePoint? see below screenshot.

image
image599×681 18.5 KB

2

Hi @labhesh,
I’m not 100% sure but probably you need to configure it firstly. Here are some details:

3

Hello Team,
I have found the answer, this is 2 step process:

  1. Authentication 2) Authorization

  2. Basically, you need to authenticate the SharePoint URL against where it is hosted, in this case this is office 365, so you need to work with the Infra team and get the CI created and have them create a key and secret code to get autherization, this auth will be to anyone having that key and secret key.

  3. once that is done, you need to provide permission from sharepoint to this key, and the permission can be on list, web or site collection level, depending upon your requirement. once that is done, you are all good to set and can connect and work easily.

thanks
Labhesh

1 Like
4

that’s correct, these are the steps.

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.