Making a POST Request Using Power Query
HTML-код
- Опубликовано: 30 июл 2024
- Power Query is a powerful application that allows you to mix and mash data to meet all your analysis needs. One of the useful features that Power Query offers is being able to make a web request with just a single function. In this video, we will explore how to make a specific type of web request called a POST request. With this type of request, we can send data to a website or even a database using Power Query.
Video Resources:
--------------------------------------------------
github.com/areed1192/sigma_co...
Resources:
--------------------------------------------------
Facebook Page: / codingsigma
Facebook Group: / sigmacoding
GitHub Sigma Coding: github.com/areed1192/sigma_co...
Support Sigma Coding:
--------------------------------------------------
Patreon: / sigmacoding
Amazon Associates: amzn.to/3bsTI5P **
Related Topics:
--------------------------------------------------
Title: M Programming Language: Introduction
Link: • M Programming Language...
Title: M Programming Language: Fundamentals
Link: • M Programming Language...
Title: M Programming Language Tutorial: Records
Link: • M Programming Language...
Title: M Programming Language: Working with Data Sources
Link: • M Programming Language...
Title: Using Custom Functions: Working with JSON
Link: • Using Custom Functions...
Title: Using Custom Functions: Making HTTPS Requests
Link: • Using Custom Functions...
Title: Using Custom Functions: Bulk HTTPS Requests
Link: • Using Custom Functions...
**Amazon Associates Disclosure:
--------------------------------------------------
I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel.
Tags:
--------------------------------------------------
#Mlanguage #PowerQuery #POSTRequest
WOW! Your content is amazing and genuinely helpful in practical applications, not just the regular tutorials with almost the same stuff.
I really liked this series!!
This is amazing thank you so much, I've been looking for a few days for exactly this, you should put in the title or the description that you are posting from excel cells, since most of the other tutorials don't, they post content from the Power Query lines of code which is sort of useless (you can do that in many other meaningful ways)
Dudeeee - thanks for posting!
I got this idea myself to avoid the PowerBI 'premium' API limitation and get data out of the reporting model and you just verified it's possible!
did you manage to do it ?
Actually ended up taking a different approach, figured out how to decode data from a power bi service dashboard tile without needing a premium subscription.
@@danbadenko Wow do you have a github repo for that ?
Thank you very much, just what I needed.
Thanks for the video. It really helps me.
Thanks for the video.
You are welcome!
Hi,
Thanks for the video. Would it be possible to do a post request using the salesforce connector (no url), and change a field based on another query with an unique key in found in both tables ? Most likely with an inner merge...
Edit: I don't understand where the column of the key, name of the key and value I want to replace are :(
Thank you for a great video! However, When copying you code (really step-by-step) I'm getting a Formula.Firewall error for MakePostRequest (step 'Source'). Any thoughts on why that may be?
Hi ,great video! One question, how to define in coding the following (in postman is including on the body part) as it is need for the post call ?{
"ResultType": "Hierachical",
"FilterConditions": [
{
"EntityName": null,
"Filter": null,
"Sort": null
}
],
"PageNumber": 1,
"PageSize": 25,
"ProjectionOnly": false,
"Parameters": {}
}
Hey i have an api i want to send request 1 Guid in body have 1 url and have 1 header how can i do that
This may be useful to some.
Content=Text.ToBinary("grant_type=client_credentials")
Now i just need to think of a way to get a new token when the current one expires
I like where you're going with this.
Do you have a solution already? I'm thinking I need to have a separate Azure Function to request a token first and store that one in a parameter.
@@florianpieront3296 if you are asking about checking if the token has expired or not, i don't think it will work on excel as every time when the token expired, excel will pop up a screen saying unable to authenticate. "Try and otherwise" doesn't bypass this pop up.
My solution was to try if the token allow me to run the api, if yes, return the original token, otherwise get a new token. The source will be the excel table output from this query, thus it will be a loop.
@@florianpieront3296 another way is to add a new column for the timestamp of when the token is received. Then use this excel table as the source to do a loop.
Let's say your token expires every 2 hours, your query will be if timestamp is less than current time-2hrs, then get a new token and timestamp, else return the source.
Thanks for the video - i was able to replicate and it works for my purposes. One question though - I need to be able to post an array of lists of records (relevant step at 10:55), where you add in {0} to get the first values out of the list. Can you please help? I am learning through a LOT of trial and error (mostly error haha).... any assistance would be extremely appreciated. Thank you again!
Awesome video! It helps me a lot.. Now can you please tell me how I can post multiple numbers of 'Access_Token'...? Here you have showed only one...will it be comma separated..? like...'12345678', '154789632', ' 1215468963'......like this..?