bvstone

Parsing JSON data with RPG and JSONTOOL from BVSTools

Posted:

Parsing JSON data with RPG and JSONTOOL from BVSTools

Internally we have used a JSON parser for some time, and now are being asked to make it available to customers. 

We did this by providing the JSONTOOL library which contains, right now, a service program named F.JSON.  This contains one subprocedure used to parse JSON.  The prototype is as follows:

      ****************************************************************
      *                                                              *
      * If the data begins with an array, you will need to wrap it   *
      * as another object so things will work like this:             *
      *                                                              *
      * Before:                                                      *
      * [{object}, {object}]                                         *
      *                                                              *
      * After:                                                       *
      * {"data": [{object}, {object}] }                              *
      *                                                              *
      * Then you'll access it with data[index]:object                *
      *  where index is the instance of the object to retrieve       *
      *                                                              *
      * http://bvstools.com/jsontest.html                            *
      *                                                              *
      * 7/24/2014 - Added TAB to convert to blanks                   *
      *           - Changed conversion of CR, LF and TAB to blanks   *
      *              if NOT in quotes.                               *
      ****************************************************************
      *//////////////////////////////////////////////////////////////*
      * #js_getData - get a character value from JSON data           *
      *                                                              *
      * Input:                                                       *
      *   in_data (required) - The JSON Data                         *
      *   in_tag (required) - The tag to retrieve data for           *
      *                                                              *
      *   Tag should be in the format:                               *
      *    name1[index]:name2[index]....                             *
      *                                                              *
      *    If an index is left off, 1 is assumed for the index.      *
      *                                                              *
      * EXAMPLES:                                                    *
      *                                                              *
      * JSON Data                                                    *
      * {"name":"Brad", "age":"43", "favoriteShow":"Top Gear"}       *
      *                                                              *
      * #js_getData(JSONData:'name') = Brad                          *
      * #js_getData(JSONData:'age') = 43                             *
      * #js_getData(JSONData:'favoriteShow') = Top Gear              *
      *                                                              *
      * JSON Data                                                    *
      * {"data":[                                                    *
      *  {                                                           *
      *   "color": "red",                                            *
      *   "value": "#f00"                                            *
      *  },                                                          *
      *  {                                                           *
      *   "color": "green",                                          *
      *   "value": "#0f0"                                            *
      *  }                                                           *
      * ]}                                                           *
      *                                                              *
      * #js_getData(JSONData:'data[1]:color') = red                  *
      * #js_getData(JSONData:'data[1]:value') = #f00                 *
      * #js_getData(JSONData:'data[2]:color') = green                *
      * #js_getData(JSONData:'data[2]:value') = #0f0                 *
      *                                                              *
      * JSON Data                                                    *
      * {"level1":{"level2":{"name1":"value1", "name2": "value2"}}}  *
      *                                                              *
      * #js_getData(JSONData:'level1:level2:name1') = value1         *
      * #js_getData(JSONData:'level1:level2:name2') = value2         *
      *                                                              *
      * Returns:                                                     *
      *   The data value of the tag requested                        *
      *                                                              *
      *//////////////////////////////////////////////////////////////*
     D #js_getData     PR         65535    Varying
     D   In_data                  65535    Value Varying
     D   In_tag                   65535    Value Varying
      *--------------------------------------------------------------*

If you wish to receive a copy of JSONTOOL as well as a trial key, pleave visit www.bvstools.com/jsontool.html

We also have a web page set up so you can try things out at http://bvstools.com/jsontest.html.

Check out this Proof of Concept post using JSONTOOL for a real world example.


Last edited 10/17/2014 at 10:58:46



Latest Posts:

SSL Handshake Errors with GETURI, MAILTOOL and GreenTools Products SSL Handshake Errors with GETURI, MAILTOOL and GreenTools Products
Posted by October 18, 2021
BVSTools >> BVSTools Software Discussion
MAILTOOL Updated to Retry Sending when GSK SSL Handshake Error 415 (GSK_ERROR_BAD_PEER) is Encountered MAILTOOL Updated to Retry Sending when GSK SSL Handshake Error 415 (GSK_ERROR_BAD_PEER) is Encountered
Posted by August 19, 2021
BVSTools >> BVSTools Announcements >> eMail Tool (MAILTOOL) Specific Announcements
MAILTOOL Updated to Allow List-Unsubscribe and User Defined Headers MAILTOOL Updated to Allow List-Unsubscribe and User Defined Headers
Posted by August 13, 2021
BVSTools >> BVSTools Announcements >> eMail Tool (MAILTOOL) Specific Announcements
AWS signing process in as400 AWS signing process in as400
Posted by August 13, 2021
Programming >> Web Programming
2022 License Price Increase and Consulting Update for Non-Software Specific Assistance 2022 License Price Increase and Consulting Update for Non-Software Specific Assistance
Posted by August 9, 2021
BVSTools >> BVSTools Announcements
Journaling the IFS, SPLTOOL and Java Journaling the IFS, SPLTOOL and Java
Posted by August 4, 2021
BVSTools >> BVSTools Announcements >> Spooled File Tools (SPLTOOL) Specific Announcements
G4MSMAIL Now Allows Wildcard Attachments G4MSMAIL Now Allows Wildcard Attachments
Posted by June 10, 2021
BVSTools >> BVSTools Announcements >> GreenTools for Microsoft Apps (G4MS) Specific Announcements
G4G Update for Uploading Large Files G4G Update for Uploading Large Files
Posted by May 28, 2021
BVSTools >> BVSTools Announcements >> GreenTools for G Suite (Google Apps) (G4G) Specific Announcements
Can We Purchase License Keys for More Than One Year at a Time? Can We Purchase License Keys for More Than One Year at a Time?
Posted by May 21, 2021
BVSTools >> BVSTools Announcements
JOBWATCH 5.10 Released with New Feature to Monitor CPU Percentages JOBWATCH 5.10 Released with New Feature to Monitor CPU Percentages
Posted by May 10, 2021
BVSTools >> BVSTools Announcements >> Job Watch (JOBWATCH) Specific Announcements
Iseries Access data transfer Iseries Access data transfer
Posted by April 29, 2021
IBM Power Systems >> (QGPL) IBM i
YAJL - Parsing YAJL - Parsing
Posted by April 4, 2021
Programming >> RPG Programming
Create LPAR partition and install OS Create LPAR partition and install OS
Posted by March 24, 2021
IBM Power Systems >> (QGPL) IBM i
G4MS Now Allows User/Password Authentication Option G4MS Now Allows User/Password Authentication Option
Posted by March 16, 2021
BVSTools >> BVSTools Announcements >> GreenTools for Microsoft Apps (G4MS) Specific Announcements
IPDS printer file using CHRSIZ IPDS printer file using CHRSIZ
Posted by February 25, 2021
Programming >> RPG Programming

Reply




Copyright 1983-2020 BVSTools
GreenBoard(v3) Powered by the eRPG SDK, MAILTOOL Plus!, GreenTools for Google Apps, jQuery, jQuery UI, BlockUI, CKEditor and running on the IBM i (AKA AS/400, iSeries, System i).