Retrieve data from webpage to Blue Prism

Question

I am working on creating a bot to get a list of drugs from the webpage.

The first step is to enter the Start Date and End Date and hit the Submit button. The page opens a list of drugs and my next step is to retrieve the list of drugs in a table format. Is there a way I could get data from a webpage to excel or Blue Prism collection?

Could someone please suggest a way?

Answer 1

The best way to approach this would be to spy the table on the page and use a read stage with the action 'get table', this will load the data into collection.

Answer 2

The ideal way to accomplish this would be to spy the table on the page and use a Read stage with the action "Get Table", which will load the data into a collection in Blue Prism