JSONPATH with http binding

Setup, Configuration and Use Beginners
1

Good afternoon

Trying to get a value from a JSON returned by one of my servers which is like:

[
    {
        "dow": 7,
        "today": "  271.70",
    }
]

The http binding is set up correctly as I verified on my server backend that the supplied header sent is correct…
Also with jsonpath.com I checked the expression I need to put in my items config:

$[0].today

But still I see the returned value in the UI as “UNDEF”…

Any hints what could be done wrong here?

thanks in advance
richard

2

With the JSON string you’ve quoted, I get JSON Parse Error at https://jsonpath.com/ for $[0].today…

The JSON string is invalid. The trailing comma breaks it - you can try it yourself here: https://jsonlint.com/.

This would be valid:

[
    {
        "dow": 7,
        "today": "  271.70"
    }
]

And can be parsed with $..today or $[0].today

3

Did the value get updated in the meanwhile?
I know I am guilty of this… I expect to get a value immediately.

4

Okay…I shortened the JSON above so I didn’t remove the last , (o;

Seems I declared the channel in first place wrong as number instead of string…so no way it could decode it (o;