Send API POST Requests in Excel with Power Query
HTML-код
- Опубликовано: 10 июл 2024
- In this video we're going to learn how we can send a POST request in Power Query.
API service:
smartystreets.com/products/ap... 👇
Check out my full courses and ebooks here
👉 www.howtoexcel.org/courses/
DOWNLOAD the example workbook here
📖 www.howtoexcel.org/downloads/
SUBSCRIBE & get my 3 FREE eBooks
📧 www.howtoexcel.org/newsletter/
CONNECT with me on social
Facebook: / howtoexcelblog
Twitter: / howtoexcelblog
LinkedIn: / john-macdougall
Thanks for all your support!
Hi John.. thanks for this video. Always something new and interesting coming from How To Excel. Thumbs up!!
There's airways something new and interesting to do! 👍 Microsoft is keeping all of us busy with all these great tools.
Great Tip :) thanks for sharing
WOW!Just Learned Something New Again..Thank You John :):)
Glad to hear Darryl 👍
Thank you for sharing this video ❤️. Learned something new. Can you please share How to use Yammer API as well in your upcoming videos ?
This example sounds more like a GET function than POST.
Thought the same
because this is a clickbait video without any helpful information
Great video!!!! I use this technique with VBA but it's nice to know Power Query can do it too
I avoid VBA these days 😉
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.
I haven't tried, but maybe name the cell City and reference that in your LAMBDA formula.
hello josh! did you find a solution? did the lambda referencing work? have a great day!
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
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.
Hello great video!
Do you know what is the sytanx in case my API needs a bearer token?
Thx!
Try looking at the advanced settings when you use a web query from the UI, it might be there.
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?
Excellent video! How would the Json.FromValue function be formatted if the json body contains another json object? ex. {"id":123, "params":{"name":"John"}}
did you ever figure this out? I'm looking to do the same thing.
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...
You can set up a parameter table.
ruclips.net/video/sdR2BI2e5Y8/видео.html
@@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!
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
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/
How to pass dynamic data like referencing cell value in the body?
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
Hi! Is possible to logged in in a prompt window?
I think you're out of luck.
@@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.
My Excel's Advanced Editor is greyed out. What am I missing?
I'm using Excel Ver 16 ( Office 365 ) , how can i accomplish this in that ?
Yep, 365 is what I use.
You mean send a GET Request, this is not a POST
This is an anonymous request. How would you build a API call that requires an authorization?
Depends on the authorization type
Auth is passed through URL in this example, but you can also pass it through the header.
Good video but incorrect title, this isn't a POST request at all.
It's POST-request! Not GET!
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