Microsoft Power Automate - How to do REST API Calls and update Excel - Full Tutorial

This video tutorial shows how to make REST API calls in Microsoft Power Automate and update an Excel sheet with the information requested from the HTTP. JSON parsing is also covered.
You could also watch:
🔵 Power Automate for Beginners - • Microsoft Power Automa...
🔵 Power Automate & WinAutomation Setup - • Microsoft Power Automa...
🔵 Regex in Power Automate - • How to use Regular Exp...
0:21 Inspecting our Excel data
Our data is currency rates in an Excel sheet (OneDrive) and we want to constantly get the newest rates into our sheet. A simple REST API (HTTP request) solution will be applied.
0:56 JSON with our data
We inspect the updated currency rates, which are in JSON format.
1:47 Create a new Power Automate Flow
Usually, we want to schedule these flows, but for a simple example, we will create an instant flow.
2:20 HTTP
Chose an HTTP action. The method is GET here (it is not always, so be aware of what settings your API requires). Furthermore we specify the URL (endpoint).
3:02 Parse JSON
Under Data Operations chose Parse JSON. The content is the body from our HTTP request. The schema we create in an easy way.
4:14 Update Excel
With the newest data from the REST API call, we can now update our Excel sheet in OneDrive.
FOLLOW ME:
💼 LinkedIn: / andersjensenorg
🐦 Twitter: / andersjensenorg
📸 Instagram: / andersjensenorg
👨 Facebook: / andersjensenorg
👨‍👩‍👧‍👦 Discord: / discord
💌 Email Newsletter: andersjensen.org/email-newsle...
#powerautomate #api #excel

Пікірлер: 59

  • @andersjensenorg
    @andersjensenorg3 жыл бұрын

    Check my Power Automate Beginners Tutorial, where all the basic stuff is covered - kzread.info/dash/bejne/oaGFj8h6dpe3oKw.html

  • @JosephStreet-dk7uw
    @JosephStreet-dk7uw3 ай бұрын

    Excellent video. Clear, concise and straight forward. Thank you!

  • @andersjensenorg

    @andersjensenorg

    2 ай бұрын

    Thank you so much for the kind words 🙌😊 Anders.

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

    This is the perfect tutorial video: clear, concise, and demonstrates an easy way to do something really useful! Thanks so much.

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Hey Feuch24. Thanks a lot 😊 Have a great day. Kind regards, Anders

  • @deepanshsaxena5677
    @deepanshsaxena56774 ай бұрын

    Enjoyed understanding it, lovely. Thanks for sharing this!

  • @andersjensenorg

    @andersjensenorg

    3 ай бұрын

    Thanks a bunch, @deepanshsaxena5677 🤩 I've created a Discord. We're more than 11,000+ RPA developers networking and solving problems here: kzread.info/dash/bejne/qot63I-MaZm-d9I.html You're more than welcome. Kind regards, Anders

  • @RaviKrishnaSrivastava
    @RaviKrishnaSrivastava3 жыл бұрын

    Precise & to the point. Thanks for sharing this video.

  • @andersjensenorg

    @andersjensenorg

    3 жыл бұрын

    Hey Ravi. Thank you very much 😊 Is there any Power Automate topic, you would find interesting for a future video? I am about to do a handful and the first will be about expressions (a full guide). Kind regards, Anders

  • @lukmanoyedokun1956
    @lukmanoyedokun19563 жыл бұрын

    This is cool and straight forward. Thank you.

  • @andersjensenorg

    @andersjensenorg

    3 жыл бұрын

    Hey Lukman. Thanks a lot :) Kind regards, Anders

  • @graycat20
    @graycat202 жыл бұрын

    Thanks for this. It was really useful! I ran into some problems with the JSON being returned as it's not the most simple of things but got it working in the end.

  • @andersjensenorg

    @andersjensenorg

    2 жыл бұрын

    Hey Tim. Nice to hear. Sometimes it do tricks with me as well :) Kind regards, Anders

  • @imtiazakhtar5373
    @imtiazakhtar53733 жыл бұрын

    Clear and precise, Good job ... ! Thanks++

  • @andersjensenorg

    @andersjensenorg

    3 жыл бұрын

    Thank you, Imtiaz 🙂

  • @obeidmirzagmail
    @obeidmirzagmail3 жыл бұрын

    Thank you, you're a lifesaver!

  • @andersjensenorg

    @andersjensenorg

    3 жыл бұрын

    Thanks a lot for letting me know, Mirza 🙂

  • @Dany-ns6hg
    @Dany-ns6hg3 жыл бұрын

    Nice video Anders, learned something new today

  • @andersjensenorg

    @andersjensenorg

    2 жыл бұрын

    You're very welcome, Dany - your support helps me a lot 😍

  • @thebestfella
    @thebestfella3 жыл бұрын

    this is really powerful

  • @andersjensenorg

    @andersjensenorg

    3 жыл бұрын

    Hey thebestfella. Yeah, like it - let me know, if you have any questions or ideas for future videos. Kind regards, Anders

  • @Doedoebear
    @Doedoebear2 жыл бұрын

    Thank you!!

  • @andersjensenorg

    @andersjensenorg

    2 жыл бұрын

    You're very welcome 🤗

  • @cryptostar1427
    @cryptostar14273 жыл бұрын

    thank you !

  • @andersjensenorg

    @andersjensenorg

    3 жыл бұрын

    Happy you could use it 😊

  • @lassemichellesmidtheimann9627
    @lassemichellesmidtheimann96274 жыл бұрын

    Cool Anders :)

  • @andersjensenorg

    @andersjensenorg

    4 жыл бұрын

    Mange tak 👍😊

  • @soumyadeepmondal6130
    @soumyadeepmondal61302 жыл бұрын

    Hi! So, the http connector that you used is a premium connector. In our organisation, we can not use a premium connector as it incurs additional cost, so we have to stick to free connectors only. So, can you let me know any other alternative to consume a rest api in Power Automate but without using a premium connector? Is there any free connector available that can do the job? I could not find any myself... Thanks in advance!

  • @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

  • @mshparber
    @mshparber3 жыл бұрын

    Thanks! How can you manage an incremental update?

  • @andersjensenorg

    @andersjensenorg

    3 жыл бұрын

    Hey Michael. Thank you 👍🙂 Can you specify, what you mean? Kind regards, Anders

  • @mshparber

    @mshparber

    3 жыл бұрын

    Anders Jensen Let’s say to get some records from API and want to add only those that don’t exist yet in Excel.

  • @andersjensenorg

    @andersjensenorg

    3 жыл бұрын

    Sure. But we need to split it up then: - Http Request - Parse the JSON - Read the Excel - Iterate through the Excel (Data Table) - If not a match, add it Let me know, where you are stuck

  • @nathanagarwal1378
    @nathanagarwal13783 жыл бұрын

    I have a case with non json response and cert authentication. Is that possible? What might I have to change?

  • @andersjensenorg

    @andersjensenorg

    2 жыл бұрын

    Hey Nathan Agarwal Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzread.info/dash/bejne/kYWGq4-Sn5XOaLg.html Have a great day. Kind regards, Anders

  • @lotfiboucherit
    @lotfiboucherit3 жыл бұрын

    this is so great! please, i have an automation task that contains the following: - create a vm in vcenter - configure vm operating system (name) - request rest apis for several services (in this video, thumbs up!) - connect to rdp session of the new vm - then configure applications, using results of rest apis calls... like, configuring office 365 apps i'd like to know, if this can be achieved with power automate? thank you in advance!

  • @andersjensenorg

    @andersjensenorg

    3 жыл бұрын

    Hey Mohammed. Thank you. When we create it, we need to ask ourselves, how would a human do it and then try to replicate it. I don't have all the answers and you have to solve it with either Power Automate Desktop (kzread.info/dash/bejne/nYGKu6ulctbYn9Y.html) or UiPath (kzread.info/dash/bejne/paRpvNl_e8nOXZM.html). Kind regards, Anders

  • @abhijithprabha6377
    @abhijithprabha63773 жыл бұрын

    Is there any methods to make a file 'read-only' in SharePoint using power automate?

  • @andersjensenorg

    @andersjensenorg

    3 жыл бұрын

    Hey Abhijith. Yeah, you can use an Azure function OR just do it with Plumsail (this plugin but another case: kzread.info/dash/bejne/a5WWxpOufJraeNI.html). NB: Plumsail is a paid plugin. Kind regards, Anders

  • @CarlosestebanVargasMoreno
    @CarlosestebanVargasMoreno3 жыл бұрын

    is it possible to make url with http, because https is bad for my case. Thank you

  • @andersjensenorg

    @andersjensenorg

    3 жыл бұрын

    Hey Carlos. Thank you very much 😊 For sure, it's just the address. Kind regards, Anders

  • @christopherjohnson9511
    @christopherjohnson95113 жыл бұрын

    How would you a JSON web tokens to get http data. The place I would like to grab data has the process of authentication is performed by doing a call for receiving a token.

  • @andersjensenorg

    @andersjensenorg

    3 жыл бұрын

    Hey Christopher. Thanks for the question. At the moment, I’m on paternity leave, meaning I don’t produce videos and solve problems until the 23rd of August. Feel free to post the problem at my Discord, where many bright automation minds are gathered: kzread.info/dron/Pdtz4gd_iYebJFYq9N8pWA.htmlcommunity?lb=UgxD1Qe9lWKL1I7HyAJ4AaABCQ Kind regards, Anders

  • @arslanarif3403
    @arslanarif34032 жыл бұрын

    Hello Mr. Anders, this is very helpful for us, I am attempting something simialar with PayPal developer account. Do you have any experience connecting to a PayPal sandbox api? Regards, Sunny

  • @andersjensenorg

    @andersjensenorg

    2 жыл бұрын

    Hey Sunny Man Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzread.info/dash/bejne/kYWGq4-Sn5XOaLg.html Have a great day. Kind regards, Anders

  • @omartalbi8183
    @omartalbi81833 жыл бұрын

    very clear tuto thanks , but can you tell me how to work with API with key ?

  • @andersjensenorg

    @andersjensenorg

    3 жыл бұрын

    Hey Omar. I am very sorry about the late reply 😞 Anyways you can specify it under queries in settings of the HTTP request 😊 Let me know, if you can't find it, I will show you. Kind regards, Anders

  • @omartalbi8183

    @omartalbi8183

    3 жыл бұрын

    @@andersjensenorg thanks sir , i already figured that

  • @andersjensenorg

    @andersjensenorg

    3 жыл бұрын

    @@omartalbi8183 Awesome 💪

  • @aravindadamarla
    @aravindadamarla3 жыл бұрын

    How to parse in case if the output of api is 'text' ?

  • @andersjensenorg

    @andersjensenorg

    3 жыл бұрын

    Hey Sri. It depends on the structure of the text. Is there a pattern? Kind regards, Anders

  • @minhvuongluu7644
    @minhvuongluu76443 жыл бұрын

    http call is premium though ! cannot do it :(

  • @andersjensenorg

    @andersjensenorg

    2 жыл бұрын

    Hey Minh Vuong Luu Thanks for writing. I'm getting more than 40 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzread.info/dash/bejne/kYWGq4-Sn5XOaLg.html Have a great day. Kind regards, Anders

  • @chandanmaity
    @chandanmaity9 ай бұрын

    Do I need a premium version for this?

  • @andersjensenorg

    @andersjensenorg

    9 ай бұрын

    No 😊

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

    key video.

  • @andersjensenorg

    @andersjensenorg

    Жыл бұрын

    Thanks a lot, Data 😎

  • @-Tristan-
    @-Tristan-2 жыл бұрын

    Is there also an example for HTTP POST to another apps API?

  • @andersjensenorg

    @andersjensenorg

    2 жыл бұрын

    Hey Tristan Thanks for writing. I'm getting more than 50 questions/comments every day and having difficulty answering everyone (I try my best). I've created my Microsoft Power Automate Groups, where we all can post and solve problems or hang out around our favorite tool, Power Automate. So you're very welcome. Get the addresses here: kzread.info/dash/bejne/kYWGq4-Sn5XOaLg.html Have a great day. Kind regards, Anders