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:

Create QRCODE in DDS Create QRCODE in DDS
Posted by September 21, 2018
Programming >> RPG Programming
Base64 Encoding a File with RPG Base64 Encoding a File with RPG
Posted by September 6, 2018
Programming >> RPG Programming
Building JSON with RPG and YAJL and Writing to Standard Output Building JSON with RPG and YAJL and Writing to Standard Output
Posted by August 31, 2018
Programming >> Proof of Concept (POC)
How to Delete Files or Empty Trash From Your Google Drive with your IBM i and RPG/ILE How to Delete Files or Empty Trash From Your Google Drive with your IBM i and RPG/ILE
Posted by July 24, 2018
BVSTools >> BVSTools Software Discussion >> GreenTools for G Suite (Google Apps) (G4G) Specific Discussion
GreenTools for G Suite (G4G) Updated to Include Delete and Empty Trash Function GreenTools for G Suite (G4G) Updated to Include Delete and Empty Trash Function
Posted by July 24, 2018
BVSTools >> BVSTools Announcements >> GreenTools for G Suite (Google Apps) (G4G) Specific Announcements
What to Do If Your License Keys Don't Work What to Do If Your License Keys Don't Work
Posted by July 18, 2018
BVSTools >> BVSTools Software Discussion
MAILTOOL Updated to Allow Failed Message on Invalid Recipient MAILTOOL Updated to Allow Failed Message on Invalid Recipient
Posted by May 20, 2018
BVSTools >> BVSTools Announcements >> eMail Tool (MAILTOOL) Specific Announcements
Non HTTPS Callbacks Removed from GreenTools for G Suite (G4G) Non HTTPS Callbacks Removed from GreenTools for G Suite (G4G)
Posted by April 15, 2018
BVSTools >> BVSTools Announcements >> GreenTools for G Suite (Google Apps) (G4G) Specific Announcements
IBM i Related Survey Available IBM i Related Survey Available
Posted by April 7, 2018
IBM Power Systems >> (QGPL) IBM i
BVSTools Releases Braintree Webhook Open Source Application - Node.js BVSTools Releases Braintree Webhook Open Source Application - Node.js
Posted by April 5, 2018
Programming >> Open Source
BVSTools Now Offering Web Services (BETA) BVSTools Now Offering Web Services (BETA)
Posted by April 3, 2018
BVSTools >> BVSTools Announcements
Creating a Reverse SSL Proxy Using RPG on the IBM i - Part 2 Creating a Reverse SSL Proxy Using RPG on the IBM i - Part 2
Posted by March 29, 2018
Programming >> Web Programming
Still on V7R1 or Earlier?  Here's Why You Should Upgrade NOW! Still on V7R1 or Earlier? Here's Why You Should Upgrade NOW!
Posted by February 21, 2018
IBM Power Systems >> (QGPL) IBM i
Converting a MMDDYY date format to YYMMDD for Sorting Using SQL Converting a MMDDYY date format to YYMMDD for Sorting Using SQL
Posted by February 16, 2018
Programming >> RPG Programming
Moving All Files from a Google Drive Folder to the Trash Using GreenTools for Google Apps (G4G) Moving All Files from a Google Drive Folder to the Trash Using GreenTools for Google Apps (G4G)
Posted by February 3, 2018
BVSTools >> BVSTools Software Discussion >> GreenTools for G Suite (Google Apps) (G4G) Specific Discussion

Reply




Copyright 1983-2018 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).