I’m attempting to scrape data from a website that features a card labeled “View Hours.” Within this card, there is certain information that cannot be individually selected. I initially tried using the “Extract Table Data” activity, but the target was not selected as expected. Subsequently, I employed the “Get Text” activity, which does retrieve the necessary information. And once the information is extracted, it should be stored in an ordered manner.
I have attached the files and provided sample screenshots for reference. Sequence4.xaml (19.1 KB)
@NikhilR
Refer to the webpage code, the id tag is stable so that you may use 7 get text activities to retrieve the office hour. Then write them into Excel.
Thanks for the guidance. I already tried using the ‘Get Text’ activity, but it didn’t work. Here is the workflow file using the ‘Get Text’ activity. View Hours Sequence.xaml (28.9 KB)
Not sure of the purpose of for each. I placed another for each to loop the 1st to 10th ‘View hours’.
For the get text activities, use ‘Strict selector’ is more stable and secure.
The index of page Office hours will be increased per opening so that I use wildcard.
Attached is the zip file for your reference. The result will be appended to file result.txt. You may replace it by writing to Excel. View Hours_v2.zip (7.0 KB)
Thank you for the solution; it’s working.
However, when I tried to store the scraped data in the Google Sheets web version, it only saves the last piece of data. Additionally, when using an enumerated range from 1 to 500 or 1000, it’s only retrieving 25 or 40 records. I need to extract more than 1000 records. Could you please assist in resolving this issue?
Further study on the web page, make some changes as below.
Check the ‘View hours’ exists or not in the md card first (beware of the index). If it exists, then get the office hours. If not, mark something (such as, ‘Contact Provider for office hour’).
