Download Sharepoint link as CSV

[BernardoCris012]

Hello Community,

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

[AmolJangam]

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

[Athiban_Mahamathi]

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.

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

Regards,

Athiban

[Neel1]

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]

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.

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