cancel
Showing results for 
Search instead for 
Did you mean: 

Get Table Data in Edge

sarthak_86
Level 5
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):

13448.png 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
------------------------------
11 REPLIES 11

Sheeetzz
Level 3
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
------------------------------

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
------------------------------

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
------------------------------

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
------------------------------
Shikhar Mishra RPA Lead Infosys

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

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

lookman
Staff
Staff
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
------------------------------

dmma
Level 5
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:
13438.pngAs 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.
13439.png
If you need to read several rows, but you don't need to read full table, you can make Web Path attribute as Dynamic.
13440.png
Then you can create a dynamic string with Xpath for a specific row or rows, using string concatenation. 

13441.png
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
------------------------------
Kind regards, [FirstName] [LastName] [Designation] [JobTitle] [CompanyName] [City] [State] [Phone]

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
------------------------------

dmma
Level 5
Sample object with action.

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

Dmitrij Mamajev
Senior RPA Developer
Substorm AB
Gothenburg - Sweden
------------------------------
Kind regards, [FirstName] [LastName] [Designation] [JobTitle] [CompanyName] [City] [State] [Phone]