It’s World Statistics Day! To honor the theme of the day, the JMP User Community is having conversations about the importance of trust in statistics and data. And we want to hear from you! Tell us the steps you take to ensure that your data is trustworthy.
Choose Language Hide Translation Bar
Highlighted
lwx228
Level VII

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
Highlighted
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
Highlighted
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

Highlighted
lwx228
Level VII

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

Thank Ryan_Gilmore!

 

2019-10-09_20-28.png

Highlighted
lwx228
Level VII

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

Highlighted
lwx228
Level VII

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 ) );
Highlighted
lwx228
Level VII

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

dt = JOpen( url, JSON );

I SEE.Thanks!

 

Article Labels

    There are no labels assigned to this post.