CODEWITHSUNDEEP
xmlapipostpowerbipowerquery
Nicole P
Nicole P

Reputation: 3

POST http(s) request with XML content to Power BI

I'm trying to post the XML request (in the first XML body) to the https link in the picture below on Power BI (as a data source). The bottom XML body is what I should be getting back. I have seriously gone through the depths of google to find a solution, but I'm having a lot of trouble. Any help would be much appreciated. screenshot from Postman

Pic of Advanced Editor Query

Token Comma Expected Error

Upvotes: 0

Views: 1699

Answers (1)

Wedge
Wedge

Reputation: 1826

I can't test or help with specifics of how the XML request itself should properly be setup, but I believe to enter it into Web.Contents it would look something like this. I think the XML request should just be setup as a string and then you use Text.ToBinary in the Content field of Web.Contents.

content = "<?xml version=""1.0""?>
<Kronos_wfc version=""1.0"">
<Request Object=""System"" Action = ""Logon"" etc, etc ",

Source = Xml.Tables(Web.Contents("XmlService", [Headers=[#"content-type"="text/xml"], Content=Text.ToBinary(content)]))

Upvotes: 1

Related Questions