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
  • Can you share me...
    I have below XML:
    <Users>
    <User>
    <LoginId>1</Loginid>
    <Company>companyname1</Company>
    <web>companyname1</web>
    <phone>121212</phone>
    </User>
    <User>
    <LoginId>2</Loginid>
    <Company>companyname2</Company>
    <web>companyname2</web>
    <phone>121212</phone>
    </User>
    <User>
    <LoginId>3</Loginid>
    <Company>companyname1</Company>
    <web>companyname1</web>
    <phone>121212</phone>
    </User>
    </Users>

    I have above xml into process variables.
    Now, i suppose to fetch below user XML:
    <User>
    <LoginId>3</Loginid>
    <Company>companyname1</Company>
    <web>companyname1</web>
    <phone>121212</phone>
    </User>

    nOW,i got updated this user details from user input and found below xml node:
    <User>
    <LoginId>3</Loginid>
    <Company>final1</Company>
    <web>companyname1</web>
    <phone>121212</phone>
    </User>

    Can you please share me how to replace particular OLD block (number of lines) with new block into XML (PV). ?

    Please also let me know , how to add new user node append to last user of XML. ?
    Thank You
Reply
  • Can you share me...
    I have below XML:
    <Users>
    <User>
    <LoginId>1</Loginid>
    <Company>companyname1</Company>
    <web>companyname1</web>
    <phone>121212</phone>
    </User>
    <User>
    <LoginId>2</Loginid>
    <Company>companyname2</Company>
    <web>companyname2</web>
    <phone>121212</phone>
    </User>
    <User>
    <LoginId>3</Loginid>
    <Company>companyname1</Company>
    <web>companyname1</web>
    <phone>121212</phone>
    </User>
    </Users>

    I have above xml into process variables.
    Now, i suppose to fetch below user XML:
    <User>
    <LoginId>3</Loginid>
    <Company>companyname1</Company>
    <web>companyname1</web>
    <phone>121212</phone>
    </User>

    nOW,i got updated this user details from user input and found below xml node:
    <User>
    <LoginId>3</Loginid>
    <Company>final1</Company>
    <web>companyname1</web>
    <phone>121212</phone>
    </User>

    Can you please share me how to replace particular OLD block (number of lines) with new block into XML (PV). ?

    Please also let me know , how to add new user node append to last user of XML. ?
    Thank You
Children
No Data