Chrome browser API

Help Activities
, , , ,
1

Hi team,

i have one excel in excel file different URL. I want to paste the one by one URL on Chrome browser and download the file one by one.
i want this activity in backend so any available API.

please let me know.

2

Hi @AsadPathan2665

Use HTTP Request activity

Regards,

3

Hi @AsadPathan2665

You can use this activity Download file from URL.

Read your excel file in datatable & loop over it & pass the URL one by one to this activity,

image

Hope this helps :slight_smile:

4

Hi @AsadPathan2665

=> Use Read Range Workbook activity to read the excel and store the output in a datatable say dtInput

=> Use For Each row in DataTable to iterate through each row in DataTable.

=> Inside that use the below code in Invoke Code:

Dim client As New System.Net.WebClient
Dim fileName As String = System.IO.Path.GetFileName(New Uri(url).LocalPath)
Dim savePath As String = System.IO.Path.Combine("C:\Users\"+Environment.UserName+"\Downloads\", fileName) ' Adjust the path as needed
client.DownloadFile(url, savePath)

Invoke Code Arguments:

image
image883×260 9.69 KB

Note: Change the column name in Invoke Code Arguments according to yours CurrentRow("yourcolumnname").ToString

FLOW:

image
image743×710 32.2 KB

XAML:
Test.xaml (9.0 KB)

Let me know if you face any issues.

Hope it helps!!

5

Hi @AJ_Ask,
this activity not available in activity pannel. which package should be download?

6

grafik
grafik855×142 7.51 KB

taken from:

contained in:
grafik

Only Available for windows compatibility:
grafik

but available in newer versions. Which package version is used at your end?

7

maybe you need to upgrade the this package
This image shows a node in a project or package manager tree indicating that the UiPath.System.Activities package is at version 24.10.3. (Captioned by AI)

8

Hi @Parvathy ,

can we download video as well?. some link is video link.

9

Hi @AsadPathan2665

Yes it will download the video link also.

Check and let me know if you face any issues with the code.

Regards

10

Hi @Parvathy ,
the attached error is coming.

The image shows a UiPath Studio interface with a "For Each Row in Data Table" activity and an "Invoke Code" activity highlighted, displaying an exception message stating that an error was thrown by the target of an invocation. (Captioned by AI)
The image shows a UiPath Studio interface with a "For Each Row in Data Table" activity and an "Invoke Code" activity highlighted, displaying an exception message stating that an error was thrown by the target of an invocation. (Captioned by AI)1920×1080 268 KB

11

Hi @AsadPathan2665

Can you show what have you passed in Invoke Code Arguments?

Regards

12

Hi @Parvathy
please see.

image
image1105×333 20.7 KB

13

Hi @AsadPathan2665

Make sure your column name doesn’t contain any extra spaces. Try to copy the column name and paste it there.

Regards

14

Hi @Parvathy,

same error coming

15

Hi @AsadPathan2665

Try this:

image
image618×678 19.1 KB

Hope it helps!!
Happy Automation :uipath:

16

@AsadPathan2665

Can you share the excel file you are using.

Regards

17

Hi @Parvathy ,

we cant share the excel file its security purpose.

18

@AsadPathan2665

If the urls are full ursl like having extension also in url and would take to downlod or would download directly

Then best use download file from url

If not use http request…in uri field pass the url and in the Filename for response attachment field pass the complete path where it needs to be downloaded

Both the options work

Cheers

1 Like
19

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