Simple xml question

FinalBuilder Discussion
1

Hello,

I have not much/no experiences with XML. I am try to read the following XML file:

- <xml xmlns:s=“uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882” xmlns:dt=“uuid:C2F41010-65B3-11d1-A29F-00AA00C14882” xmlns:rs=“urn:schemas-microsoft-com:rowset” xmlns:z="#RowsetSchema">
+ <s:Schema id=“RowsetSchema”>
- <s:ElementType name=“row” content=“eltOnly”>
- <s:AttributeType name=“c0” rs:name=“MAX(DEVELOPMENT_ID)” rs:number=“1” rs:nullable=“true”>
<s:datatype dt:type=“number” rs:dbtype=“varnumeric” dt:maxLength=“20” rs:scale=“0” rs:precision=“38” />
s:AttributeType>
<s:extends type=“rs:rowbase” />
s:ElementType>
s:Schema>
- <rs:data>
<z:row c0=“294” />
rs:data>
xml>

I want to store the value 294 of attribute in a variable. How do I implement the action Read XML Value to Variable. What is the Xpath and do I to use the option read an attribute of the XPath node?

Thanks in advance.

Bye
Ralph

2

Hi Ralph,

The XPath to read the node is ‘/xml/rs:data/z:row’ and you will need to check ‘Read an attribute of the XPath Node’ specifying ‘c0’.

Also make sure ‘Expand namespace prefixes declard in the document root node’ is enabled and the default namespace identifier prefix is empty on the MSXML Parser tab.

Regards,
Paul.