use extract data web recorder tool with url from sql server query

[zyb5586]

Hi,

I have purchased automation anywhere but cannot figure out how to make the following:
1. run sql query and get number of urls
2. loop though each record extracted (URL)
3. use the extract data tool (in here must input URL takes from sql server) to extract data from website.

Does extract data tool support or not as input a variable value in the URL variable?

Thanks,
Phillip

[forumsupport]

Hello,

Using Automation Anywhere you can certainly automate the mentioned task.

Using 'Execute SQL' Database command you can get the list of URL's. To access the result returned by the SQL Query, use the $Dataset Column$ System variable provided by Automation Anywhere. Use Loop for Each row in a SQL query dataset option to loop through all the rows of the SQL Query result. To access each column use $Dataset Column(index)$ for e.g. to get the first column use $Dataset Column(1)$.

Automation Anywhere provides a tool called Web Recorder using which you can automate almost any web task. For e.g. you can extract data from any website in real time and the extracted data can be transfered into any application in required format. 'Open Browser' Web Recorder command does provide variable support for URL field.

You can view demos on how Web Recorder works at,
Automation Anywhere - Learning Center
Automation Anywhere - Learning Center
Automation Anywhere - Learning Center

You can view online sample tasks for web data extraction at, http://www.tethyssolutions.com/autom...dataextraction

Hope that helps.