Deserialize JSON file into its parts.

[jaykappy]

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" 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?

{"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"

                    ]

                }

 

[Skydiver]

See LINQ to JSON using Json.NET:

Querying JSON with LINQ

www.newtonsoft.com

Or JSON Path using Json.NET:

Querying JSON with SelectToken

www.newtonsoft.com

 

[jaykappy]

I am new to this and sort of understand the querying JSON with LINQ but still not sure how to get all the way down to say "BBA"

Very new to this and not sure how to get all the way down to 'BBA' and data:[

I think I have to walk this entire path?: Results > value > result > BBA > data

{"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"
                    ]
                }
            ],