Decoding JSON

[ROBBshop 2]

Hi everyone,

I am trying to pull a few values out of a json response from another source. I already found many examples but they don't seem to work for me.

The LUA script so far:

Please login or register to see this code.

I want to pull 3 values marked in bold. I know it should become somthing like this, but not sure how exact:

current_usage = response.body[1].states[2].value[4] (or am I completely wrong here??)

current_total = response.body[1].states[2].value[??]

current_gas = response.body[1].states[2].value[??]

The unsorted json response:

Please login or register to see this code.

Any help is welcome

[dynek 0]

I haven't played yet with JSON on HC2 so this might not work but it looks to me like what you want is:

# Watts

current_usage = response.body[1].Device_Num_77.states[0].value

# KWH

current_total = response.body[1].Device_Num_77.states[2].value

# GAS

current_gas = response.body[1].Device_Num_77.states[3].value

Hope it's correct

Please login or register to see this image.

/emoticons/default_icon_smile.gif" alt=":-)" />

[ROBBshop 2]

Unfortunatly does not seem to work. Is there a way to debug a bit more which actual value this is pulling?

[dynek 0]

Maybe this helps:

Please login or register to see this link.

Pass it the body and see what comes out.

[ROBBshop 2]

errrrr, paste this into my HC2? Or how do I parse the body there?

[dynek 0]

I moved bold tags inside the quotes to have a working JSON bit.

Then here:

Please login or register to see this link.

Proves I should be right

Please login or register to see this image.

/emoticons/default_icon_smile.gif" alt=":-)" />

Please login or register to see this attachment.

[ROBBshop 2]

Ok, So apart from my attempt to make a bold number (hence the code) the problem may be that it is in quotes when trying to write it to a variable....

Guess more stripping required then

[ Added: 2014-01-14, 15:14 ]

but with or without body?

current_usage = response.body[1].Device_Num_77.states[0].value;

or

current_usage = response.Device_Num_77.states[0].value;

Please login or register to see this code.

does not write the any value

[dynek 0]

fibaro:debug(response.body[1].Device_Num_77.states[0].value)

fibaro:debug(response.body.Device_Num_77.states[0].value)

fibaro:debug(response.Device_Num_77.states[0].value)

Try them all

Please login or register to see this image.

/emoticons/default_icon_smile.gif" alt=":-)" />

[ROBBshop 2]

First 2 attempts:

[ERROR] 15:32:14: line 6: attempt to index field 'body' (a nil value)

Last attempt:

[ERROR] 15:34:08: line 7: attempt to index field '?' (a nil value)

So still a no joy

Please login or register to see this image.

/emoticons/default_sad.png" alt=":(" srcset="https://forum.fibaro.com/uploads/emoticons/[email protected] 2x" width="20" height="20" />

[ Added: 2014-01-14, 16:35 ]

So, I created a virtual device and assigned 1 button. In this button I programmed this LUA:

Please login or register to see this code.

Unfortunatly there is no debug option in here and it does not change the number in the variable panel. If I use another value:

Please login or register to see this code.

It correctly updates the value to 1.

Not sure where the difference is .......

[dynek 0]

Maybe the index starts from 1, then:

fibaro:debug(response.Device_Num_77.states[1].value)

[ROBBshop 2]

Maybe the index starts from 1, then:

fibaro:debug(response.Device_Num_77.states[1].value)

BINGO!!!!!!!!!!!!!

Thank a gazillion!!!!!

[dynek 0]

My pleasure

Please login or register to see this image.

/emoticons/default_icon_smile.gif" alt=":-)" />

[ROBBshop 2]

Now that I have it working (sort of) I want to clean up my code so that I can share it to others and have them easily customize it.

The original code:

Please login or register to see this code.

The goal:

Please login or register to see this code.

Most of it actually does work, except the pasring of the JSON_WATTS/JSON _GAS bits.