- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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 ) );
5 REPLIES 5
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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 ) );
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How can arrange JSON into a table using JSL?
Thank Ryan_Gilmore!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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 ) );
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How can arrange JSON into a table using JSL?
Created:
Oct 9, 2019 09:46 AM
| Last Modified: Oct 10, 2019 4:45 PM
(3217 views)
| Posted in reply to message from lwx228 10-09-2019
dt = JOpen( url, JSON );
I SEE.Thanks!