Cannot extract table data with table structure preserved using Extract Table Data

Help Studio
1

I am trying to extract the CME Term SOFR Rates Value from this website: Term SOFR - CME Group using Extract Table Data activity. The table is only visible after login and I do logged in.

The selector can select the table element as a whole but it output all data in one string. In the selector, it indicates it think the table structure is one row and one column.

The selector can select single header cell but cannot select data cell.

I also tried Find Children but it is also not working.

Any suggestion?

Forum Engagement Daily Reports
2

You can try this approach
Use Get Attribute → innerText on the table element an this will return the raw text of the “table” and from there, you can split rows by \n and columns by \t or multiple spaces and you can build a DataTable manually from that.

Or you can use Computer Vision CV Extract Table Data because UiPath’s Computer Vision activities can recognize table-like structures even when the HTML is non-semantic. This works well if the table is visually clear but not programmatically accessible. Requires the CV package and an API key (free to try).

Cheers

4

Thank you for the suggestion.
Looks like my company do not allow us to use CV. I will try the first approach.

1 Like