Hi All, I am trying to get xml data using xpathdocument(), The xml do

If you want to get an array of each Test within the Tests element, your xpath expression needs to be /*[name()='Tests']/*[name()='Test'] as this should avoid the issue caused by the namespacing.

Phil, Thanks for your reply

i used the above xpath, but "xmlns="http://www.adatum.com" is appended to the result (to the Test element as below).
======================
<Test xmlns="http://www.adatum.com" TestId="0001" TestType="CMD">
<Name>Convert number to string</Name>
<CommandLine>Examp1.EXE</CommandLine>
<Input>1</Input>
<Output>One</Output>
</Test>;
======================
Any suggestions.

The namespace being attached is expected as it's part of the top level XML and so is replicated on the result you extract. What exactly are you trying to extract? If you're able to provide that, I might be able to tell you what expression to use.

What i need exactly is the xml contains 3 Test information, i need to save three records in CDT

You'll need to create a rule that returns your CDT (example below) and then apply that rule across the result of the xpathdocument() using "/*[name()='Tests']/*[name()='Test']".

type!myCDT(
          name: xpathsnippet(ri!xml, "/*[name()='Test']/*[name()='Name']/text()")
          commandLine: xpathsnippet(ri!xml, "/*[name()='Test']/*[name()='CommandLine']/text()"
          input: xpathsnippet(ri!xml, "/*[name()='Test']/*[name()='Input']/text()"
          output: xpathsnippet(ri!xml, "/*[name()='Test']/*[name()='Output']/text()"
)

Thanks Phil,

i have another question,
i have an xml file of 3 records(rows) and that didn't have namespace.
i used xpathdocument and torecord functions to save data in my cdt variable.
xpathdocument give 3 records correctly, but torecord saves only the last row even the type variable is multiple (Array).

this issue was resolved by some work around.

here my question is: what could be the reason torecord saves only last record/row?

Could you post the xml and related expressions?

Below is the code and attaching XML

load(
a!paragraphField(
value:torecord(xpathdocument(95893,"/root/data"),ri!test),
height:"TALL"
)
)

here ri!test is the input to the interface of custom type (CDT Array)

newxml.xml