How to get the value in this JSON respons?

[SDeath 68]

Hi all,

 

I am trying to get the last value in the following JSON response:

Please login or register to see this code.

So I am looking to get the 962 value.

This is a collection of timestamps and power metering values from my Flukso, 962 is 962 Watts being used in my home measured using a s0 kWh meter.
I have two, one for my total house consumption and one for my solar panels. The Flukso counts these and can make graphs and keeps historic values.
Ideally I'd like the power panel to use this value as it's input, but it doesn't look that will happen anytime soon.
I tried the following in a VD to get the value, the xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx is the number the sensor is known in the Flukso, I removed it for privacy purposes:

Please login or register to see this code.

But I am stuck and doing something wrong but I can't see what, the error I get is in the json.decode line and this is the error:

Please login or register to see this code.

Thanks in advance for your help.

 

[petergebruers 1,268]

Is that the exact string that you want to parse? That's not JSON encoded... See

Please login or register to see this link.

You'll have to find a different way to parse that. Probably by using string.match, see

Please login or register to see this link.

I might be able to do that, but my wife forbids me to write parsers during holidays!

Please login or register to see this image.

/emoticons/default_icon_wink.gif" alt=";-)" />

[SDeath 68]

Hi Peter,

 

Yes that is the exact string I want to parse and it is being "sold" as a JSON response: "response: a JSON array containing [unix timestamp, value] array elements".
But I figured it wasn't exactly as it didn't work and the JSON decode expected something else.
 

And I can totally understand your wife. =-)

I'll start trying something else myself.

 

Happy Holidays!

[SDeath 68]

Fixed it but you pointed me in the right direction, although I didn't use string match, but just with some string trimming and reversing I was able to get the values I need.

Thanks!