Reading data from HTML Table
Hi Guys , I am trying to read a data from an HTML table. Used REST API to connect to the webpage and able to get the response. However parsing the table is really challenging.
I tried the XML parse...
Forum Discussion
You were on the right track with the XML Parser. It can parse the XHTML file into a JSON structure that you can manipulate with other snaps and the expression language. Here’s an example pipeline that parses the table in the URL you sent:
ReadHTMLTable_2019_10_18.slp (13.3 KB)
Note that the XML Parser takes some time to run initially since it needs to download the XHTML DTDs from w3.org and, unfortunately, they have implemented an artificial delay on that download.
The html.decode() function is for decoding HTML entities (e.g. <) and not for parsing HTML itself.
Hi @tstack , For some reason the exact pipeline is not working now suddenly. It throws error on the “Parse XML” snap. I dont see , anything changed in the source as well. Wondering , if you can help on this.
Never mind… I just found it… Fixed it
Hi @Naveen4baba, I am facing the same challenge with Parse XML. How was it fixed?
Hello Naveen4baba,
I know this is an old thread, and I hope that you're still around!
I found this thread while looking for a solution to the exact same use case, and the attached sample pipeline is also giving me an error. I'm not sure if the error is related to something that changed in SL itself, but if you can remember what what the issue that you fixed, would you mind sharing the solution with me?
Thanks a lot in advance!
JF
