How can I automate downloading of several attachments and PDF in each case ID from a webpage with 100 entries/page and multiple pages?

Help Studio
, ,
1

I have done table extraction to extract the links of each different case ID and stored them in Excel column A. I then used a For Each excel roll to loop through each URL link in each row. However, by doing this, I realized I cannot access the webpage for Click Activity.
Is there any way I can automate my given problem? :frowning:

2

HI,

Can you elaborate with specific image etc?

We might be able to click using href attribulte as selector from scraped URL link.

Or, we might be able to download the files using HTTP request activity if there is no authorization.

Regards,

3

Screenshot 2023-03-24 100614
Screenshot 2023-03-24 100631

Hi, basically the downloading of PDF will require me to click on the top right as shown in attachment while the attachments will be at the bottom left of the webpage as shown in attachment as well.

4

HI,

Thank you for sharing. Can you clarify your problem? It seems we can easily click each element : DownloadPDF and attachments.

Regards,

5

Hi,

I cant. I will be looping through the different URLs stored in Excel file here. Is there any way I can preview each URL for the different loop and proceed to do Click activity? Or is there a way for me automate my downloading process without preview of the different URL?

Screenshot 2023-03-24 100614
Screenshot 2023-03-24 100614752×760 23 KB

6

@attkren1

If the url you are getting is for the file directly and if it does not need any auth …then try as below

Alternately…I dont see any issue in clicking the download attachment…can you please tell if you are having difficulty getting the selectors?. Please try using ui explorer

Cheers

7

Hi @attkren1

Once you extracted the web page links/URL of PDF files which need to downloaded, Instead of using open browser, Try to use navigate to activity to navigate to that URL from this page

image
image787×439 48.5 KB

Once downlaod is completed for each URL, you can use Go back activity to go back to same page :slight_smile:

Hope this logic helps you in resolving the problem :slight_smile:

Thanks & Regards,
Nived N

8

Hi @NIVED_NAMBIAR,

Because Im using For Each Excel Row, I realised I cannot use Navigate To activity as I cannot see the preview of the page in order for me to use Click activity.
Futhermore, in this example, there are only 2 attachments. There are some URLs with 5 attachments etc. Is there a better way to automate this process?

9

One question,

does opening the link itself start downloading the file?

10

No. It will require a few Click activities to begin the downloading process and this is just for PDF (as shown in the pic, I will have to click the “3dots” then “Download PDF” then choose the desired path location.
I have attachments to download as well.
I dont know what is the best way to do it as i have 500+ different case IDs.

11

Hi

Are you able to spy the attachments section , if so use find children activity to get the list of attachments and use for each loop for that list and in every iteration you can use activity to download.

If you are bothering about using the open application in the for each then use attach browser with UIelement as input
In that you can use navigate browser activity by giving the url.

Regards

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.