problem getting json value

[menno]

Hi support

I am builing a test that gets the info from a json reply

The http request result in this output

http get command gives :

Code: Select all

{"code":0,"msg":"success","time":"1683896070","data":{"degrees":{"celsius":{"time":"1683892112","unit":"","value":"6"}}}}

readable output is:

Code: Select all

 {
    "code":0,
    "msg":"success",
    "time":"1683892176",
    "data":
    {
        "degrees":
        {
            "celsius":
            {
                "time":"1683892112",
                "unit":"",
                "value":"6"
            }
        }
    }
 }

i am interessted only in the "value":"6" line and then in this case / example the 6
We just want to check is the value is not below 1 and not higher as 10

i tried to use this help but i did not manage to get it working
https://www.ks-soft.net/cgi-bin/phpBB/v ... light=json

i played with the Tune up reply value but didn't succeed.
i tried : [('%data%' getword 1 == 'value') and ('%data%' getnumber 1 >= 9)]

I hope you can help me out here.
many thanks in advance

m

Code: Select all

[KS-Soft]

1) HostMonitor version?
2) Test method? URL?

3) Where did you find %data% variable?
There is %HttpPage% variable, %SuggestedReply% variable.

{"code":0,"msg":"success","time":"1683896070","data":{"degrees":{"celsius":{"time":"1683892112","unit":"","value":"6"}}}}
i am interessted only in the "value":"6" line and then in this case / example the 6
[('%data%' getword 1 == 'value') and ('%data%' getnumber 1 >= 9)]

4) There are no spaces, no CR, LF characters in this JSON string so entire string looks to "getword" operator as just 1 word

5) getnumber may help. But why did you set "getnumber 1"? I though you want to get 4th number, not first.

So if you want to set Warning or Normal test status you may try expression like
("%HttpPage%" getnumber 4 > 0) and ("%HttpPage%" getnumber 4 < 11)

i played with the Tune up reply value but didn't succeed.
i tried : [('%data%' getword 1 == 'value') and ('%data%' getnumber 1 >= 9)]

I am confised. If you want to check value, then you want to do something depending on the value, right? Then I should ask why do you use this expression in TuneUpReply option?
Either you should use different expression and set some reply... or you should use different options like "Set Warning status if ...".

Regards
Alex

[menno]

Thx Alex !
for your info :
-HM version 13.50
-Test method : URL test ( also tried HTTP )

The solution you provided is good enough so i will use that.

Again many Thanks
m

[KS-Soft]

You are welcome

Regards
Alex