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