Download csv file from the web (markets.businessinsider.com)

HI,

if you use a Page Inspector like Chrome Developer Tools (control+shift+I) you can see the data is being sent as a JSON feed to the page.

The address is something like https://markets.businessinsider.com/Ajax/Chart_GetChartData?instrumentType=Index&tkData=189,169323,189,333&from=20210726&to=20220926 (open this link to see the JSON)
Using this information you can easily build a flow in KNIME to GET the endpoint and parse the JSON. I’ve attached a workflow to show you how.

Business Insider Markets – KNIME Hub

7 Likes