cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
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!