Creating a dynamic URL for web scraping

Help
1

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 = Apple Inc. (AAPL) income statement – Yahoo Finance
URL2 = Amazon.com, Inc. (AMZN) income statement – Yahoo Finance

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

2

Hi @boardman
Welcome to UiPath Community!

Please refer the screenshot for your query.

image
image731×791 19.6 KB

Happy Automation :slight_smile:

4

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

5

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

6

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

7

Thank you.