Splunk Enterprise

Parse JSON only at 1st level


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, 
    { "H.No":"23", 
      "Area":"Model Town" },

 I want output like below:

Name | Age  | Address             | Country 
Naman  25     "H.No":"23",           IND  
              "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


share _raw json otherwise regex may break.

If this helps, give a like below.
0 Karma


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!

Infographic provides the TL;DR for the 2023 Splunk Career Impact Report

We’ve been shouting it from the rooftops! The findings from the 2023 Splunk Career Impact Report showing that ...

Splunk Lantern | Getting Started with Edge Processor, Machine Learning Toolkit ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...

Enterprise Security Content Update (ESCU) | New Releases

In the last month, the Splunk Threat Research Team (STRT) has had 2 releases of new security content via the ...