Nested JSON help!!!

[Jaap 0]

Hi all!

 

My solar-device  has a json.file, but I am not able to read out certain values. For example, I want to obtain the value of "wNow" in the table "Production".

I know how to use "standard"-json-files, but this one I don't know. Maybe caused by the [ and ] ?

I hope there's someone to help me out!! It would really be appreciated!!

 

Below the json-file, I edited a little bit for readability only, the characters are 

 

Thanks!!

 

-------------------------------------------------------------------------

JSON-file:

 

 

{

"production":
    [

    {
    "type":    "inverters",
    "activeCount":4,
    "readingTime":1535205784,
    "wNow":95,
    "whLifetime":7508
    },

    {
    "type":"eim",
    "activeCount":1,
    "measurementType":"production",
    "readingTime":1535205880,
    "wNow":-1.868,
    "whLifetime":0.0,
    "varhLeadLifetime":0.064,
    "varhLagLifetime":9.769,
    "vahLifetime":4479.172,
    "rmsCurrent":0.129,
    "rmsVoltage":236.277,
    "reactPwr":-0.0,
    "apprntPwr":30.417,
    "pwrFactor":-0.17,
    "whToday":0.0,
    "whLastSevenDays":0.0,
    "vahToday":488.172,
    "varhLeadToday":0.064,
    "varhLagToday":1.769

    }

    ],

 

 

"consumption" :
    [

    {
    "type":"eim",
    "activeCount":1,
    "measurementType":"total-consumption",
    "readingTime":1535205880,
    "wNow":43.254,
    "whLifetime":70977.932,
    "varhLeadLifetime":97421.722,
    "varhLagLifetime":2149.543,
    "vahLifetime":150664.803,
    "rmsCurrent":2.048,
    "rmsVoltage":236.26,
    "reactPwr":-403.005,
    "apprntPwr":483.897,
    "pwrFactor":0.09,
    "whToday":2168.932,
    "whLastSevenDays":32076.932,
    "vahToday":9835.803,
    "varhLeadToday":5817.722,
    "varhLagToday":432.543
    },

 

    {
    "type":"eim",
    "activeCount":1,
    "measurementType":"net-consumption",
    "readingTime":1535205880,
    "wNow":45.122,
    "whLifetime":75066.155,
    "varhLeadLifetime":97421.658,
    "varhLagLifetime":2139.774,
    "vahLifetime":150664.803,
    "rmsCurrent":1.919,
    "rmsVoltage":236.243,
    "reactPwr":-403.005,
    "apprntPwr":453.806,
    "pwrFactor":0.1,
    "whToday":0,
    "whLastSevenDays":0,
    "vahToday":0,
    "varhLeadToday":0,
    "varhLagToday":0
    }
    ],

 

"storage":
    [

    {
    "type":"acb",
    "activeCount":0,
    "readingTime":0,
    "wNow":0,
    "whNow":0,
    "state":"idle"
    }

    ]

 

    }

[cag014 731]

Looks like standard JSON table. Production section has two elements.

please try jsonfile.production[1].wNow

Edited August 25, 2018 by cag014

[Jaap 0]

Woooow!!!!

Thanks a lot dude!!!

It works!