Using variable for url

Help
1

Hey guys.

I’m trying to use a url i got from an excel document to go to a website and perform some actions. I have used “Read range” to store different urls in a DataTable called IP, then a “For each row” to make the process loop through the excel cells/urls.

But when try to access the website from my datatable (using Open Browser, type the stored address as IP.ToString) it fails. The browser opens, but the url is pasted as " http:/// " - as if the value is replaced with a " / "

Is there anyone who can tell me what i am doing wrong?

Thanks,

2

Hi vovivo,

I have attached sample workflow to serve your purpose please check and it is working fine. Let me know if any further clarification is needed.URL.zip (8.1 KB)

3

It sounds like the variable value is not what you expect. If you put IP.ToString into a writeline or messagebox activity, do you get the same value?

4

Thank you. This worked perfectly. Seems the ToString thing wasn’t the correct way to go. You saved my day!

1 Like
5

:grinning:

6

Hi @Dave, @harinathreddy.yn I have somewhat a similar case, however, please see the image below.
image

In your sample, you used it as the main url, this time, I have a specific URL for the site, but will use the url string from the excel file to feed it as input for test.

please see link for the case :slight_smile:

thanks.