# Help To parse xml

**URL:** <https://discuss.elastic.co/t/help-to-parse-xml/53273>\
**Category:** Logstash\
**Created:** [June 20, 2016, 6:55am UTC](https://discuss.elastic.co/t/help-to-parse-xml/53273 "2016-06-20T06:55:20Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![hearvishwas](https://avatars.discourse-cdn.com/v4/letter/h/cc9497/32.png) [@hearvishwas](https://discuss.elastic.co/u/hearvishwas)\
**Post date:** [June 20, 2016, 6:55am UTC](https://discuss.elastic.co/t/help-to-parse-xml/53273/1 "2016-06-20T06:55:20Z")

</div>

Help required to parse xml:

\<L:RECORD\>\<L:EPOCH\>14618.806\</L:EPOCH\>\<L:DATE\>2016-04-25\</L:DATE\>\<L:TIME\>04:25:28.806\</L:TIME\>\<L:HOST\>[kjdasjhsajhkjahdk.com](http://kjdasjhsajhkjahdk.com)\</L:HOST\>\<L:IP\>10.23.232.32323\</L:IP\>\<L:SERVER\>managed\_server\</L:SERVER\>\<L:PORT\>1000\</L:PORT\>\<L:MESSAGEID\>ORESB\</L:MESSAGEID\>\<L:CATEGORY\>D\_EMLC\</L:CATEGORY\>\<L:SEVERITY\>INFO\</L:SEVERITY\>\<L:E2EDATA\>nHdr=PCK002069,E2E.busTxnType=rqRequestOrder,E2E.busProcOriginator=B2BOR,E2E.busTxnUsr=hwb2boe4,E2E.busTxnLoc=UNKNOWN,E2E.threadID.4=:3itsmbdxrt,E2E.threadID.3=APP10639:3itsmabodf:3itsmbdxrt,E2E.threadID.2=:3itsm9egcl,E2E.threadID.1=APP06611:3itsm9egcl:\</L:E2EDATA\>\<L:TEXT\>Debug : ONCE EMLC-CHECK-PC Response XML for keyword : PE27 5GF is : \<OutputParameters xmlns:xsi="[http://www.w3.org/2001/XMLSchema-instance](http://www.w3.org/2001/XMLSchema-instance)" xmlns="[http://xmlns.oracle.com/pcbpel/adapter/db/OPS-24ONCE/EMLC\_CHECK\_PC7/](http://xmlns.oracle.com/pcbpel/adapter/db/OPS-24ONCE/EMLC_CHECK_PC7/)"\>  
\<POV\_E2EDATA\>1=3itsmnisj6,10=3itsm9eget,11=REQ,13=EMLC\_CHECK\_PC,15=ORONCE,19=1.1.1.1,2=bcRequestOrderv22,3=bcRequestOrderv22 - FTTC Simultaneous provide\_2016-04-25T04:24:58\_609010363\_453A76AD-BC01-4C94-988F-6AC90A82E281,4=B2BOR,5=rqRequestOrder,6=PCK002069,7=B2BO\_rqRequestOr,8=UNKNOWN,9=hwb2boe4,tradingPartnerId=977777777,1.1=APP06611:3itsm9egcl:,1.2=:3itsm9egcl,1.3=APP10639:3itsmabodf:3itsmbdxrt,1.4=:3itsmbdxrt,1.5=ORSiebel:3itsmd5im0:3itsmn16bg,1.6=:3itsmn16bg,1.7=APP10639:3itsmn3nzq:3itsmnfjfg,1.8=APP10348:3itsmnisj6:\</POV\_E2EDATA\>  
\<POV\_OUTPCDE\>PE27\</POV\_OUTPCDE\>  
\<POV\_INPCDE\>5GF\</POV\_INPCDE\>  
\<POV\_DISTRICTID1\>SS\</POV\_DISTRICTID1\>  
\<POV\_EXCHCODE1\>STIVE\</POV\_EXCHCODE1\>  
\<POV\_EXCHNAME1\>STIVE\</POV\_EXCHNAME1\>  
\<POV\_DISTRICTID2\>SS\</POV\_DISTRICTID2\>  
\<POV\_EXCHCODE2\>STIVE\</POV\_EXCHCODE2\>  
\<POV\_EXCHNAME2\>STIVE\</POV\_EXCHNAME2\>  
\<PON\_DPLINELENGTH xsi:nil="true"/\>  
\<PON\_AGGCIRCLINELENGTH\>3938\</PON\_AGGCIRCLINELENGTH\>  
\<PON\_AGGCAPACITANCE xsi:nil="true"/\>  
\<PON\_AGGCELLOSS xsi:nil="true"/\>  
\<PON\_AGGLLCLOSS xsi:nil="true"/\>  
\<PON\_AGGCIRCLINELENGTHCAL xsi:nil="true"/\>  
\<POV\_BESTCASEDNSTREAMBW\>40.00\</POV\_BESTCASEDNSTREAMBW\>  
\<POV\_BESTCASEUPSTREAMBW\>2.00\</POV\_BESTCASEUPSTREAMBW\>  
\<POV\_BESTREASONCODE\>L\</POV\_BESTREASONCODE\>  
\<POV\_WORSTCASEDNSTREAMBW\>40.00\</POV\_WORSTCASEDNSTREAMBW\>  
\<POV\_WORSTCASEUPSTREAMBW\>2.00\</POV\_WORSTCASEUPSTREAMBW\>  
\<POV\_WORSTREASONCODE\>L\</POV\_WORSTREASONCODE\>  
\<PON\_FTTC\_COVERAGE\>30\</PON\_FTTC\_COVERAGE\>  
\<POV\_FTTC\_RFS\_DATE xsi:nil="true"/\>  
\<PON\_FTTP\_COVERAGE\>70\</PON\_FTTP\_COVERAGE\>  
\<POV\_FTTP\_RFS\_DATE xsi:nil="true"/\>  
\<PON\_SOGEA\_COVERAGE\>0\</PON\_SOGEA\_COVERAGE\>  
\<POV\_SOGEA\_RFS\_DATE xsi:nil="true"/\>  
\<POV\_MONTHLY\_UPDATE\_DATE xsi:nil="true"/\>  
\</OutputParameters\>  
\</L:TEXT\>\<L:API\_VER\>BPTM Java API v3.3.9.3\</L:API\_VER\>\<L:LOCATION\>nsd,and,sad,msand basdkjsadjsj sdfjhdskjfhdskjf\</L:LOCATION\>\<L:TIER\>sadaaadada12323\</L:TIER\>\<L:RECORD\_VER\>3.1\</L:RECORD\_VER\>\</L:RECORD\>

I have a log file which contains many of such xmls.  
I want to store this xml as key value pair like so that in kibana I can query them like fetch all result withn a particular L:DATE.  
Please help how to achieve this.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 4:51am UTC](https://discuss.elastic.co/t/help-to-parse-xml/53273/2 "2017-07-06T04:51:56Z")

</div>