topic RE: Get Table Data in Edge in Product Forum

Get Table Data in Edge

sarthak_86 — Wed, 23 Feb 2022 11:23:00 GMT

I have migrated one object from IE to Edge. When I am trying to fetch the data of the table by using Get Table Items, instead of getting the table row data, I am also getting the table header and unnecessary values like the row count etc.

Please find below the reference table for better understanding(this is not the real table on which I am working):

I am getting the data from the top i.e. search result to the page count below(14 >), but I only need the values below action.
I am not able to spy the table row elements individually.

Thanks in advance for your help.

------------------------------
Sarthak Dhasmana
Systems Engineer,
Tata Consultancy Services
------------------------------

RE: Get Table Data in Edge

Sheeetzz — Wed, 23 Feb 2022 11:59:00 GMT

Hello Sarthak,

To reach the individual row, could you try dynamic indexing using UI mode to spy the elements and capture the specific results?
In edge, we have tried this for multiple tables and it works.

check it out once.

------------------------------
Sheetal Vijaykumar
Senior Software Engineer
Sony India
Asia/Bangalore India
------------------------------

RE: Get Table Data in Edge

sarthak_86 — Wed, 23 Feb 2022 12:49:00 GMT

Thanks Sheetal for the inputs.
Which attributes you are using for dynamic selection, I have tried using match index in UI mode but it is not behaving correctly.

------------------------------
Sarthak Dhasmana
------------------------------

RE: Get Table Data in Edge

JohanSörman — Wed, 23 Feb 2022 14:02:00 GMT

I have deployed a similar solution in the past. Are you able to read the TR value instead of the whole TD html element, increment it with row index should solve it for you and just add +1 until you got all rows read.

------------------------------
Johan Sörman
DevOps Engineer, RPA Developer
Telia Company
Sweden
------------------------------

RE: Get Table Data in Edge

Rambo27 — Wed, 23 Feb 2022 14:40:00 GMT

Hi Sarthak,

For dynamic selection and how to go ahead. Please check for your reference.

How-to-change-path-of-html-attribute-in-blueprism

Hope it helps

------------------------------
Shikhar Mishra
RPA Lead
Infosys Pvt Ltd
Pune,India
------------------------------

RE: Get Table Data in Edge

sarthak_86 — Wed, 23 Feb 2022 15:06:00 GMT

Thanks Johan,
I have tried to get the rows by modifying the html path in application modeller, but now I am facing another issue.
I am trying to read row values by using the Get table items but getting the below error:
The operation has timed out.

Any suggestions to fix this.

Thanks

------------------------------
Sarthak Dhasmana

------------------------------

RE: Get Table Data in Edge

lookman — Wed, 23 Feb 2022 15:17:00 GMT

Hi Sarthak.

I too noticed this and I simply used a filter collection to remove the headers.

jack

------------------------------
Jack Look
Sr Product Consultant
Blue Prism
------------------------------

RE: Get Table Data in Edge

dmma — Wed, 23 Feb 2022 15:22:00 GMT

Hi, Sarthak,
If you need some specific rows from the table, what you can try is this:
1. Get XPath to that cell, which you can try and extract using Edge Developer tools, by inspecting the HTML elements on the web page:
As a result, you should be able to get the path to specific cell or row.
2. Add new element into the BluePrism Object, select type as Table Item, update its web path attribute, with value extracted from the previous step.

If you need to read several rows, but you don't need to read full table, you can make Web Path attribute as Dynamic.

Then you can create a dynamic string with Xpath for a specific row or rows, using string concatenation.

Attaching a simple object with one action as an example for your reference.
If any questions, let me know. This is just one way of doing it.

------------------------------
Kind regards,

Dmitrij Mamajev
Senior RPA Developer
Substorm AB
Gothenburg - Sweden
------------------------------

RE: Get Table Data in Edge

sarthak_86 — Wed, 23 Feb 2022 15:25:00 GMT

Hi Jack,
I have thought of using filter, but still trying to figure out if there is any other way to do this as in my case I am getting headers and 1,2 extra rows also.
Hoping to get a stable approach to do it.

Thanks

------------------------------
Sarthak Dhasmana
------------------------------

RE: Get Table Data in Edge

dmma — Wed, 23 Feb 2022 15:26:00 GMT

Sample object with action.

------------------------------
Kind regards,

Dmitrij Mamajev
Senior RPA Developer
Substorm AB
Gothenburg - Sweden
------------------------------

RE: Get Table Data in Edge

sarthak_86 — Thu, 24 Feb 2022 06:10:00 GMT

Thanks Dmitrij for the detailed explanation and for the object, I am able to move through different rows, but as per your object you are using Get Text for reading the value, is it possible to get the data row-wise in a collection.

The second option which I am thinking is to convert the text to the collection by using string manipulation.

------------------------------
Sarthak Dhasmana
------------------------------

RE: Get Table Data in Edge

dmma — Thu, 24 Feb 2022 07:46:00 GMT

I am not sure if I understood you correctly.
Probably you want to get HTML Table row as Blueprism collection. I think that is not available in BP out of the box.
Either you can try and look in DX some parser that is converting HTML table into Datatable object, which is BP collection.
Or another workaround might be, that you can input web path of the table row (tr), not the table cell (td). Then read that full row value into text dataitem,
As an output value, you should get space-separated values.
Then you can split these values (using string split methods)and populate your defined collection, or use regex in order to extract each cell value.

Another alternative way could be to get HTML value of the row. And use regex to extract each cell value, as value will be separated now with HTML tags.

------------------------------
Kind regards,

Dmitrij Mamajev
Senior RPA Developer
Substorm AB
Gothenburg - Sweden
------------------------------