[SOLVED] Use jsonPath in JavaScript transformation?

Setup, Configuration and Use Beginners
9

Try this one:

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

Tested for:
id=6 - OFF
id=14 - ON
id=42 - UNDEF

1 Like