REST API Calls in Power Automate - Beginners Tutorial
Ғылым және технология
This video tutorial shows how to do REST API Calls, also known as HTTP Requests, and interpret the response with JSON parsing. In the last advanced part, we'll do multiple REST API calls from an Excel sheet, write the results back to Excel, and error handling based on the status codes.
📂 Download the course materials: andersjensen.org/microsoft-po...
VIDEOS FOR YOU:
🔹 Power Automate Beginners Course: • Microsoft Power Automa...
🔹 Power Automate BREAKING NEWS: • Power Automate BREAKIN...
POWER AUTOMATE GROUPS:
👨👩👧👦 Discord: / discord
- Join my network with 4300+ Automation/RPA developers, where we solve Automation/RPA problems, network, and help each other upgrade our careers. It's free!
👩🏻🎓 LinkedIn: / 12566435
👨🏻💻 Facebook: / 754059285247921
FOLLOW ME:
💼 LinkedIn: / andersjensenorg
📸 Instagram: / andersjensenorg
👨 Facebook: / andersjensenorg
🐦 Twitter: / andersjensenorg
💌 Email Newsletter: and
ersjensen.org/email-newsletter
0:00 REST API Call
A REST API Call, also known as HTTP Request, is like a Google search: You make a request and get a response back. The response is usually in JSON format. In Power Automate, we use an HTTP action. Provide a Method and a URL (the endpoint).
4:29 JSON Parsing
With a Parse JSON action, we make it easy to refer to the response data from the REST API Call (HTTP Request). Provide a JSON schema.
7:52 Multiple REST API Calls at once
The complete solution reads ID data from an Excel sheet, performs multiple REST API Calls, and writes the results back to Excel. Use a List rows present in a table action to read the Excel data. Then the Apply to each action to iterate through the Excel data. Finally, an Update a row action to write the results back.
13:58 Error-handling the API Responses
Power Automate is exceptional in doing error handling. First, we'll create our error handling based on the Status codes from the API response. Then, use a Condition of a Switch on the Status code and perform the actions in the branches/cases. Remember to use the Configure run after setting in the Switch.
#powerautomate #powerplatform #office365
Пікірлер: 53
I've created a Discord, where we can network and solve Power Automate problems together: discord.gg/iloveautomation Right now we're more than 4300 Automation Developers and it's of course FREE 👋😊
Thanks Anders for another very useful content with very clean explanation as always. May the force be with you ! 😎
@andersjensenorg
Жыл бұрын
I'm so happy to hear, Salih - thanks a ton 🙏🔥
Perfect and clean explenation... thanks and congrats!
@andersjensenorg
Жыл бұрын
Hey Esteban Seguel. Thanks a lot 😊 Have a great day. You're more than welcome at my Discord, where we're 6000+ RPA developers networking and solving problems: kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders
Thank´s to this video! I really appreciated it and it helped me to create my own flow!
@andersjensenorg
Жыл бұрын
Wow great, Carsten. Thanks a lot for letting me know 🙌😊 Kind regards, Anders
Thank you for this, its so much valuable source to learn from scratch.... :)
@andersjensenorg
5 ай бұрын
I'm so glad to hear, thanks a lot 🙌😊 Kind regards, Anders
Hi Mr Jensen You are doing very useful training videos which give me an idea on my job thank you very much
@andersjensenorg
Жыл бұрын
Thanks a lot, Erdinc - your comment is highly appreciated. Have a great weekend 😊 Kind regards, Anders
Hi Anders, Thank you so much for sharing very useful videos on RPA. You are the best RPA teacher. You helped me and so many other people all around the world to start RPA as career. Really awesome. Kindly share videos on Microsoft Power Apps and Power Virtual Agents.
@andersjensenorg
10 ай бұрын
You're very welcome, @Vihana_vlog - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 8000+ RPA developers networking and solving problems: kzread.info/dash/bejne/qot63I-MaZm-d9I.html
@Vihana_vlog
10 ай бұрын
@@andersjensenorg 🤟
Nice! Very helpful.
@andersjensenorg
Жыл бұрын
You're very welcome, Alf Man - your support helps me a lot 😍 You're more than welcome at my Discord, where we're 5800+ RPA developers networking and solving problems: kzread.info/dash/bejne/qot63I-MaZm-d9I.html
Many thanks, well well explained
@andersjensenorg
2 ай бұрын
My pleasure, kind regards, Anders
Excellent as always!
@andersjensenorg
Жыл бұрын
Thank you so much, William 👋😊 Your always positive comments are highly appreciated. Kind regards, Anders
@williamwade8119
Жыл бұрын
@@andersjensenorg It is easy when the content is good. Keep up the good work!
@andersjensenorg
Жыл бұрын
Thanks a lot 🥳🔥
Thanks Anders.
@andersjensenorg
5 ай бұрын
Thanks a lot 🤩
Hi Anders, thx ffor this great introduction as I'm new to power automate. I managed to setup my flow but how do I get the data from the flow back to powerapps ?
@andersjensenorg
Жыл бұрын
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders
Best ❤
@andersjensenorg
9 ай бұрын
Many thanks 🥰
Excellent - I *think* you might have helped me solve an issue with Power BI not being able (due to Parameter usage to calculate the total number of pages) to paginate JSON data when published in the cloud ;-). Currently, in order to get around this limitation, I used Power Automate Desktop to automate the refresh of the desktop version, save, then publish. Not really best practice and more of a sledgehammer approach
@andersjensenorg
Жыл бұрын
Hey Anthony. Haha, sometimes the sledgehammer approach is what we have, and then it's okay (I use it myself here and there) 😄 Thanks a lot for the nice words. Kind regards, Anders
@totemimaging
Жыл бұрын
@@andersjensenorg yes, but I just have the occasional issue where it can't detect buttons on the app or OCR doesn't function properly between different machines (even though screen Resolution has been set the same in setup file). Anyway, I can confirm that the API call using the method in the tutorial is much better and now it's functioning beautifully on 400 pages of JSON being pulled to SharePoint and then Power BI doing the rest from there! 😊
Thanks A Lot My Brother
@andersjensenorg
4 ай бұрын
Always welcome, my friend 😎😊 Kind regards, Anders
Thank you, your article is very good you can show me? how to split multiple threads to call API at 1 time
@andersjensenorg
11 ай бұрын
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 7000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders
Great video Anders. Do you have a video for Patch Method to update?
@andersjensenorg
Ай бұрын
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 11,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders
Hi Anders. thanks this was great. I do have some questions 1. Lets say I have a similar requirement whereby I need to connect to a website to fetch data and populate a excel, If I don;t know the API url, how do I find that out? In your case you had given the direct api url, but if I need to find out the api of a customer website, what is the easiest way to find out the api of the website, and if they have exposed the api (to make calls) or not? 2. in the "http" connector (below the method and uri), we have "headers" and "Queries". I have seen some people putting the value of "application/JSON". do we need to put that? what does it mean?
@andersjensenorg
Жыл бұрын
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 5800+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders
great video, thanks! I noticed the full automation took 30 or 40 seconds to run, did you have to somehow code in a timer or delay function to take a break in between api calls? If so, how did you do it in power automate?
@andersjensenorg
12 күн бұрын
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 12,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders
Hi Jensen, Does this Premium version need to buy a license? Currently I am using the free license of the office 365 E1 plan.
@andersjensenorg
8 ай бұрын
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 9000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders
Thank you for your excellent video. I watched the entire thing, but I haven't been able to resolve my issue. Specifically, I'm trying to connect ChatCompose to Power automatically, but I'm unsure how to do it, and I can't find information automating the API workflow to make request calls from another system. Please assist me with this. I sincerely appreciate your help
@andersjensenorg
5 ай бұрын
Hey Minth, I can see you already posted this on my discord, which is great 😊 Kind regard, Anders
Hi Anders, Thanks a lot to explain in detail.. I followed in same way bht am facing an error at http request, Getting 403(forbidden) error at post method.. But the same api working fine in postman and uipath, but i am getting error particularly in this cloud flow.. Any help.?
@andersjensenorg
5 ай бұрын
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders
@andersjensenorg could you help me please. I'm trying to use PowerAutomate HTTP action, but I am facing problem with Authentication. I've heard PoweAutomate does no support Auth 2.0 (PKCE). Is it true?
@andersjensenorg
6 ай бұрын
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 10,000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders
Thanks, but for a complete tutorial it would have been good to show how to display the results in an app.
@andersjensenorg
9 ай бұрын
Thanks for the feedback, matetamas 🙂
My flow successfully runs.. but my output is empty.. Im looking at my flow and it looks like for some reason I'm getting an empty array value returned back from my call.. Not sure what I'm doing wrong..
@andersjensenorg
Жыл бұрын
Thanks for writing 😊 I'm getting more than 50 messages daily. While I read all of them, I can’t reply to everyone 😔 But I’ve created an RPA/Automation community where we’re 6000+ RPA Developers helping each other with solutions and our careers. Here’s the video on how to join (the invitation link is in the video description): kzread.info/dash/bejne/qot63I-MaZm-d9I.html Kind regards, Anders