I have an XML file which has records as below: <Users> <User&

I have an XML file which has records as below:
<Users>
<User>
<LoginId>1</Loginid>
<Company>companyname1</Company>
....
</User>
<User>
<LoginId>2</Loginid>
<Company>companyname2</Company>
....
</User>
...


</Users>

I want this XML to be ADD/EDIT/DELETE the any of USER record through Appian form.
It would be something like, input user form data should populate inside this XML.. allow to edit existing user or remove any user.
How it could be achieve

Thanks...

OriginalPostID-86629

OriginalPostID-86629

  Discussion posts and replies are publicly visible

Parents
  • We need to generate the xml user file everytime we want to update any data.

    Please create a CDT name "userDetails" which should have the below fields
    >loginId
    >company
    >web
    >phone

    Now in your user management process use this cdt type to store all the xml user information.
    and runtime you create a rule something like this

    ruleUserInfo=concat("<User>"&"br/"<LoginId>"&userdetails.loginId&"</Loginid>"&"br/"&"</User>")

    usning MNI script task or looping function run the above rule for each user.

    Finally use joinarray("userCDT","");
    This result will be your final user info.
    pass this as argument in the "Text Doc from Template"

    To add/edit/delete the same steps needs to be follwed.
Reply
  • We need to generate the xml user file everytime we want to update any data.

    Please create a CDT name "userDetails" which should have the below fields
    >loginId
    >company
    >web
    >phone

    Now in your user management process use this cdt type to store all the xml user information.
    and runtime you create a rule something like this

    ruleUserInfo=concat("<User>"&"br/"<LoginId>"&userdetails.loginId&"</Loginid>"&"br/"&"</User>")

    usning MNI script task or looping function run the above rule for each user.

    Finally use joinarray("userCDT","");
    This result will be your final user info.
    pass this as argument in the "Text Doc from Template"

    To add/edit/delete the same steps needs to be follwed.
Children
No Data