Dashboards & Visualizations

parse XML embedded in a field

moneybox
Explorer

Hi there,

I have a CSV file with 2 fields : time,xml_data.
Is there anyway I can parse the xml_data field as XML ?

This is a nested XML inside a CSV field and I would prefer to parse it on index time (if not, parsing on search time is also acceptable).

Thanks

nickhills
Ultra Champion

I have a CSV file with 2 fields : time,xml_data

As long as you know the name of the field in the CSV which contains the XML spath will work at seach time

<your search which includes your csv events>| spath xml_data
If my comment helps, please give it a thumbs up!
0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

Hi @moneybox,

You can use spath for same. Check below search.

|inputlookup mylookup
| eval _raw=XML_DATA_FIELD 
| spath output=.. path=..
| table ..

Please check my sample search from below doc

https://docs.splunk.com/Documentation/SplunkCloud/6.6.3/SearchReference/Spath

| makeresults 
| eval A="<?xml version=\"1.0\">
<purchases>
   <book>
         <author>Martin, George R.R.</author>
         <title yearPublished=1996>A Game of Thrones</title>
         <title yearPublished=1998>A Clash of Kings</title>
  </book>
   <book>
         <author>Clarke, Susanna</author>
         <title yearPublished=2004>Jonathan Strange and Mr. Norrell</title>
   </book>
   <book>
         <author>Kay, Guy Gavriel</author>
         <title yearPublished=1990>Tigana</title>
   </book>
   <book>
         <author>Bujold, Lois McMasters</author>
         <title yearPublished=1986>The Warrior's Apprentice</title>
   </book>
</purchases>" 
| eval _raw=A 
| spath output=dates path=purchases.book.title{@yearPublished} 
| table dates

Thanks

0 Karma

moneybox
Explorer

Thank you, but that works for cases I know what fields should I expect.
Is there anything that could automatically convert the nested XML to searchable fields in Index Time ?
Meaning, I want to extract all fields from the nested XML without knowing them.

Thanks again

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 ...