PUT request using WebAction.Request

[nathan2399]

I've been trying to setup a simple PUT request to an API with no success. The API itself works as intended, used Postman to request the data. GET/POST requests are working fine with PowerQuery.

let

  BaseUrl = "https://stackoverflow-63122537.herokuapp.com/demo"
  BaseHeaders = [#"Content-Type"="application/json"],
  JsonBody = Json.FromValue([A = 1, B = 2]),

  Count = 
    WebAction.Request(
      "PUT",
      BaseUrl,
        [
          Headers = [ BaseHeaders ],
          Content = JsonBody
        ]
    )
  
in
  Count

---

Expected:

Count should return a number.

---

Actual result:

PowerBI reports "Object reference not set to an instance of an object"

[Anonymous]

Hi @nathan2399 

As the URI in a POST request identifies the resource that will handle the enclosed entity... In contrast, the URI in a PUT request identifies the entity enclosed with the request, i would go witht the POST Request.

Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!

Regards,
Pranit

[nathan2399]

Thanks for the input Pranit, and I would if I could but sadly the API uses POST for other ops while PUT returns counts (for some reason).