I have file link from sharepoint which I need to upload to Blob Storage. I don’t have folder access. I just have that file link. How to achieve this ?
Hi @pari_patel ,
If the link is public or accessible via headers (like a token), use:
HTTP Request Activity
Method: GET
Endpoint: The SharePoint file URL
Output: Save the file to a temporary local path
If auth is needed:
Add headers like Authorization: Bearer if you have an access token
Regards,
Arivu
Hi @pari_patel
If SharePoint is on-premises then you can try to use http request activity to download the file using the sharepoint link
save the file locally using write file activity
use azure blob storage activities to upload the local file to blob storage using upload blob activity.
If SharePoint on cloud then you should to integrate then try.
If you found helpful please mark as a solution. Thanks
Happy Automation with UiPath
Hi @arivu96,
Are you able to share more details around this? or may be how parameters should like for http request.
I have a similar challenge where I do have direct URL for attachment. I am able to access the file by directly navigating to the url but not via code because it requires auth header.
For http request, even if i provide auth headers and direct link to the attachment, output still won’t be file. How to have it as file or save the output from http request activity as file?
Regards
Sonali
Thanks for the response. I am downloading file using sharepoint download activity, but when I use write range to write that file and store locally, it is giving error as driveitem not convert to data table.
Hi @pari_patel,
i understand that you are doing it via O365 package.
So, your download activity itself would have a place to define the local path where the file should be saved like below.
Regards
Sonali
Hi @pari_patel
download the file using the sharepoint download file activity and make sure to provide a valid local file path to save it properly .
once the file is saved locally, use the read range activity to read the file content and store it into a datatable variable
ensure that the file path and sheet name are correct and that the file is not corrupted.
after successfully converting the content to a datatable use the write range activity to write the data.
make sure you are not directly trying to convert the driveitem object into a datatable without reading its content first.
If you found helpful please mark as a solution. Thanks
Happy Automation with UiPath
Hi @sonaliaggarwal47 Can you send me both the activities you use to download from sharepoint and save it locally, I am getting error while saving.
Hi @pari_patel,
It’s one activity only as shown in above screenshot that downloads and saves.
Can you please share what error you are getting?
Also can you share snapshot of your workflow?
Regards
Sonali
1 Like
Hi, I am able to get the file.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.