REST API Calls and XML Parsing in Power Automate Desktop - Advanced Use Case

This advanced use case shows how to do REST API calls with Microsoft Power Automate Desktop and extract the XML response. A REST API call is often known as a web or HTTP request and is faster and more reliable than creating RPA that works in the UI. So always look for an API before clicking buttons in the UI.

POWER AUTOMATE DESKTOP GROUPS:
- Join my network with 4000+ Automation/RPA developers, where we solve Automation/RPA problems, network, and help each other upgrade our careers. It's free!

FOLLOW ME:

0:00 Intro
Performing a REST API call is like a Google search: You make a request and get a response back. We use a URL with parameters to complete the request; the response is sometimes in an XML format. A REST API call and the XML parse are easy to perform in Power Automate Desktop. Here's how.

3:06 REST API Call
Use an Invoke web service action to perform a REST API call. A REST API is often called a web or HTTP request. The response here is in XML format; choose to save it as a file; then, it's easy to work with.

5:33 Parse XML
In the Invoke web service, choose to save the file. Then, we read the XML file using a Read XML from file action. Next, specify the same file path you've used in the Invoke web service action. Next, we need to know a little XPath to query and parse the XML. Finally, we can get out the attribute values we need with the simple XPath expression.

8:59 REST API and XML Use Case
The Power Automate Desktop use case we need to solve involves reading an Excel sheet, making the REST API call based on the Excel sheet, parsing XML data, and writing it back to XML.

#powerautomate #powerplatform #office365

[andersjensenorg]

Please give the video a thumbs up if it helped you.
Thank you 🙌😊

[atiqure]

API has been a long pain for me. You made it super simple and clear. if possible make more videos on API. Thanks a lot. May almighty bless you.

[arazdavlund]

It's a very interesting video, I've learned a lot from you and you explain very well in a very pedagogical way. Thanks for your fantastic video.

[ALVINMAN]

Thank you for this excelent video.Best regards.

[suraj_singh]

Great Content Appreciate your work sir make a video on Orchestrator API using Postman and Orchestrator HTTP Activity Uipath as soon as possible

[larsmarcussen]

Great Video, thanks.
One question, how come when you read the values from Excel, that you dont use a dynamic range? Let’s sat that we would like to add a few more ISO codes. And then you would have to manually update the robot? 😊

[chandanmaity]

If I don't save the xml file and use get xml attributes will it work?

[amgadmohamed]

hi need a video if the API used has a credential or from an organization orchestrator, can you help me ?

[vejandlaasrith]

Hi sir, I am following your videos for a while, I have few questions to ask.
1. To get XML attribute, It didn't worked for me, it saying invalid Xpath provided, but when I gave the same xpath in online XPath tester it working fine, then I googled about the problem and read that XML having namespaces isn't working in PAD properly, Do you know about this sir?
2. I am finding difficult to use Run Python, I don't know why, it's like I didn't able to retrieve the flow variables in to the python script. Could you help me with this sir? A detailed video on Run Python Script, JS, VBScript.
Thanks