Extract a Table from webpage and write out as excel or similar

You can use the url directly in a HTML table reader

Hi @ebygomm​ almost what I am looking for but I have a feature class that contains the url which is built from parameters. This is a test case to illustrate what I would like to happen. This will need to handle 10s to 100s of calls to the end point with different parameter, so in effect in would need to these url in as inputs.

What this reader does is exactly what I would like to do with the html fragment I have, but I need to use information which will come from the feature for other parts of the workflow.

So you just use a FeatureReader with the HTML Table format if you need the url to come from input features

@ebygomm​ Thanks for you help, I'm new to this but I don't think that will work. I have successfully got the html snippit as an attribute which is what I want to push into an excel sheet. From what I can tell FeatureReader will get me to the same place I am currently stuck at. Anyway I'm going to go with the two part solution of pushing the table data into a html file and then in another workspace use HTMLTable reader.

See the attached workspace. I downloaded your workspace and added the logic from the article you mentioned here: https://community.safe.com/s/article/how-to-expose-feature-attributes-from-kml-tag

I used the XMLFragmenter rather than the XQueryExtractor, because the former is easier to configure and doesnt depend on an exact XQuery expression. The other trick is that there are several different ways to store HTML tables. KML tables are structured slightly differently than your html table. So first its a matter of extracting the table into different features with the XMLFragmenter. Next we need to use the AttributeExposer to expose the newly extracted attributes we want to work on. Then we use an AttributeCreator to define the row values from td{0} to td{10} in your case. Finally we write this out to csv.