[SOLVED] Use jsonPath in JavaScript transformation?

Setup, Configuration and Use Beginners
10

So the answer is: jsonPath isn’t possible there :slight_smile:

Thanks for writing the code, it works for me too!

I stripped it down a little bit, this is the version I now use:

(function(dataString) {
    var data = JSON.parse(dataString);
    var value = 'UNDEF';
    for (var i = 0; i < data.length; i++) {
        if (data[i].id == '6') {
            value = data[i].value;
            break;
        }
    }
    if (value != 'UNDEF') {
        if (value == '0.00') {
            value = 'OFF';
        } else {
            value = 'ON';
        }
    }
    return value;
})(input)