Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

PUT request using WebAction.Request

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"

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous 

     

    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

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      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).