Creating a dynamic URL for web scraping

Hi everyone,

I am using excel application scope to read an excel file.

I have two rows of data in my file:
1.AAPL
2.AMZN

I want to go to the following website and scrape a table for each row above.

the URL should look like this.
URL1 = https://au.finance.yahoo.com/quote/AAPL/financials?p=AAPL
URL2 = https://au.finance.yahoo.com/quote/AMZN/financials?p=AMZN

I am using for each row to read contents of excel and store it in a variable called SearchValue using Assign activity.

How do I then create the URL which I can pass into open browser and make the process dynamic.

I tried the same approach i.e. using Assign activity but could not.

Could anyone please help me.

Cheers,
Rajan

Hi @boardman
Welcome to UiPath Community!

Please refer the screenshot for your query.

Happy Automation :slight_smile:

In case the URL is not part of the field values.
image

Hi @boardman
If you have same rules for both the AAPL and AMZN then open browser and pass desire url using rvegafria approach.
Else their is change in both rules then use Switch Case to handle them seprately.
Thank you

Awesome. This is what I exactly wanted. Thanks @rvegafria.

Thank you.