cancel
Showing results for 
Search instead for 
Did you mean: 

Download Sharepoint link as CSV

BernardoCris012
Level 3

Hello Community,

Is there any way we could export a sharepoint list as csv file? Aside from downloading it using UI/Web Automation.

BernardoCris012_0-1733466458719.png

 

3 REPLIES 3

AmolJangam
Level 3

Hi Bernardo,

You can achieve it in following ways:

1. Microsoft Graph API to connect with SharePoint - "Connector for Microsoft Graph API - SharePoint - 3.1.0"

2. By Creating custom code stages- You have to use code stages to create connection with SharePoint and then download the list, please refer - https://stackoverflow.com/questions/58034425/download-file-from-sharepoint-online-using-c-net

 

Hi @BernardoCris012 ,

We have a connect for Microsoft Graph - Sharepoint API. Please use the download action in the asset to download the file as csv.

Athiban_Mahamathi_0-1733839848183.png

 

https://digitalexchange.blueprism.com/dx/entry/3439/solution/microsoft-graph-api---sharepoint

Regards,

Athiban

Hey @BernardoCris012  - By using SharePoint VBO , It can be achieved with steps mentioned below

1. use get List - it will give all List ID.

2. Feed List id to below Action [ use loop, if there are multiple]

Neel1_0-1734521035221.png

3.O/p will come in Content JSON output data item.

4. Use utility- JSON and action JSON to collection [ o/p collection here is result]. Field level information of List will be in nested collection like shown below.

Neel1_2-1734521542529.png

 

Neel1_1-1734521497982.png

 

5.use Excel VBO to take collection data to CSV/excel