Splunk Search

Print string arrays in json in tabular format

ayushk23
Loves-to-Learn

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.

 

 

Labels (2)
Tags (2)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| 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
0 Karma
Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...