http://www.sharkattackdata.com/place/australia how can i scrape this page and get the table as a CSV, Im a total noob and ive tried watching youtube but the tutorials are still above my level and i cant seem to apply them to my job. I know i need a HTTP Caller,
Hi @teeks82,
I suspect you will have to dive into css to help you extract the data from the web page.
Normally the HTML Table Reader should be able to do that, but that depends on how the web page is made and after trying it myself I could not get the correct information.
Another option is using the HTMLExtractor transformer, and for that you need to dive into css selectors.
Hope this helps.
Itay
The data behind the table is available in a json file at http://www.sharkattackdata.com/api/attacks?country=australia you should be able to use a json reader to access it directly.
The data behind the table is available in a json file at http://www.sharkattackdata.com/api/attacks?country=australia you should be able to use a json reader to access it directly.
A lot easier....