topic RE: Spying browse based application in Product Forum

Spying browse based application

AnushaGP — Fri, 05 Aug 2022 12:16:00 GMT

How to read a entire table from a website and store into collection using blue prism??

------------------------------
Anusha GP
------------------------------

RE: Spying browse based application

michaeloneil — Fri, 05 Aug 2022 15:30:00 GMT

Hi @AnushaGP

If you spy the element and then use a read action within blueprism it should give an option to "Get Table" which should hopefully give you what you are after. Of course make sure the element is readable as a table when its spied.

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

RE: Spying browse based application

AnushaGP — Mon, 08 Aug 2022 05:07:00 GMT

Hi @Michael ONeil
If i spy the element it is not readable as table it is div,so i am not able to get option get table so can u help me...

------------------------------
Anusha GP
------------------------------

RE: Spying browse based application

michaeloneil — Mon, 08 Aug 2022 15:01:00 GMT

Hi Anusha

If its not readable as a table then you may need to read each one individually instead. If its a Div tag you can likely make this dynamic so it can loop through each row within the table by altering the correct part of the div tag. For each read you would have the bot check if it is the correct text and if so you can carry on if not then increase the row count and read the next row. For example set you html attribute to Dynamic and set the read action parameter to include the path which uses a data item to set the row "/HTML/BODY(1)/DIV(2)/DIV(2)/DIV(1)/DIV(1)/DIV(1)/DIV(1)/DIV(2)/DIV(6)/DIV(3)/DIV(1)/DIV(2)/DIV(1)/DIV(2)/DIV("&[Div Row]&")/DIV(1)/SPAN(3)/SPAN(2)" this lets you dynamically run through the row and increase the row number dynamically to read each row.
There may be another way to do this but without knowing the spying options you have for what you are working on its hard to know what options would be available to help you identify correctly or to identify the whole table instead of each row.

------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------

RE: Spying browse based application

AnushaGP — Tue, 09 Aug 2022 04:07:00 GMT

Thank you @Michael ONeil it helped me.

------------------------------
Anusha GP
------------------------------