How to fetch API data using Power Automate

| Uzair Iftikhar

OVERVIEW OF API

API is the acronym for Application Programming Interface, which is a software intermediary that allows two applications to talk to each other. Each time you use an app like Facebook, send an instant message, or check the weather on your phone, you’re using an API.

HOW TO SEE API RESPONSE

You can see API response by using postman application by sending request using post method and it will show the response of the request send in different formats

Postman have these methods for sending request to server shown in below image

SENDING POSTMAN REQUEST TO SEE THE RESPONSE

You can send the postman request to server and it will generate a response of the request which will show the data fetch from the API and then you can use the body of the API in power automate for fetching the data from API

Above shown diagram is the example of how you can send request in postman and it will generate a body of request and will show the result in formats in different types

The result can be shown in different formats in postman applications for example

USING POSTMAN BODY IN POWER AUTOMATE FLOW FOR FETCHING DATA

1: Now you can put the body of postman request in power automate compose action

2: Then you will call the custom connector for calling the API and in the body you will give the output of the compose body of postman request

3: When you will run the flow it will generate the result in body and you can see the copy the whole body of the output result and paste in xml viewer and you can see the xml of the body which contains the data of requested API

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"><soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"><snp:StartSession xmlns:snp="urn:CSSoapService"><return>no_error</return><access_key>38369906</access_key></snp:StartSession></soap:Body></soap:Envelope>

Join us next time, as we continue our journey of learning canvas apps.Click here to learn more about Imperium's Power Apps Services. We hope this information was useful, and we look forward to sharing more insights into the Power Platform world.


M
Chief Architect, Founder, and CEO - a Microsoft recognized Power Platform solution architect.

About The Blog

Stay updated with what is happening in the Microsoft Business Applications world and initiatives Imperium is taking to ease digital transformation for customers.


More About Us

We provide guidance and strategic oversight to C-Suite and IT Directors for on-going implementations. Feel free to give us a call.

1 331 250 27 17
Send A Message

Ready to Start?

Get a personalized consultation for your project.

Book a Meeting