Forum Discussion

dpombal's avatar
dpombal
Post Partisan
6 years ago
Solved

HTTP POST request with form urlencoded data

Hi all,   I am trying to reproduce below API HTTP Post call , successful in Postman: Postman configuration Authorization key with a tokensequence Body with 3 parameters and important select opt...
Need Help
  • dpombal's avatar
    dpombal
    6 years ago

    This option worked finally for me, will try to make code better using parameters, but is is a good start.

     

    CODE OK

    let
    auth_key ="XXXXXXXXXXXXXXXXXXX",
    base_url = "www.hostname.com",
    extension = "/api/datos_de_recarga/chargedata.php",
    url = base_url &extension,
    header= [#"Authorization" = auth_key,
    #"Content-Type" = "application/x-www-form-urlencoded"],
    content1= "[email protected]&PASSWORD=XXXXXX&INICIO=2019-11-01T00:00:00Z",
    webdata1 = Web.Contents(url, [Headers=[#"Authorization" = auth_key,
    #"Content-Type" = "application/x-www-form-urlencoded"],Content = Text.ToBinary(content1)]),
    response1 = Json.Document(webdata1)
    in
    response1

dpombal's avatar
dpombal
Post Partisan
6 years ago

can you assist me? i tried my characters with and without encoding...think this is not my current issue

where to use Uri.BuildQueryString(record)

artemus's avatar
artemus
Microsoft Employee
6 years ago

First change

content1= "{
""LOGIN"":""[email protected]"",
""PASSWORD"":""PASS"",
""INICIO"":""2019-11-01T00:00:00Z""
}",

 

to

 

content1 =

[

   LOGIN = "[email protected]",

   PASSWORD = "PASS",

   INCIO = #datetimezone(2019, 11, 1, 0, 0, 0, 0, 0)

]

 

then change:

Text.ToBinary(content1)

with

Text.ToBinary(Uri.BuildQueryString(content1))

  • dpombal's avatar
    dpombal
    Post Partisan
    6 years ago

    This option worked finally for me, will try to make code better using parameters, but is is a good start.

     

    CODE OK

    let
    auth_key ="XXXXXXXXXXXXXXXXXXX",
    base_url = "www.hostname.com",
    extension = "/api/datos_de_recarga/chargedata.php",
    url = base_url &extension,
    header= [#"Authorization" = auth_key,
    #"Content-Type" = "application/x-www-form-urlencoded"],
    content1= "[email protected]&PASSWORD=XXXXXX&INICIO=2019-11-01T00:00:00Z",
    webdata1 = Web.Contents(url, [Headers=[#"Authorization" = auth_key,
    #"Content-Type" = "application/x-www-form-urlencoded"],Content = Text.ToBinary(content1)]),
    response1 = Json.Document(webdata1)
    in
    response1

    • brettgriffiths's avatar
      brettgriffiths
      New Member
      3 years ago

      Wow, thanks so much for posting this...I spent some time in trying to get to this and your post had the final bit of info I needed. Many thanks 🙂