topic RE: Downloading a file from Sharepoint in Digital Exchange

Downloading a file from Sharepoint

anmaheswa — Wed, 16 Mar 2022 23:09:00 GMT

How to download a file using the sharepoint url. I am aware of the mapping Sharepoint to explorer option however that won't work in my case. I tried using File management utility and download File action but it pops up with the forbidden error message. However it's not due to access, as manually I am able to perform the same operation.

------------------------------
Ankita Karnany
Principal Consultant
Agilisys
London
------------------------------

RE: Downloading a file from Sharepoint

shashank.kumar280 — Thu, 17 Mar 2022 05:16:00 GMT

Hi Ankita,

Have you tried using the Graph API based Sharepoint asset available on DX https://digitalexchange.blueprism.com/dx/entry/3439/solution/microsoft-graph-api---sharepoint. There is an action available in it that downloads file.

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Downloading a file from Sharepoint

anmaheswa — Thu, 17 Mar 2022 08:58:00 GMT

Hi Shashank,

Seems like the asset doesn't exist..

------------------------------
Ankita Karnany
Principal Consultant
Agilisys
London
------------------------------

RE: Downloading a file from Sharepoint

shashank.kumar280 — Thu, 17 Mar 2022 10:17:00 GMT

Hi Ankita,

Can you try this link https://digitalexchange.blueprism.com/dx/entry/3439/solution/microsoft-graph-api---sharepoint

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Downloading a file from Sharepoint

anmaheswa — Thu, 17 Mar 2022 11:38:00 GMT

Hey Shashank,

I have managed to download the API, however could you also help with the parameters I need to pass . I haven't used it earlier so not aware on how we can use this.

------------------------------
Ankita Karnany
Principal Consultant
Agilisys
London
------------------------------

RE: Downloading a file from Sharepoint

ewilson — Thu, 17 Mar 2022 23:52:00 GMT

Hi @anmaheswa,

There's a new VBO that should be published to the DX early next week. It's called Microsoft Graph - Dowload Files. The VBO provides a simplified means of downloading files from various Microsoft resources including SharePoint, OneDrive, Group drives, User drives, and Pre-Authenticated URLs.

The Download File action on the Microsoft Graph - SharePoint connector may or may not work for you. The issue is that the connector is built using the Web API feature of Blue Prism and that feature doesn't like downloading files that contain binary content (ex. PDFs). That's why we create the new VBO. It can handle binary files as expected.

If the file you're trying to download from SharePoint is a regular text file, the Download File action will work find. There are a few things you need to understand though in order to use the Microsoft Graph assets:

You also need to use the Microsoft Graph - Authentication VBO. You can find that here. This VBO is used to request an access token from Microsoft. You need to keep track of that token and pass it in as an input parameter to most of the other Microsoft Graph connectors.
To use the Authentication VBO you need a few things:
1. You need to know your Tenant ID on Microsoft 365. Your tenant ID has two forms: You domain or a GUID. Here are some examples: contoso.onmicrosoft.com or 471d90aa-6db9-4a11-9479-799d3a8d7547
2. You'll also need a Client ID and Client Secret (for an Application Access token). If you want a Delegated Access token you'll need a Client ID, Client Secret and the username and password of the user account you're trying work on behalf of. There's information about this in the Microsoft Graph - Authentication VBOs user guide.
Once you have the Authentication VBO sorted and you're able to issue a successful request for a token you'll be ready to work with SharePoint connector. At this point you need to know the Site ID, Drive ID, and File ID of the specific file you want to download. These ID's are unique alphanumeric identifiers. You can get them by working through some of the other actions available on the SharePoint connection (namely the Get and List operations) to see the details of items within the SharePoint site. Alternatively, you could try using Microsoft's Graph Explorer utility to get that information.

Graph Explorer is a web-based utility for testing the various Graph endpoints.

I know all of that sounds like a lot and to a certain extent it is. Once you start working with Graph things start to make sense though. Now, if you're in a hurry and you have access to the direct download URL for a file on SharePoint, you can use the Utility - HTTP VBO to download the file. Just make sure you get the latest version of that VBO from the Digital Exchange.

That VBO has a action called HTTP Request File. You can pass in your URL, set the Method to GET, enter the FilePath (where you want to file saved to), and you should be good to go. That is assuming the URL you have doesn't require authentication.

Cheers,

------------------------------
Eric Wilson
Director, Integrations and Enablement
Blue Prism Digital Exchange
------------------------------

RE: Downloading a file from Sharepoint

anmaheswa — Mon, 21 Mar 2022 21:52:00 GMT

Thanks a lot Eric for the detailed information you have provided. Let me give it a a go and I shall get back to you in case of any concerns. Appreciate your help on this.

------------------------------
Ankita Karnany
Principal Consultant
Agilisys
London
------------------------------

RE: Downloading a file from Sharepoint

AbhirupDas — Wed, 29 Mar 2023 03:43:00 GMT

I have a direct download URL of SharePoint but it needs authentication.

My link is : https://spanet.sharepoint.com/sites/TOC/Lists/OMS%20%20Application%20Data/Attachments/954/VA-21841.pdf

What do I need to do to download directly from the download URL using Utility - HTTP VBO?

I tried Utility - HTTP but got a 404 Unauthorized error.

How to pass the authentication?

------------------------------
Abhirup Das
------------------------------

RE: Downloading a file from Sharepoint

shashank.kumar280 — Wed, 29 Mar 2023 04:19:00 GMT

Looks like the user doesn't have the necessary permissions to download the file.

Please check the permissions in the Azure portal

https://learn.microsoft.com/en-us/graph/api/driveitem-get-content?view=graph-rest-1.0&tabs=http

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Downloading a file from Sharepoint

AbhirupDas — Wed, 29 Mar 2023 05:41:00 GMT

I check the permission is given.

The Action Properties are following :

Can you please guide me what I'm doing wrong?

------------------------------
Abhirup Das
------------------------------

RE: Downloading a file from Sharepoint

shashank.kumar280 — Wed, 29 Mar 2023 07:52:00 GMT

Are you getting 404 Not Found error ? (and not Unauthorized error)

Are you able to download using your URL in browser or using Postman?

You could use Microsoft Graph - Download Files asset as mentioned in the thread above as this asset specifically caters to downloading files.

Refer this thread for the correct url to use https://community.blueprism.com/communities/community-home/digestviewer/viewthread?GroupId=145&MessageKey=8412c079-3d51-404d-9b83-a440d2b61758&CommunityKey=3743dbaa-6766-4a4d-b7ed-9a98b6b1dd01?utm_source=blueprism&utm_medium=pweb&utm_campaign=gl-web-2022-q1-12-3-community-related-discussions

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------