Splunk Search

How do I get arbitrary nested key-value pairs from JSON?

mldavis195
Explorer

I have some JSON that looks similar to this:

 

 

{
    "foo": "bar",
    "x": {
        "hello": "world",
        "y": {
            "A": 400,
            "B": 500,
            "C": 300
        }
    }
}
{
    "foo": "baz",
    "x": {
        "something": "test",
        "y": {
            "A": 100,
            "D": 200,
            "E": 600
        }
    }
}

 

 

 What I would like is to extract everything in x.y for a sum but the keys are dynamic and I won't know them all in advance:

A 500
B 500
C 300
D 200
E 600

 

I have been stuck on this one for a while. Can anyone help me?

Labels (1)
0 Karma
1 Solution

yuanliu
SplunkTrust
SplunkTrust

If that's your raw event, you would have fields like x.y.A, x.y.B, etc., already.  Just do

| stats sum(x.y.*) as *

If they are in an extracted field, say jsonfield, spath first.

| spath input=jsonfield
| stats sum(x.y.*) as *

View solution in original post

yuanliu
SplunkTrust
SplunkTrust

If that's your raw event, you would have fields like x.y.A, x.y.B, etc., already.  Just do

| stats sum(x.y.*) as *

If they are in an extracted field, say jsonfield, spath first.

| spath input=jsonfield
| stats sum(x.y.*) as *

mldavis195
Explorer

Thanks, seems so obvious after seeing your solution.

0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to July Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...

Updated Data Type Articles, Anniversary Celebrations, and More on Splunk Lantern

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

A Prelude to .conf25: Your Guide to Splunk University

Heading to Boston this September for .conf25? Get a jumpstart by arriving a few days early for Splunk ...