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

dhavals over 11 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 11 years ago

No luck.
I have added root node as APPUSERS so, XML look as below:
<?xml version="1.0" encoding="utf-8"?>
<APPUSERS>
<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>
</APPUSERS>

tried below function:
xpathdocument(cons!AppSignatureXMLFile,"/APPUSERS/APPUSER")
also tried
xpathdocument(cons!AppSignatureXMLFile,"/APPUSERS/APPUSER[1]")
or
xpathdocument(cons!AppSignatureXMLFile,"//APPAINID")

None of above worked..

I have applied process vaiable assignment on - USER INPUT ACTIVITY TASK >> OUTPUT - CUSTOM VARIABLE - ASSIGNING EXRPESSION TO PROCESS VARIABLES.

but all process variables shows me empty while i see after executing this task in debug mode.

do i have to give some prefix ?, in my XML exactly look as above.
please suggest me what is still wrong.

thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 dhavals over 11 years ago

No luck.
I have added root node as APPUSERS so, XML look as below:
<?xml version="1.0" encoding="utf-8"?>
<APPUSERS>
<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>
</APPUSERS>

tried below function:
xpathdocument(cons!AppSignatureXMLFile,"/APPUSERS/APPUSER")
also tried
xpathdocument(cons!AppSignatureXMLFile,"/APPUSERS/APPUSER[1]")
or
xpathdocument(cons!AppSignatureXMLFile,"//APPAINID")

None of above worked..

I have applied process vaiable assignment on - USER INPUT ACTIVITY TASK >> OUTPUT - CUSTOM VARIABLE - ASSIGNING EXRPESSION TO PROCESS VARIABLES.

but all process variables shows me empty while i see after executing this task in debug mode.

do i have to give some prefix ?, in my XML exactly look as above.
please suggest me what is still wrong.

thanks.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data