Month: June 2023

I am sure you have rarely used this or know about this. Yes, You can use the POST HTTP method using Web.Contents. We can only use the GET and POST method using Power query. Other REST API method(PUT,DELETE,PATCH,UPDATE etc) is not possible. And this post is about the POST Method. We are going to discuss the Content option in this post. Content is basically the body of the POST Method. Whatever you specify in the Content will be used as a body. Here is a sample code. Content Param/Post Method Example.pq Code: let JSONBody = "{""name"": ""Md.Ismail Hosen""}", Source = Web.Contents( "https://postman-rest-api-learner.glitch.me/info", [ Content = Text.ToBinary(JSONBody), Headers = [Accept = "*/*", #"Content-Type" = "application/json"] ] ), ConvertedToTable = fxJsonBinaryToTable(Source, true, ".") in ConvertedToTable As a body, I have used the JSONBody step here. I want you to look into the Content field. If you look carefully then you will find that we are using Text.ToBinary to convert body json to a binary format. So make sure you use Text.ToBinary when you want to use the Content option. Here is the sample output of that API Call:

Excel VBA Programming – The Complete Guide

Excel

Excel VBA & Scripts

Formulas

Power Query

Python

Outlook + Excel VBA

Others

Free Guide

The ONE Critical Excel Skill You Need

Month: June 2023

Secret Power Of Web.Contents PQ Function: Options[Content] Parameter – Part 5

Excel VBA Programming – The Complete Guide

Free Guide

The ONE Critical Excel Skill You Need

Stay Ahead with Weekly Insights!

Dive into Excel, Al and other essential tech news:

carefully crafted for the modern professional.