Sidebar

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

0 votes
335 views
asked Mar 16, 2021 by michael-h-5027 (14,390 points)
{
  "KEY1": "ABC",
  "KEY2": "01",
  "KEY3": "2021-03-15",
  "KEY4": "My String",
  "KEY5": true,
  "KEY6": "No",
  "KEY7": 12345,
  "BENSOBJECT": {
    "KEY1": "VALUE"
  }
}

1 Answer

+1 vote
 
Best answer

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

...

answered Mar 16, 2021 by michael-h-5027 (14,390 points)
selected Mar 17, 2021 by brandon-w-8204
...