i have a situation where i need to automate 3 url ..
https://externalqa.econnectivity.com/eConn/App/AlertAnalysisAid/AAA.aspx?alertTypeID=[@ID]&pageName=[@PAGENAME]&jNumber=[@JNUMBER]
in this url alertTypeID ,pageName and JNumber keeps changing . how do i automate this url now ? in a config file can i have 3 columns of alerttypeid ,pagename and jumber ? and how do i give that in open browser
Hello @Pooja_Kanwar,
Follow these steps:-
Put the 3 values (alertTypeID, pageName, jNumber) in an Excel file with 3 columns.
Read the Excel into a DataTable.
Loop through each row → build URL like:
url = “https://externalqa.econnectivity.com/eConn/App/AlertAnalysisAid/AAA.aspx?alertTypeID=” & row(“alertTypeID”).ToString & “&pageName=” & row(“pageName”).ToString & “&jNumber=” & row(“jNumber”).ToString
4.Pass url into Open Browser.
This way, every iteration opens a new URL with different parameters.
Yes you can put all things in diff. diff. key value pair in config file or assets.
you can store alertTypeID, pageName, and jNumber as separate keys in the config file.
Then use an Assign activity to build the full URL like:
url = “https://…AAA.aspx?alertTypeID=” & in_Config(“alertTypeID”).ToString &
“&pageName=” & in_Config(“pageName”).ToString &
“&jNumber=” & in_Config(“jNumber”).ToString
Pass this url to the Open Browser activity.
If helpful, mark as solution. Happy automation with UiPath