Navigate to page, download,rename, and move file

Help Studio
, ,
1

test4.xlsx (9.9 KB)
Good Morning Fellow Automates,
I have attached a sample excel sheet. In the excel sheet there are 2 columns, URL, and FileName. My automation will navigate to the URL and download the PDF to the downloads folder, that PDF file that was downloaded needs to be renamed to the FileName associated with that URL in the spreadsheet. The files then need to be moved to a different folder named MFRID. If anybody has time could they post a quick workflow for this automation, it would be much appreciated.

3

Hello @NATHAN_MORA

You can use Read range to get the entire data. Then use for each row in datatable activity to loop throught he rows.

Then get the url using row(“columnname”).ToString to get the url.

Then use open browser to navigate to that url.
Then download the file. Then you can use Move file to move the file and provide the full path in the destination field.

Thanks

4

Thanks for the reply i also have to rename the file to the FileName is the excel sheet.

5

You can get the file name from excel in the same loop as how you are getting the url.

row(“columnname”).ToString

Then in the destination field of the move file activity provide this filename as well along with the folder path.

Thanks

1 Like
6

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