How to read PDF file from sharepoint

Help Studio
1

Hi,
I’m currently working on a project where I transfer files from Sharedrive into sharepoint.
Is it any way to read PDF file directly from Sharepoint instead of downloading the file?

2

Hi @MrOzog

You can use the Get File or Folder Activity under UiPath.MicrosoftOffice365.Activities to get the file from Sharepoint or Onedrive. This requires an Intergration Service Connection to the Sharepoint/Onedrive.
To Extract the Text from the File, you need to use Extract PDF text from UiPath.DocumentUnderstanding.Activities

The image shows a UiPath project in Studio with a list of dependencies and a highlighted UiPath.MicrosoftOffice365.Activities package, alongside a 'Get File or Folder' activity in the main sequence which prompts for a connection to Microsoft OneDrive & SharePoint. (Captioned by AI)
The image shows a UiPath project in Studio with a list of dependencies and a highlighted UiPath.MicrosoftOffice365.Activities package, alongside a 'Get File or Folder' activity in the main sequence which prompts for a connection to Microsoft OneDrive & SharePoint. (Captioned by AI)992×264 17.2 KB

Here, is a Process flow (Hidden Sensitive Details):

The image depicts a workflow with two steps: retrieving a PDF file from Microsoft OneDrive or SharePoint and extracting text from the PDF file. (Captioned by AI)
The image depicts a workflow with two steps: retrieving a PDF file from Microsoft OneDrive or SharePoint and extracting text from the PDF file. (Captioned by AI)356×303 7.47 KB

Here, is the Text extracted from the PDF:

A screenshot of a text document with most of its content redacted, showing only a date range from 29-June-2024 to 31-July-2024. (Captioned by AI)
A screenshot of a text document with most of its content redacted, showing only a date range from 29-June-2024 to 31-July-2024. (Captioned by AI)438×279 12.6 KB

Note: If your development restricts the use of UiPath.MicrosoftOffice365.Activities or UiPath.DocumentUnderstanding.Activities, it maybe difficult.

I Hope this solves your issue. If so, do mark it as a solution.
Happy Automation :star_struck:

1 Like
3

Unfortunately no direct option. You will have to download it and then do processing on it.