#"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",) #"Converted to Table" = Record.ToTable(Source), Here is the query that you need to write: let Now that we have the data, we will load it into Power Query, make the request and then transform the content sent back to us. I purposely kept the JSON object simple so we can follow along more easily. The second row is a sample of the JSON object that will be sent along in the request. One will define the URL we will be requesting. Note that this Excel Table contains two rows. To make this work, we need to define a table in our Excel Spreadsheet. The idea behind this is to mimic sending data to an API and then sending it back to the user. Here are the steps we need to complete to send a POST Request in Power Query:įor our example, we will be sending data to an Azure Function I defined on Microsoft Azure. To perform a POST request in Power Query, we need to do a few extra steps to make sure the request is sent successfully. ![]() The JSON Object could be data that we want to post to a website like Facebook or data we may want to insert into a database. The content is usually, but not always, in the form of a JSON object. With a "GET" request, we could easily build the URL in an Excel Spreadsheet, load the URL into Power Query, and then make the request using the "From Web" function.įor a POST request, we are no longer just requesting a URL instead, we are sending data along with our request. With a GET request, we are usually building a URL and specifying some parameters to help us filter the data sent back to us.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |