cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
v-Divyave
Microsoft
Microsoft

send an HTTP request to DevOps - To find XML node to ADD/UPDATE/DELETE node

Hello Everyone,

 

I am working on a requirement that, to fetch XML file from ADO through power automate and splitting the file and showing it in my app like control values. For this I am using "send an HTTP request to DevOps" in my flow. Following the same process for push back the changes to DevOps ADO. By doing this, I need to do the following as well,

       1. Add new node to the XML,

       2. Delete the existing node,

       3. Updating the node

Currently, I am achieving adding new node with multiple steps. But, for updating or deleting excising node should happen based on the key. So, I would like to know that is there any simplified way to achieve this.

 

This is my example XML:

<?xml version="1.0" encoding="utf-8"?>
<root>
<data name="KEY_1" xml:space="preserve">
<value>value 1</value>
<comment>comment 1</comment>
</data>
<data name="KEY_2" xml:space="preserve">
<value>value 2</value>
<comment>comment 2</comment>
</data>
<data name="KEY_3" xml:space="preserve">
<value>value 3</value>
<comment>comment 3</comment>
</data>
<data name="KEY_4" xml:space="preserve">
<value>value 4</value>
<comment>comment 4</comment>
</data>
</root>


1) Add a new node with key "KEY_5" and value "value 5"
2) Delete the data node with key "KEY_2"
3) Update the value of the node with key "KEY_1" with value "value 1 new" – Whenever I’m trying to update the value I must find the respective key and update the value.

 

0 REPLIES 0

Helpful resources

Announcements
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (59,332)