Splunk Enterprise

Parse JSON only at 1st level

nagar57
Communicator

I want my nested JSON to be parsed only at 1st level instead of parsing all the nested parts. I have below JSON:

{ "Name":Naman, 
"Age":25, 
"Address": 
    { "H.No":"23", 
      "Street_no":2, 
      "Area":"Model Town" },
"Country":"IND" 
}

 I want output like below:

Name | Age  | Address             | Country 
Naman  25     "H.No":"23",           IND  
              "Street_no":2,
              "Area":"Model Town"

I don't want to handle Address field separately as these are dynamic fields that are coming in from source.

Tags (3)
0 Karma

thambisetty
SplunkTrust
SplunkTrust

share _raw json otherwise regex may break.

————————————
If this helps, give a like below.
0 Karma

nagar57
Communicator

I can't paste the raw JSON as it contains company data. I hope you get the idea what I am trying to achieve. JSON is dynamic and I just want to parse at 1st level. All the nested fields should come as it is without getting parsed.

0 Karma
Get Updates on the Splunk Community!

Splunk Mobile: Your Brand-New Home Screen

Meet Your New Mobile Hub  Hello Splunk Community!  Staying connected to your data—no matter where you are—is ...

Introducing Value Insights (Beta): Understand the Business Impact your organization ...

Real progress on your strategic priorities starts with knowing the business outcomes your teams are delivering ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...