Need an activity to scrape pdf files and read then from a Sharepoint

Help Studio
, ,
1

Hi,

Good Day.

I have a situation where I need to access sharepoint files for an activity. I had applied for Azure end point (based on the feedback from many experts and also from some you tube videos via the sharepoint activity) via a change request in my organization, it was rejected for some security reasons. Now I need to read pdf files from the sharepoint via a browser. I have my other activity ready where it extracts data from these pdf files.

Would really appreciate the support from uipath gurus as always.

image
image1582×621 77.2 KB

Regards,
Manjesh

2

Hi @manjesh_kumar

Can the pdf be downloaded to your local folder?

3

Hi @prasath_S ,

Yes it can be downloaded to my local path, however I need to put this as an unattended bot in future.

4

Okay then you can create a sequence where it download the file to the local folder (by using dynamic selectors,click and type into) and then invoke the sequence you have developed to extract the data from pdf. Use loop and pass pdf names on it.

5

Hi @prasath_S ,

Thank you for the hints, I will definitely check it out.

another method

I was also exploring a sync option from my sharepoint to onedrive, however this writes to its own folder and I cannot sync into the folder which I require.

another method

I tried one more method (maybe foolish)which I tried to fetch files from the sharepoint directly via the assign activity. I am getting the following error.

Assign: The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters.

Regards,
Manjesh

6

Hi @manjesh_kumar ,

Since you’ve already the SharePoint access, one other possible approach would be to use Microsoft’s RPA solution (Power Automate) to download the files where you want

UiPath
UiPath2151×824 172 KB

Finally, you could use the UiPath to:

  1. Trigger the power automate flow to download the files, and
  2. Invoke your UiPath activity that extracts the data from the files

Best regards,
Marius

7

Hello @Marius_Puscasu,

Good Day. Nice to hear from you.

I am already using a power automate workflow :slight_smile: , when the end user gets a mail from a particular customer with a particular subject, the workflow saves those in the preferred sharepoint folder(as shown in the screenshot in my first post) from there I need to take care of the other activities via uipath.

Regards,
Manjesh

8

@manjesh_kumar ,
Good day!

Another solution would be to use the DavWWWRootfile path

\\yourcompany.sharepoint.com@SSL\DavWWWRoot\sites\RPA\Shared Documents\Test

UiPath
UiPath1491×600 44.9 KB

Hence, you can amend your UiPath workflow in order to make it read the pdf file from the DavWWWRoot location, without being needed to download the pdf files locally.

Best regards,
Marius