All Apps and Add-ons

SPL or sourcetype to parse json data without standard key value data?

joxers25
Explorer

Hi Folks,

Looking for someone to suggest how to extract the data from the below json api return in the following format?

queries are sent in the api call, structured data is returned but without the key.

servername:"id.server",
type:"TXT",
error"NOERROR",

{
    "result": {
        "rows": 2001,
        "data": [
            {
                "dimensions": [
                    "id.server",
                    "TXT",
                    "NOERROR",
            }
    ]
    }
}

Thanks!

Labels (1)
0 Karma
Get Updates on the Splunk Community!

Say goodbye to manually analyzing phishing and malware threats with Splunk Attack ...

In today’s evolving threat landscape, we understand you’re constantly bombarded with phishing and malware ...

AppDynamics is now part of Splunk Ideas

Hello Splunkers, We have exciting news for you! AppDynamics has been added to the Splunk Ideas Portal. Which ...

Advanced Splunk Data Management Strategies

Join us on Wednesday, May 14, 2025, at 11 AM PDT / 2 PM EDT for an exclusive Tech Talk that delves into ...