Getting Data In

How to use spath command in props.conf or transforms.conf in Splunk?

MAMAOUI
Explorer

Hello ,

I used spath command to extract field from json data:

{"key":"value", "key":"value", "key":"value", "key":"value", "key":"value" ...}

and I got the results that I wanted (.. | spath input = json)

My question is how can I get the same results in props.conf or transforms.conf?

Thank you for answer

M&A

0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

Use INDEXED_EXTRACTIONS = JSON in props.conf.

---
If this reply helps you, Karma would be appreciated.

View solution in original post

richgalloway
SplunkTrust
SplunkTrust

Use INDEXED_EXTRACTIONS = JSON in props.conf.

---
If this reply helps you, Karma would be appreciated.

MAMAOUI
Explorer

I used KV_MODE=JSON and it works but my probleme is that i have 2 json
format in the same data :

{"key1":"value1", "key2":"value2", "key3": "{\"key30\":values30,\"key31\":values31........ \"}"}

I dont know if there are any way to use spath in props , some thig like
Eval-Key3=spath ....

Thankyou

0 Karma

MuS
Legend

Nope, that will not work. But you can use any kind of regex as transforms to get around this JSON in JSON problem. See this answer https://answers.splunk.com/answers/319646/how-to-write-the-regex-to-extract-data-inside-squa.html to learn how it can be done.

Additional hint: the regex mentioned in this answer will not work for your JSON in JSON thing ... try \\"([^\\]+)\\":([^,]+) for a start 😉

cheers, MuS

0 Karma

MAMAOUI
Explorer

ok I will try .thank you

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...