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:

Month: June 2023

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

Copyright © 2022 | Md. Ismail Hosen

Freelance VBA Developer

Software Engineer, XYZ Cloud BD Ltd.

Quick Links

Resources

Support