AnsweredAssumed Answered

Parsing XML return for Properties

Question asked by GregBunce on Jul 24, 2015
Latest reply on Jul 30, 2015 by camja06

I am trying to parse the return of a getRelatedListValues that returns the Properties for a request. I get the XML below from the query and I tried using applyXPath as follows:

 

Process.getPropertiesResult = applyXPath(Process[OpName].SoapResponseData.getRelatedListValuesResult[0].text_, "//Attribute[AttrName='value']/AttrValue/text()")

 

Unfortunately, this results in a single string with ALL the 'value' results contained in that one string, i.e. "GeneralUseJim BeacherNo"...etc.

Do I need to store this result in an array? How do I get each 'value' return in it's own variable?

 

 

<?xml version="1.0" encoding="UTF-8"?>

<UDSObjectList>

<UDSObject>

<Handle>cr_prp:401551</Handle>

<Attributes>

<Attribute DataType="2002">

<AttrName>value</AttrName>

<AttrValue>General Use</AttrValue>

</Attribute>

</Attributes>

</UDSObject>

<UDSObject>

<Handle>cr_prp:401552</Handle>

<Attributes>

<Attribute DataType="2002">

<AttrName>value</AttrName>

<AttrValue>Jim Beacher</AttrValue>

</Attribute>

</Attributes>

</UDSObject>

<UDSObject>

<Handle>cr_prp:401553</Handle>

<Attributes>

<Attribute DataType="2002">

<AttrName>value</AttrName>

<AttrValue>No</AttrValue>

</Attribute>

</Attributes>

</UDSObject>

<UDSObject>

Outcomes