cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
lwx228
Level VIII

How can arrange JSON into a table using JSL?

See the JMP's ability to quickly download JSON data from the WEB and organize it into a table form.

 

https://community.jmp.com/t5/Discovery-Summit-2018/Importing-Web-Service-Data-The-New-HTTP-Request-i... 

 

But I failed to master the method.Just learn to download this JSON file using JSL.Ask an expert how to organize data into tables.

 

Thanks!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Ryan_Gilmore
Community Manager Community Manager

Re: How can arrange JSON into a table using JSL?

Here's one method of creating a data table from a text file that contains JSON,

 

 

data = Load Text File( "json1.txt", JSON );
dt = JSON To Data Table( As JSON Expr( data ) );

 

View solution in original post

5 REPLIES 5
Ryan_Gilmore
Community Manager Community Manager

Re: How can arrange JSON into a table using JSL?

Here's one method of creating a data table from a text file that contains JSON,

 

 

data = Load Text File( "json1.txt", JSON );
dt = JSON To Data Table( As JSON Expr( data ) );

 

lwx228
Level VIII

Re: How can arrange JSON into a table using JSL?

Thank Ryan_Gilmore!

 

2019-10-09_20-28.png

lwx228
Level VIII

Re: How can arrange JSON into a table using JSL?

Instead, I simply used the JSL code that downloaded the web data using JMP and added a later line of converted code.Please continue to guide me, thank you!

 

2019-10-09_20-36.png

lwx228
Level VIII

Re: How can arrange JSON into a table using JSL?

I wrote it this way.

 

url = "http://……";
request = New HTTP Request(
	URL(url),
	Method("GET")
);
data = request << Send;Wait(0);
dt = JSON To Data Table( As JSON Expr( data ) );
lwx228
Level VIII

Re: How can arrange JSON into a table using JSL?

dt = JOpen( url, JSON );

I SEE.Thanks!