topic Download CSV from Website in Discussions

Download CSV from Website

jearls11 — Fri, 09 Jun 2023 15:58:17 GMT

I want to import a data table from a website. There is a csv button to download the data manually.

I want to be able to pull this automatically to run a on a schedule.

is it possible to do this in JMP? Like a webscraper or along those lines?

Thanks,

Re: Download CSV from Website

jthi — Mon, 12 Sep 2022 12:53:36 GMT

You might be able to get the data with JMP's New HTTP Request() depending on how the website is built and how the file is served (Web Developer Tools help with this).

Re: Download CSV from Website

Craige_Hales — Mon, 12 Sep 2022 13:43:21 GMT

If the site is not using some form of authentication, you can use your browser to discover the URL behind the button. Press F12 on firefox or chrome or edge to open the developer pane and watch the Network tab. Click the CSV download button and study what happened...you are looking for a GET request and the URL it used. Right-click File->CopyValue->CopyUrl might get what you need. Press F12 again to close the developer pane.

If the site requires authentication (user name, password) you might find helpful, but the learning curve will be longer.