Send API POST Requests in Excel with Power Query

[@abe4214]

This example sounds more like a GET function than POST.

[@markblabla6875]

Thought the same

[@DeadJDona]

because this is a clickbait video without any helpful information

[@wayneedmondson1065]

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

[@HowToExcelBlog]

There's airways something new and interesting to do! 👍 Microsoft is keeping all of us busy with all these great tools.

[@darrylmorgan]

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

[@HowToExcelBlog]

Glad to hear Darryl 👍

[@1984Negi]

Thank you for sharing this video ❤️. Learned something new. Can you please share How to use Yammer API as well in your upcoming videos ?

[@tuyoexcelypowerbi]

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

[@HowToExcelBlog]

I avoid VBA these days 😉

[@pswork9435]

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

[@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.

[@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.

[@HowToExcelBlog]

I haven't tried, but maybe name the cell City and reference that in your LAMBDA formula.

[@MarkWernsdorfer]

hello josh! did you find a solution? did the lambda referencing work? have a great day!

[@NS-tp3vr]

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

[@DaeViZ0n3]

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?

[@caliban2313]

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

[@HowToExcelBlog]

Try looking at the advanced settings when you use a web query from the UI, it might be there.

[@ukhg]

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

[@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 "content-type=application/x-www-form-urlencoded" but not application-json

[@actsoftpsdept8157]

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

[@seanandrachelkelly7744]

did you ever figure this out? I'm looking to do the same thing.

[@santoshkamala4548]

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

[@Amr-Ibrahim-AI]

Check this article. Seems like you need to be on Office 365 www.excelguru.ca/blog/2019/07/17/power-query-intellisense-and-highlighting-in-excel/

[@jaffrolaws3165]

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

[@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...

[@HowToExcelBlog]

You can set up a parameter table. kzbin.info/www/bejne/qZW1Y3V_Z8poj5o

[@DhasseLOL]

@@HowToExcelBlog Great, I'll check it out! Still stuck on the contents of this video though haha... Can you spot any obvious error in the code? I have replaced my API key in the code below. Here is my query that results in error 400 bad request: Edit: I figured it out, I had formatted the list in the content according to JSON instead of Power Query. Now it works flawlessly. Once again, thanks for the video!

[@ExcelExciting]

Great Tip :) thanks for sharing

[@priscillachang5353]

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

[@raphaelbonillo2192]

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

[@HowToExcelBlog]

I think you're out of luck.

[@raphaelbonillo2192]

@@HowToExcelBlog Should I understand your comment like it is not possible? If so, thank you anyway. My problem is that I am trying to consume an OAuth2 type API and in one of the steps a floating window appears asking for a login and password.

[@rajasharma5255]

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

[@HowToExcelBlog]

Yep, 365 is what I use.

[@KyleDelaney21]

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

[@HowToExcelBlog]

Depends on the authorization type

[@HowToExcelBlog]

Auth is passed through URL in this example, but you can also pass it through the header.

[@JimmySailor]

Good video but incorrect title, this isn't a POST request at all.

[@DeadJDona]

just curious, is there a single person who got help from this video? really, at 1:30 we see clicks on a few buttons, then we got some DETAILED EXPLANATION OF BASIC TEXT EDITING, then at 2:25 author casually switches to some completely new app that appears on the screen first time, still casually calls it "Excel" (WTF?), and provide detailed explanations on HOW TO EDIT TEXT, LIKE ON REALLY DAMN COPYPASTING. jeeeeeez another "how to copypaste into unknown" video

[@ПавелСальков-в6з]

It's POST-request! Not GET!