Support > Forums > OpenBots Studio > how to do web scrapping as output datatable format

how to do web scrapping as output datatable format

Arun Pondhe

  • Reporter
  • Calender Icon May 15,2023 at 6:43 AM

Can anyone support how to work on Native browser command with selector part

This forum has 317 topics, 688 replies, and was last updated 5 hours ago by Sainath S

Arun Pondhe

  • Participant
  • Calender Icon May 17,2023 at 5:35 AM

Hi @Nataly Alvarado Thank you for support

Nataly Alvarado...

  • Participant
  • Calender Icon May 17,2023 at 4:50 AM

Hi Arun Pondhe,

You can use the Native Browser Get Table command to extract table elements into a datatable variable. You can follow the below steps to extract the Example table in the following site: https://www.w3schools.com/html/html_tables.asp

Use the Native Element Recorder and select one of the table cells. The generated selector will point to the table cell element. In order to extract the table as a whole, you will need to modify the selector to point to the Table type element. Uncheck the last parameter "Tag Name: TD" and check the "Tag Name: TABLE" as the targeted element. Note that only HTML elements tagged as TABLE will be recognized by the command.

View the Table parameter information. You will notice that the ID, Tag Name and Inner Text fields are enabled. In this case, only the ID and Tag Name are need, the Inner Text information contains data that could change dynamically, as well as invalid characters (\t), so it should be deselected.

Validate your selector to make sure the changes are effective by clicking on UI Element Validator

Indicate the output datatable variable and run the script

The table contents should be extracted into the datatable variable, which you can use across your automation.

You are not authorized to reply, please click here to login and add your reply to this topic.