topic RE: storing data in table format in collection in Product Forum

storing data in table format in collection

AnushaGP — Thu, 15 Sep 2022 08:01:00 GMT

I need read the table i have attached the table image for reference
If i spy ds and stored in a collection everything is coming in a single column but i need in a table format can anyone please help me to solve this.

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

RE: storing data in table format in collection

ManpreetKaur1 — Thu, 15 Sep 2022 10:46:00 GMT

HI @AnushaGP,

Can you please confirm which element you spied, post which you might have used "Get table" to fetch the table contents. Sometimes we don't spy the correct element and the table doesn't come in perfect way. Can you try spying "First Name" header or the first value of "First Name" column and then use "Get table" action?

------------------------------
Manpreet Kaur
Manager
Deloitte
------------------------------

RE: storing data in table format in collection

AnushaGP — Thu, 15 Sep 2022 10:58:00 GMT

If i do as u said i wont get action as get table it will get as text.

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

RE: storing data in table format in collection

PvD_SE — Thu, 15 Sep 2022 11:44:00 GMT

Perhaps this:
https://community.blueprism.com/discussion/string-manipulation-to-read-a-table-from-website-to
...would solve your problem?

------------------------------
Happy coding!
---------------
Paul
Sweden
------------------------------