XPath/XSLT generation

Question

How can i get the cust_account_id value and the party_id value from this xml? (see ** portions) Thank you .

Essentially i want the xpath/xslt to drill down and find where cust_account_id is the name and for where it is the name pull out the value

<soap-env:Body xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/">[[
      <WF_EVENT_T xmlns="http://xmlns.oracle.com/xdb/APPS_NE/EBSCustomerService">
        <PRIORITY xmlns="">50</PRIORITY>
        <SEND_DATE xmlns="">2017-05-02T12:14:28.000-04:00</SEND_DATE>
        <RECEIVE_DATE xsi:nil="true" xmlns="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
        <CORRELATION_ID xsi:nil="true" xmlns="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
        <PARAMETER_LIST xmlns="">
          <PARAMETER_LIST_ITEM>
            <NAME>USER_ID</NAME>
            <VALUE>1569</VALUE>
          </PARAMETER_LIST_ITEM>
          <PARAMETER_LIST_ITEM>
            <NAME>RESP_ID</NAME>
            <VALUE>20678</VALUE>
          </PARAMETER_LIST_ITEM>
          <PARAMETER_LIST_ITEM>
            <NAME>RESP_APPL_ID</NAME>
            <VALUE>222</VALUE>
          </PARAMETER_LIST_ITEM>
          <PARAMETER_LIST_ITEM>
            <NAME>SECURITY_GROUP_ID</NAME>
            <VALUE>0</VALUE>
          </PARAMETER_LIST_ITEM>
          **<PARAMETER_LIST_ITEM>
            <NAME>CUST_ACCOUNT_ID</NAME>
            <VALUE>6049</VALUE>
          </PARAMETER_LIST_ITEM>**
          **<PARAMETER_LIST_ITEM>
            <NAME>PARTY_ID</NAME>
            <VALUE>34842</VALUE>
          </PARAMETER_LIST_ITEM>**
          <PARAMETER_LIST_ITEM>
            <NAME>CUST_ACCOUNT_PROFILE_ID</NAME>
            <VALUE xsi:nil="true" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
          </PARAMETER_LIST_ITEM>
          <PARAMETER_LIST_ITEM>
            <NAME>P_CREATE_PROFILE_AMT</NAME>
            <VALUE>T</VALUE>
          </PARAMETER_LIST_ITEM>
        </PARAMETER_LIST>
        <EVENT_NAME xmlns="">oracle.apps.ar.hz.CustAccount.create</EVENT_NAME>
        <EVENT_KEY xmlns="">oracle.apps.ar.hz.CustAccount.create55259</EVENT_KEY>
        <EVENT_DATA xmlns=""/>
        <FROM_AGENT xmlns="">
          <NAME>WF_BPEL_QAGENT</NAME>
          <SYSTEM>EBSDEV.CLI.AD</SYSTEM>
        </FROM_AGENT>
        <TO_AGENT xsi:nil="true" xmlns="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
        <ERROR_SUBSCRIPTION xsi:nil="true" xmlns="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
        <ERROR_MESSAGE xsi:nil="true" xmlns="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
        <ERROR_STACK xsi:nil="true" xmlns="" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
    </WF_EVENT_T>
    </soap-env:Body>

Michael Kay · Accepted Answer · 2017-05-02 17:50:39Z

1

Very simple:

select="//PARAMETER_LIST_ITEM[NAME='CUST_ACCOUNT_ID']/VALUE

answered May 2, 2017 at 17:50

Michael Kay

165k11 gold badges97 silver badges173 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

XPath/XSLT generation

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related