topic Re: Using JSL to download Web JSON data, can be directly written into the matrix? in Discussions

Using JSL to download Web JSON data, can be directly written into the matrix?

lwx228 — Fri, 09 Jun 2023 22:10:22 GMT

A table in all digital format can be downloaded using the following JSL.

u = "http……";
txt = Load Text File( u );
loc1 = "[{";
offset = Contains( txt, loc1 );
If( offset,
	txt = Substr( txt, offset, Length( txt ) )
);
loc2 = "}]";
offset = Contains( txt, loc2, -1 );
If( offset,
	txt = Substr( txt, 1, offset + 1 )
);
d1 = JSON To Data Table( txt );//without going through a "d1" file.

How to write the data directly into the matrix without going through a "d1" file.

Thanks Experts!

Re: Using JSL to download Web JSON data, can be directly written into the matrix?

Craige_Hales — Fri, 02 Apr 2021 19:06:14 GMT

What problem are you trying to solve? The download time will be 100 times as long as the conversion from table to matrix.

Re: Using JSL to download Web JSON data, can be directly written into the matrix?

lwx228 — Fri, 02 Apr 2021 23:18:54 GMT

OK.

table to matrix.

Thank Craige!