https://community.splunk.com/t5/Splunk-Search/How-can-I-extract-all-fields-and-values-from-a-json-result/m-p/141884#M39323 <P>| spath input=payloads</P> <P>I've found the solution. Tks to me </P> Thu, 23 Jul 2015 14:59:57 GMT efrenette11 2015-07-23T14:59:57Z https://community.splunk.com/t5/Splunk-Search/How-can-I-extract-all-fields-and-values-from-a-json-result/m-p/141883#M39322 <P>Here's an example of the result that I have and I want to extract all fields. I know spath, but I don't want to name all fields.</P> <PRE><CODE>source="/app/local/springboot/logs/payload/jms/jms-payload.log"| rex "topic://VirtualTopic.event: (?&lt;payloads&gt;.*)..logger=*" | table payloads </CODE></PRE> <P>Tks.</P> <PRE><CODE>{"common":{"id":{"tmclassic-us":{"id":"14004EF77FBE0C65"}},"name":{"es-us":"La Subasta","en-au":"La Subasta","es-mx":"La Subasta","fr-ca":"La Subasta","en-nz":"La Subasta","en-ca":"La Subasta","en-us":"La Subasta","en-mx":"La Subasta"},"publicVisibility":{"startDateTime":"1997-03-26T06:00:00.000Z","dateTBD":false},"isTest":false},"dates":{"start":{"localDate":"2015-08-15","localTime":"20:00:00","dateTime":"2015-08-16T01:00:00.000Z","dateTBD":false,"dateTBA":false,"timeTBA":false,"noSpecificTime":false},"timezone":"America/Mexico_City","displayOptions":{"displayMultipleDates":false},"scheduleChange":{}},"venue":{"id":{"tmonline-us":{"id":"164127"}}},"classification":{"browseCategory":{"major":{"id":{"tmonline-us":{"id":"10002"}}},"minor":{"id":{"tmonline-us":{"id":"32"}}}}},"sales":{"public":{"startTBD":true,"endDateTime":"2015-08-15T23:00:00.000Z"}}} </CODE></PRE> Thu, 23 Jul 2015 14:26:02 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-extract-all-fields-and-values-from-a-json-result/m-p/141883#M39322 efrenette11 2015-07-23T14:26:02Z https://community.splunk.com/t5/Splunk-Search/How-can-I-extract-all-fields-and-values-from-a-json-result/m-p/141884#M39323 <P>| spath input=payloads</P> <P>I've found the solution. Tks to me </P> Thu, 23 Jul 2015 14:59:57 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-extract-all-fields-and-values-from-a-json-result/m-p/141884#M39323 efrenette11 2015-07-23T14:59:57Z