Send API POST Requests in Excel with Power Query

In this video we're going to learn how we can send a POST request in Power Query.

API service:

Check out my full courses and ebooks here

DOWNLOAD the example workbook here

SUBSCRIBE & get my 3 FREE eBooks

CONNECT with me on social

Thanks for all your support!

[wayneedmondson]

Hi John.. thanks for this video. Always something new and interesting coming from How To Excel. Thumbs up!!

[JoshOntko]

Thank you for the video! Is it possible to reference specific cells for the variable values instead of hard coding it? For example city=A12.

[darrylmorgan]

WOW!Just Learned Something New Again..Thank You John :):)

[caliban]

Hello great video!
Do you know what is the sytanx in case my API needs a bearer token?
Thx!

[abe]

This example sounds more like a GET function than POST.

[tuyoexcelypowerbi]

Great video!!!! I use this technique with VBA but it's nice to know Power Query can do it too

[raphaelbonillo]

Hi! Is possible to logged in in a prompt window?

[DaeViZn]

What if I want to send a complete table (transactions on record line item level) so they can be consumed by an API? Some kind of for each loop?

[DhasseLOL]

Thanks, great video. Is it in any way possible to feed keys and parameters into the api requests from normal excel cells? What I'm after is being able to enter coordinates into a table in Excel, press a button that calls the API using the data in the table as parameters. The idea is to set up a spreadsheet that doesn't require the user to engage with complicated API requests. I'm completely new to APIs so I don't know if what I'm asking is ridiculous, sorry...

[actsoftpsdept]

Excellent video! How would the Json.FromValue function be formatted if the json body contains another json object? ex. {"id":123, "params":{"name":"John"}}

[jaffrolaws]

Hi, would you know how to get API data from Advanced REST client to excel (i have no programming background) - theres so many things i want to build in excel, i just need need the data - thanks

[pswork]

How to pass dynamic data like referencing cell value in the body?

[NS-tpvr]

How we can access api data into an excel having bearer token?

[kadirkkkk]

I'm triying microsoft token api connection and the "source" part is my problem. Giving parameters like that does not work, i dont know why. I'm not so experienced about api things. may be it's because MS wants the but not application-json

[santoshkamala]

Very good one. I have one question, I can see your power query is having some feature where you type M query, it’s giving some suggestion and meaning. In my power query, I have type exact formula with case sensentive, else it shows error. Could you please help me, how you fix that !!!

Mean to ask - Your advance editor in power query is having nice color code and different feature

[rajasharma]

I'm using Excel Ver 16 ( Office 365 ), how can i accomplish this in that ?

[Chrislybears]

How is this video showing POST Requests? The example shown in the video is a GET Request to an API as it just gets data from a JSON API without posting anything back.

[priscillachang]

My Excel's Advanced Editor is greyed out. What am I missing?

[KyleDelaney]

This is an anonymous request. How would you build a API call that requires an authorization?

[ukhg]

You mean send a GET Request, this is not a POST