Grab data from particular data element from HTML of web page

Question

Hi community I have a public web page here as an example: https://aca-prod.accela.com/MILARA/GeneralProperty/LicenseeDetail.aspx?LicenseeNumber=2901014894&LicenseeType=Dentist I need Alteryx to pull the License Expiration Date which in this case is 9/29/2024 I have a WF attached to pull the HTML. I am not HTML expert, but it looks like the below is the element I need:

Expiration Date

how do I get Alteryx to read the actual expiration in so that the data shows 9/29/2024 Thank you!!! HTML using Alteryx.yxmd

danilang · Answer

Hi @MemphLantAntonio

If you want to keep an Alteryx framework around the project, maybe for scheduling on the server, have a look at this Article that gives examples of how to use Selenium within Alteryx.

Dan

acarter881 · Answer

@MemphLantAntonio yeah that may be tough to debug in Designer. I highly suggest Python, especially since ChatGPT has a Code Interpreter (in Beta mode, available if you pay for the monthly subscription) which is great at helping with Python.

MemphLantAntonio · Answer

I just noticed that, you are right, if I "save" as the page to look at the HTML from Edge, I see the Expiration Date in the HTML, but that is not in the WF results that come out of the download tool

Python or R were going to be my next steps but was hoping to be able to do this in Alteryx