This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
jearls11
jearls11
Level III

Download CSV from Website

Created: Sep 12, 2022 08:45 AM  |  Last Modified: Jun 9, 2023 11:58 AM (1324 views)

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,

 

jearls11_0-1662986728758.png

 

0 Kudos
2 REPLIES 2
jthi
Super User jthi
Super User

Re: Download CSV from Website

Sep 12, 2022 08:53 AM (1321 views)  |  Posted in reply to message from jearls11 09-12-2022

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).

-Jarmo
Craige_Hales
Super User Craige_Hales
Super User

Re: Download CSV from Website

Sep 12, 2022 09:43 AM (1315 views)  |  Posted in reply to message from jthi 09-12-2022

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 Browser Scripting with Python Selenium  helpful, but the learning curve will be longer.

Craige