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:

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:

#powerautomate #api #excel

[JosephStreet-dkuw]

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

[Feuch]

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

[RaviKrishnaSrivastava]

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

[graycat]

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.

[deepanshsaxena]

Enjoyed understanding it, lovely. Thanks for sharing this!

[imtiazakhtar]

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

[Dany-nshg]

Nice video Anders, learned something new today

[soumyadeepmondal]

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!

[nathanagarwal]

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

[christopherjohnson]

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.

[CarlosestebanVargasMoreno]

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

[mshparber]

Thanks! How can you manage an incremental update?

[abhijithprabha]

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

[lotfiboucherit]

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!

[omartalbi]

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

[arslanarif]

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

[aravindadamarla]

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

[minhvuongluu]

http call is premium though ! cannot do it :(

[-Tristan-]

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