Jay Kappy

Jay Kappy

  • NA
  • 4
  • 798

Deserialize JSON file into its parts.

Feb 23 2022 7:07 PM

I have a JSON file like seen below...
I need to read this into is parts....NOTING that I trucated this JSON file quite a bit to just show one record per section
 

  • I need to loop through the "bovaObj" Key and display all the records inside it. For instance there is one here "010033"
  • --------I need to eventual write this to a table but writing into individual rows in a text box would be fine
  • I then need to Read down into the "result"
  • --------WIthin the "Result" key will be 20 or so Keys....as seen below there are "BBA", "County", "HUC12"
  • --------I need to read all the records and fields into a table from each of these 3 Keys


Any thoughts how to read this deep and how to read the multiple Keys in the "result" indivudually?  I would want to read the data inside the "Data" subkey

{"results":[{"paramName":"Result","dataType":"GPString","value":{

    "bovaObj": {

        "010033": [

            161094,

            "Lepisosteus osseus",

            "Gar, longnose",

            999,

            999,

            999,

            999,

            "[123,223,999]"

        ],

    },

    "pythonFinish": "2022-02-23 10:02:42.934000",

    "pythonStart": "2022-02-23 10:02:14.877000",

    "result": {

        "BBA": {

            "data": [

                {

                    "AdminComments": null,

                    "BOVAJSON": "{\"040100\":[\"0\"],\"040248\":[\"0\"] }",

                    "BOVAList": [

                        "040100",

                        "040248"

                    ]

                }

            ],

            "objectIdField": "OBJECTID",

            "title": "BBA",

            "url": ""

        },

        "County": {

            "data": [

                {

                    "Acres": 373710.367767,

                    "Area_SqMi": 583.48797607,

                    "Area_meter": 1512302714.29,

                    "BOVAList": [

                        "010033"

                    ]

                }

            ],

            "objectIdField": "OBJECTID",

            "title": "County",

            "url": ""

        },

        "HUC12": {

            "data": [

                {

                    "AreaAcres": 24696.58894066,

                    "AreaSqKm": 99.94363792,

                    "BOVAList": [

                        "010131"

                    ]

                }