I’m extracting table data from a website, which is working fine for the most part. It’s invoice data and I’m extracting all the pages for the last 30 days, then comparing the date in the extracted table to today to ensure I’m only getting rows for the current month. Side note, would be great if there’s a way to only extract the rows meeting the above criteria into the extracted table? but that’s not really my question, as the way I’m doing it now will work.
My question is, each row contains a element, with a unique ID that’s made up of elements in the row that are re-formatted in a specific way. I’ve been able to re-create the ID and I’m storing it in a variable, but I need to do 2 things:
- click on the button that has that ID.
- presumably I would need to navigate back to the page that contains the ID of the element I want to click? If so, how do I do that?
It seems like it would be much more effective to iterate over the table, check the date, if it meets my criteria, click the button on the row to download the invoice, but it doesn’t seem like that’s the way Table Extraction works. Is there another method I should be using?