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

How can arrange JSON into a table using JSL?

lwx228 — Wed, 09 Oct 2019 10:36:30 GMT

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-in-JMP-nbsp-14/ta-p/73717

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!

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

Ryan_Gilmore — Wed, 09 Oct 2019 12:10:46 GMT

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 ) );

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

lwx228 — Wed, 09 Oct 2019 12:30:55 GMT

Thank Ryan_Gilmore!

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

lwx228 — Wed, 09 Oct 2019 12:41:37 GMT

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!

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

lwx228 — Wed, 09 Oct 2019 12:42:58 GMT

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 ) );

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

lwx228 — Thu, 10 Oct 2019 23:45:24 GMT

dt = JOpen( url, JSON );

I SEE.Thanks!