I need to print a string array along with one field in my json object.
The data:
{ "key1":"val1", "key2":"value2", "codes":["apple","mango","banana","orange"], "key3_conditional":"yes"}
My Search query:
<My search query>
| rex "\|(?<payload>[^\|]*)$"
| spath input=payload
| rex "\"codes\":\"(?<codes>[^\"]*)"
| eval is_unknown=if(isnotnull(key3_conditional), key3_conditional, "no")
| table codes, is_unknown
This only displays the 1st value in codes and I need all values of codes as comma separated.
| makeresults | eval _raw="{ \"key1\":\"val1\", \"key2\":\"value2\", \"codes\":[\"apple\",\"mango\",\"banana\",\"orange\"], \"key3_conditional\":\"yes\"}"
| spath path=codes{} output=codes
| spath path=key3_conditional
| table codes key3_conditional