topic Re: Query with xpath in Splunk Search

Query with xpath

ahogbin — Tue, 29 Sep 2020 10:46:59 GMT

I am slowly progressing on a report but I am stuck on trying to extract some values from xml.

The values I am trying to get are contained within
<_0:Organisation key="INTERMEDIARY_ORG_001">
<_0:MailingAddress addressReference="INTERMEDIARY_ADDRESS_001"/>
<_0:OrganisationName>
<_0:TypeCode>CommonName</_0:TypeCode>
<_0:FullName>Text Values example 1</_0:FullName>
</_0:OrganisationName>
</_0:Organisation>
<_0:Organisation key="INSURED_ORG_001">
<_0:MailingAddress addressReference="INSURED_ADDRESS_001"/>
<_0:AustralianTaxInformation>
<_0:GSTRegistered>false</_0:GSTRegistered>
</_0:AustralianTaxInformation>
<_0:OrganisationName>
<_0:TypeCode>CommonName</_0:TypeCode>
<_0:FullName>Text value item 2</_0:FullName>
</_0:OrganisationName>
<_0:OrganisationName>
<_0:TypeCode>TradingName</_0:TypeCode>
<_0:FullName>Text value item 2</_0:FullName>
</_0:OrganisationName>
</_0:Organisation>

The values I am trying to get are Text Values example 1 and Text value item 2 (the second string appears twice but I am happy with either.

I am using xpath command

Somesearch stuff | xpath outfield=test1 "//[local-name()='Organisation' and *[local-name()='TypeCode']]/[local-name()='FullName']" | table test1

But not getting any results. I think the issue is to do with the fact that TypeCode is no unique but I am not sure how you can/could include the CommonName / TradingName as a key.

Help would greatly appreciated.

Thanks as always

Re: Query with xpath

vasanthmss — Tue, 30 Aug 2016 15:12:32 GMT

post the full xml.

Re: Query with xpath

ahogbin — Wed, 31 Aug 2016 01:51:35 GMT

I cant I am sorry as it contains confidential information.
The section of concern is as above and the text that I am trying to extract is contained in no other section that that above.

For some reason the escaping XML is being removed.. will try to past again

<_0:Organisation key="INTERMEDIARY_ORG_001">
        <_0:MailingAddress addressReference="INTERMEDIARY_ADDRESS_001"/>
        <_0:OrganisationName>
          <_0:TypeCode>CommonName</_0:TypeCode>
          <_0:FullName>GARATY MURNANE - SME TRANSFER</_0:FullName>
        </_0:OrganisationName>
      </_0:Organisation>
      <_0:Organisation key="INSURED_ORG_001">
        <_0:MailingAddress addressReference="INSURED_ADDRESS_001"/>
        <_0:AustralianTaxInformation>
          <_0:GSTRegistered>false</_0:GSTRegistered>
        </_0:AustralianTaxInformation>
        <_0:OrganisationName>
          <_0:TypeCode>CommonName</_0:TypeCode>
          <_0:FullName>CDA Investments Pty Ltd</_0:FullName>
        </_0:OrganisationName>
        <_0:OrganisationName>
          <_0:TypeCode>TradingName</_0:TypeCode>
          <_0:FullName>CDA Investments Pty Ltd</_0:FullName>
        </_0:OrganisationName>
      </_0:Organisation>

I can use xpath with out issues to extract other sections of the xml it is just the above giving me grief as there is no unique key for each section.

Cheers

Alastair

Re: Query with xpath

inventsekar — Wed, 31 Aug 2016 06:31:18 GMT

please check this -

Somesearch stuff | xpath outfield=test1 "//[local-name()='Organisation']/*[local-name()='FullName']" | table test1

maybe, rex would do it -

Somesearch stuff | rex field=_raw "FullName\>"(?<fullnamerex>\w+[^\<])" | dedup fullnamerex | table test1