Workflow Builder/Action Recorder capture more types of files opened from the internet

Jed_Campbell

What inspired this Wish List Request? 

Workflow Builder correctly captures File...Internet Open...Web Page requests where JMP needs to scrape a table from an actual web page (for example, this random wikipedia article), but web addresses that return .csv files directly don't get captured in the Action Recorder (and, thus, the Workflow Builder). For example, this link opens just fine in JMP, but doesn't show up in the Action Recorder.

An "workaround is to paste the link into the standard File...Open dialog.  This shows up in the Action Recorder/Workflow builder, but unfortunately references the temporary locally cached file instead of the web address.

Another kinda? workaround is to retroactively go into the JSL and overwrite the locally cached file location with the URL. This works, but requires scripting knowledge, which the Workflow Builder is trying to avoid. Sample of script below:

Open(
	"/C:/Users/jejcam/AppData/Local/Microsoft/Windows/INetCache/IE/FG3RAF0Z/state_of_utah[1].csv", //<--not desired
	columns(
		New Column( "date", Character, "Nominal" ),
		New Column( "1981", Numeric, "Continuous", Format( "Best", 12 ) ),
		New Column( "1982", Numeric, "Continuous", Format( "Best", 12 ) ),
		New Column( "1983", Numeric, "Continuous", Format( "Best", 12 ) ),
	//code continues.....	
		
Open(
	"https://www.nrcs.usda.gov/Internet/WCIS/AWS_PLOTS/basinCharts/POR/WTEQ/assocHUCut3/state_of_utah.csv", //<--desired
	columns(
		New Column( "date", Character, "Nominal" ),
		New Column( "1981", Numeric, "Continuous", Format( "Best", 12 ) ),
		New Column( "1982", Numeric, "Continuous", Format( "Best", 12 ) ),
		New Column( "1983", Numeric, "Continuous", Format( "Best", 12 ) ),
	//code continues...

Please describe the new or improved feature or solution you would like to see.  

I'd like the Workflow Builder to automagically record File...Internet Open steps.

 

What would the value be to you and/or other users if this new feature is provided? 

This will help a number of use cases where workflows rely on web/network/cloud data for their workflows.

Is this an external customer request? 

No

Is there a competitive software package that has this feature or solution that we should be aware of? 

N/A

Will this impact a renewal, expansion, or adoption at a customer, and does this put an account at risk if we do not address this? 

 

Sarah-Sylvestre

Hi @Jed_Campbell, thank you for your suggestion! We have captured your request and will take it under consideration.