AnsweredAssumed Answered

New question on filtering using Query XML action

Question asked by ctoper11 on Jun 12, 2018
Latest reply on Jun 14, 2018 by emha

Hello. I had a similar question a couple of months ago. Basically I'm trying to pull a certain node's information based on another node. XML below so you can see what I'm referring to. 

 

<?xml version="1.0"?>

<TICKETS>

   <INCIDENT_NUMBER ID="INC12345678910">

       <CORPORATE_ID>USEID25</CORPORATE_ID>

       <FULLNAME>John Smith</FULLNAME>

       <DIVISION>I.T.</DIVISION>

  </INCIDENT_NUMBER>

</TICKETS>

 

Now based on the Corporate ID in the file I want to choose the Incident number so I can place that in a variable. 

 Using the below xpath I can do the reverse and pull the corporate ID. 

//INCIDENT_NUMBER[@ID='INC12345678910']/CORPORATE_ID

 

Since Incident_Number is the parent node I can't seem to figure out how to reverse that. Does anyone have any thoughts?

 

Thanks in advance.

Outcomes