Splunk Search

How to extract data of JSON in one row?

jhonatancuartas
New Member

I have this JSON, and I want extrac the value when the name is "ca-channel" and value when name is "Ca-Request-Id" but this data in one row, for example:

channel   |        requestId
    w          |       000001707ce0ca4c-58e1e56

alt text

0 Karma

maityayan1996
Path Finder

At first you just extract the fields from the json format of logs. Then try to filter the portions .
Please follow link to extract the fields :
https://answers.splunk.com/answers/679950/how-to-extract-fields-if-the-event-is-in-json-form.html

0 Karma

to4kawa
Ultra Champion
0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

.conf25 Global Broadcast: Don’t Miss a Moment

Hello Splunkers, .conf25 is only a click away.  Not able to make it to .conf25 in person? No worries, you can ...

Observe and Secure All Apps with Splunk

 Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

What's New in Splunk Observability - August 2025

What's New We are excited to announce the latest enhancements to Splunk Observability Cloud as well as what is ...