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 Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI!Discover how Splunk’s agentic AI ...

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

Watch On Demand the Tech Talk, and empower your SOC to reach new heights! Duration: 1 hour  Prepare to ...

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...