Accessing a HTML Based Data on a Web Page

Help Studio
1

Hello dear community, Today I´m facing a new challenge, and hopefully someone can guide me through the correct route.

I´m working on an automation that fills and gets data from multiple sources. One of the sources where I need to take my data from is HTML-based content in different tables, like this…

image
image1920×607 44.8 KB

When I inspect the page as I said, is based in HTML (Which I don´t know much about).

The goal is to be able to extract the data from a specific table inside of this page. Because there are multiple tables with different names and I need to take just one or two.

How can I access this information and get the specific data I need from it?

Hopefully, I made my inquiry clear, if not let me know.

Thank you very much for the attention, Regards.

2

Have you tried data scraping / Table Extraction?
grafik

3

Hello @ppr yeah sure I have! Sorry, I didn´t clarify that.

The thing is that the page shows multiple tables with different labels… As you can see in the image the table we are looking at is the “DECLARACIÓN” but there are a couple or even more than a couple on the same page. Where I´m having trouble is how I´m able to find the correct table inside the web page and start the table extraction from there. Traditional UI methods seem to have no power on this page.

4

lets assume full table extraction of a particular table ( we are not limited on part extractions )

  • when interested on a particular table it will be reflected on the selector used for the table extraction activity configuration
  • here we can also used techniques like anchoring the table to a particular element e.g. a headline, section text…
5

Hello @ppr Sorry it took me so long to respond.

I´m using the Table Extraction Wizard and it looks like it captures the correct table dynamically. I wrote the topic in the first place because I thought the page was more complex than that, but it looks it identifies the table with no problem. Yet I do have a question, I couldn´t find any configuration inside the Table Extraction to manipulate the selector or create some sort of an anchor, so I´m wondering how would you make that possible as you suggested?, I’m curious.

Thank you very much for your attention

Regards.