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

Venu over 8 years ago

Hi All,

I am trying to get xml data using xpathdocument(), The xml document is saved in Appian(As attachment).
xml document contains attribute xmlns="http://www.adatum.com" at the root element. with out this attribute I can get the xml data. what could be the possible xpath expression.

xpathdocument(ri!doc,"//Tests")

Thanks.

testXml.xml

Discussion posts and replies are publicly visible

Top Replies

Venu over 8 years ago +1

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…

Parents

0 PhilB
A Score Level 1
over 8 years ago

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()"
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 PhilB
A Score Level 1
over 8 years ago

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()"
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data