cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
The Discovery Summit 2025 Call for Content is open! Submit an abstract today to present at our premier analytics conference.
See how to use JMP Live to centralize and share reports within groups. Webinar with Q&A April 4, 2pm ET.
Choose Language Hide Translation Bar
View Original Published Thread

How can arrange JSON into a table using JSL?

lwx228
Level VIII

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!