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

  • @andersjensenorg
    @andersjensenorg Жыл бұрын

    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 👋😊

  • @SalihKocaSK
    @SalihKocaSK Жыл бұрын

    Thanks Anders for another very useful content with very clean explanation as always. May the force be with you ! 😎

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    I'm so happy to hear, Salih - thanks a ton 🙏🔥

  • @estebanseguel7004
    @estebanseguel7004 Жыл бұрын

    Perfect and clean explenation... thanks and congrats!

  • @andersjensenorg

    @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

  • @carstenhopp9459
    @carstenhopp9459 Жыл бұрын

    Thank´s to this video! I really appreciated it and it helped me to create my own flow!

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Wow great, Carsten. Thanks a lot for letting me know 🙌😊 Kind regards, Anders

  • @notorioussamurai1671
    @notorioussamurai16715 ай бұрын

    Thank you for this, its so much valuable source to learn from scratch.... :)

  • @andersjensenorg

    @andersjensenorg

    5 ай бұрын

    I'm so glad to hear, thanks a lot 🙌😊 Kind regards, Anders

  • @erdincerdogan9159
    @erdincerdogan9159 Жыл бұрын

    Hi Mr Jensen You are doing very useful training videos which give me an idea on my job thank you very much

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Thanks a lot, Erdinc - your comment is highly appreciated. Have a great weekend 😊 Kind regards, Anders

  • @Vihana_vlog
    @Vihana_vlog10 ай бұрын

    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

    @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

    @Vihana_vlog

    10 ай бұрын

    @@andersjensenorg 🤟

  • @alfman7630
    @alfman7630 Жыл бұрын

    Nice! Very helpful.

  • @andersjensenorg

    @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

  • @garcialex06
    @garcialex062 ай бұрын

    Many thanks, well well explained

  • @andersjensenorg

    @andersjensenorg

    2 ай бұрын

    My pleasure, kind regards, Anders

  • @williamwade8119
    @williamwade8119 Жыл бұрын

    Excellent as always!

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Thank you so much, William 👋😊 Your always positive comments are highly appreciated. Kind regards, Anders

  • @williamwade8119

    @williamwade8119

    Жыл бұрын

    @@andersjensenorg It is easy when the content is good. Keep up the good work!

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Thanks a lot 🥳🔥

  • @mandarborkar5657
    @mandarborkar56575 ай бұрын

    Thanks Anders.

  • @andersjensenorg

    @andersjensenorg

    5 ай бұрын

    Thanks a lot 🤩

  • @vincentvdm
    @vincentvdm Жыл бұрын

    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

    @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

  • @ketanpimple1933
    @ketanpimple19339 ай бұрын

    Best ❤

  • @andersjensenorg

    @andersjensenorg

    9 ай бұрын

    Many thanks 🥰

  • @totemimaging
    @totemimaging Жыл бұрын

    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

    @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

    @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! 😊

  • @user-vx2sm8ns1q
    @user-vx2sm8ns1q4 ай бұрын

    Thanks A Lot My Brother

  • @andersjensenorg

    @andersjensenorg

    4 ай бұрын

    Always welcome, my friend 😎😊 Kind regards, Anders

  • @ChinhNguyen-ep4ik
    @ChinhNguyen-ep4ik11 ай бұрын

    Thank you, your article is very good you can show me? how to split multiple threads to call API at 1 time

  • @andersjensenorg

    @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

  • @elmasinvisible007
    @elmasinvisible0072 ай бұрын

    Great video Anders. Do you have a video for Patch Method to update?

  • @andersjensenorg

    @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

  • @vvaassaanntthh
    @vvaassaanntthh Жыл бұрын

    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

    @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

  • @sailing_life_
    @sailing_life_12 күн бұрын

    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

    @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

  • @rpa-lowcode
    @rpa-lowcode8 ай бұрын

    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

    @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

  • @minhtongnhat1694
    @minhtongnhat16945 ай бұрын

    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

    @andersjensenorg

    5 ай бұрын

    Hey Minth, I can see you already posted this on my discord, which is great 😊 Kind regard, Anders

  • @arigelayedukondalu861
    @arigelayedukondalu8615 ай бұрын

    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

    @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

  • @rafaelnegreiros_analyst
    @rafaelnegreiros_analyst6 ай бұрын

    @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

    @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

  • @KV_zacc
    @KV_zacc9 ай бұрын

    Thanks, but for a complete tutorial it would have been good to show how to display the results in an app.

  • @andersjensenorg

    @andersjensenorg

    9 ай бұрын

    Thanks for the feedback, matetamas 🙂

  • @skullkid234
    @skullkid234 Жыл бұрын

    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

    @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

Келесі