I want to achieve as below: document as - XML file contains list of u

dhavals over 10 years ago

I want to achieve as below:

document as - XML file contains list of user node where each user node contains number of element describing user information.

Now, I want to fetch the user node block (all child nodes) match to appian login id and user node's login id child node.

Can any one share me which Appian activity or service would i have to use and how to achieve this.

Thank you...

Discussion posts and replies are publicly visible

Parents

0 dhavals over 10 years ago

It did not work, please see below as i tried:
1. my xml look as below:
<?xml version="1.0" encoding="utf-8"?>
<APPUSER>
<APPAINID>dhaval.soni</APPAINID>
<NAME>Mark</NAME>
<WEB>www.companysite.com</WEB>
</APPUSER>
<APPUSER>
<APPAINID>d.soni</APPAINID>
<NAME>Williamson</NAME>
<WEB>www.companysite.com</WEB>
</APPUSER>

tried function as follow:
=xpathdocument(cons!AppSignatureXMLFile,"/ADJUSTER[APPAINID='dhaval.soni']")
//cons!AppSignatureXMLFile contains XML document object , [also tried by document id]
tried to assign its resolve into process variable but it did not get assign and process variable shows empty only.

NOTE: have also tried by passing "ns" prefix , by removing <?xml version...> but it did not work.

please suggest me what is wrong here.
thank you
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 dhavals over 10 years ago

It did not work, please see below as i tried:
1. my xml look as below:
<?xml version="1.0" encoding="utf-8"?>
<APPUSER>
<APPAINID>dhaval.soni</APPAINID>
<NAME>Mark</NAME>
<WEB>www.companysite.com</WEB>
</APPUSER>
<APPUSER>
<APPAINID>d.soni</APPAINID>
<NAME>Williamson</NAME>
<WEB>www.companysite.com</WEB>
</APPUSER>

tried function as follow:
=xpathdocument(cons!AppSignatureXMLFile,"/ADJUSTER[APPAINID='dhaval.soni']")
//cons!AppSignatureXMLFile contains XML document object , [also tried by document id]
tried to assign its resolve into process variable but it did not get assign and process variable shows empty only.

NOTE: have also tried by passing "ns" prefix , by removing <?xml version...> but it did not work.

please suggest me what is wrong here.
thank you
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data