How can I get a list of all of the Keys and Values in a JSON message?

Question

{
  "KEY1": "ABC",
  "KEY2": "01",
  "KEY3": "2021-03-15",
  "KEY4": "My String",
  "KEY5": true,
  "KEY6": "No",
  "KEY7": 12345,
  "BENSOBJECT": {
    "KEY1": "VALUE"
  }
}

Answer 1

You can loop through each key/value pair with something like this:

var keys = message.getJSONKeys('/');
for (var i = 0 ; i < keys.length; i++) {
   qie.debug('KeyName: ' + keys[i] + '\nKeyValue: ' + message.getNode('/' + keys[i]));
}

That will result in debug that looks like this:

KeyName: KEY1
KeyValue: ABC

KeyName: KEY2
KeyValue: 01

KeyName: KEY3
KeyValue: 2021-03-15

...