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
Check my Power Automate Beginners Tutorial, where all the basic stuff is covered - kzread.info/dash/bejne/oaGFj8h6dpe3oKw.html
Excellent video. Clear, concise and straight forward. Thank you!
@andersjensenorg
2 ай бұрын
Thank you so much for the kind words 🙌😊 Anders.
This is the perfect tutorial video: clear, concise, and demonstrates an easy way to do something really useful! Thanks so much.
@andersjensenorg
Жыл бұрын
Hey Feuch24. Thanks a lot 😊 Have a great day. Kind regards, Anders
Enjoyed understanding it, lovely. Thanks for sharing this!
@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
Precise & to the point. Thanks for sharing this video.
@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
This is cool and straight forward. Thank you.
@andersjensenorg
3 жыл бұрын
Hey Lukman. Thanks a lot :) Kind regards, Anders
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
2 жыл бұрын
Hey Tim. Nice to hear. Sometimes it do tricks with me as well :) Kind regards, Anders
Clear and precise, Good job ... ! Thanks++
@andersjensenorg
3 жыл бұрын
Thank you, Imtiaz 🙂
Thank you, you're a lifesaver!
@andersjensenorg
3 жыл бұрын
Thanks a lot for letting me know, Mirza 🙂
Nice video Anders, learned something new today
@andersjensenorg
2 жыл бұрын
You're very welcome, Dany - your support helps me a lot 😍
this is really powerful
@andersjensenorg
3 жыл бұрын
Hey thebestfella. Yeah, like it - let me know, if you have any questions or ideas for future videos. Kind regards, Anders
Thank you!!
@andersjensenorg
2 жыл бұрын
You're very welcome 🤗
thank you !
@andersjensenorg
3 жыл бұрын
Happy you could use it 😊
Cool Anders :)
@andersjensenorg
4 жыл бұрын
Mange tak 👍😊
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
Жыл бұрын
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
Thanks! How can you manage an incremental update?
@andersjensenorg
3 жыл бұрын
Hey Michael. Thank you 👍🙂 Can you specify, what you mean? Kind regards, Anders
@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
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
I have a case with non json response and cert authentication. Is that possible? What might I have to change?
@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
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
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
Is there any methods to make a file 'read-only' in SharePoint using power automate?
@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
is it possible to make url with http, because https is bad for my case. Thank you
@andersjensenorg
3 жыл бұрын
Hey Carlos. Thank you very much 😊 For sure, it's just the address. Kind regards, Anders
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
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
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
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
very clear tuto thanks , but can you tell me how to work with API with key ?
@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
3 жыл бұрын
@@andersjensenorg thanks sir , i already figured that
@andersjensenorg
3 жыл бұрын
@@omartalbi8183 Awesome 💪
How to parse in case if the output of api is 'text' ?
@andersjensenorg
3 жыл бұрын
Hey Sri. It depends on the structure of the text. Is there a pattern? Kind regards, Anders
http call is premium though ! cannot do it :(
@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
Do I need a premium version for this?
@andersjensenorg
9 ай бұрын
No 😊
key video.
@andersjensenorg
Жыл бұрын
Thanks a lot, Data 😎
Is there also an example for HTTP POST to another apps API?
@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