How to pull data from a website that does not have an API?

Here’s a workflow which may help get you started. My Xpath skills are pretty limited. I’ve been unable to get the values to parse correctly. Maybe someone with better Xpath knowledge can help. The xml seems to be pretty poorly formed.
Simple Web Scraper.knwf (112.8 KB)



Here’s a csv file from this website:

sp-500-pe-ratio-price-to-earnings-chart.csv (23.0 KB)

Blockquote

1 Like