topic Re: Download Sharepoint link as CSV in Product Forum

Download Sharepoint link as CSV

BernardoCris012 — Fri, 06 Dec 2024 06:28:10 GMT

Hello Community,

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

Re: Download Sharepoint link as CSV

AmolJangam — Fri, 06 Dec 2024 14:45:45 GMT

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

Re: Download Sharepoint link as CSV

Athiban_Mahamathi — Tue, 10 Dec 2024 14:10:56 GMT

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

Re: Download Sharepoint link as CSV

Neel1 — Wed, 18 Dec 2024 11:33:46 GMT

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