0LASubrJsonParse < Main

Tags: view all tags
---+ .JSON PARSE

_This subroutine parses and imports a JSON string (Added in 6.2.0)._

%TOC%
---++ Usage:
<pre>      PASS         &lt;JSON String&gt;              FIELD            SHARE? N
      PASS         &lt;Mode&gt;                     FIELD            SHARE? N
      GOSUB    --- .JSON PARSE
      *        Check for errors
      IF       --- .JSON PARSE                NE
</pre>
---++ Description:

This subroutine processes a JSON string and imports it.

&lt;JSON String&gt; is an alpha field which holds the JSON data. It can be raw or Unicode.

&lt;Mode&gt; can be "SMALL", "MEDIUM", or "LARGE". The value for the mode specifies what file the subroutine uses to import the parsed JSON data into. If you set the mode to SMALL, the result will be written to --- JSONUS memory-related file, if you set the mode to MEDIUM, the result will be written to --- JSONUM memory-related file, and if you set the mode to LARGE, the result will be written to --- JSONUL disk-related file. The difference between these files is the size of the value field.

Please note that setting mode to SMALL gives you the best performance, and setting mode to LARGE gives you the worst performance. So, if you are certain that the value for each attribute doesn't exceed 256 character, use Mode=SMALL, if the value doesn't exceed 32000 characters, use Mode=MEDIUM, otherwise use Mode=LARGE.<br /><br />
| *Mode* | *Result File* | *Value Limit* |
| SMALL | --- JSONUS | 256 Characters |
| MEDIUM | --- JSONUM | 32000 Characters |
| LARGE | --- JSONUL | 1048200 Characters |

To parse a JSON file use [[0LASubrJsonParseFile][.JSON PARSE FILE]] subroutine.
---++ Comments:

_Read what other users have said about this page or add your own comments._

%COMMENT%
Topic revision: r1 - 2022-05-17 - MisaghKarimi