POSTing an XML file/contents as a request to an API endpoint

[CoolP]

Hello Experts,

I'm able to pass an XML file (multipart/form-data) to an API endpoint paramter (xmlRequest) using the POST method and get the response in a csv file/records.

The above worked using Postman and also via Python.

How to do this in Power Query / M?

I have tried to do it using "Web.Contents" method and by passing the XML data to the "Content" attribute with no luck.

Thanks

CoolP

[zoloturu]

Hello @CoolP,

I have an example of POST request:

let
    strBody = "[{""Text"":""" & Text.Replace(varInputText,"""","'") & """}]",
    Source = Web.Contents("https://api.cognitive.microsofttranslator.com/translate?api-version=3.0&to=en", [Headers=[#"Ocp-Apim-Subscription-Key"="11111111111111111", #"Content-type"="application/json"], Content=Text.ToBinary(strBody)])
in
    Source

The logic here is:

* to use Content=Text.ToBinary(), so then your GET request will be transformed to POST

* to have strBody variable which stores content you want to send via POST request

Some information about this approach - https://blog.crossjoin.co.uk/2014/04/19/web-services-and-post-requests-in-power-query/

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!