Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am having difficulty finding product documentation on Power Query that breaks down how to construct the body parameter within the Web.Contents() function when passing XML into the body of the HTTP POST request. I receive an error message of "We cannot convert a value of type Table to type Records".
For example, I have a set of 5 environmental variables that I want to pass into the xml before passing xml into function:
senderid = "Someusername"; senderidpassword = "somepassword"; userid = "anotherusername"; useridpassword = "anotherpassword"; companyid = "acompanyname";
I then want to pass in above variables to XML:
"<?xml version=""1.0"" encoding=""UTF-8""?> <request> <control> <senderid>"&senderid&"</senderid> <password>"&password&"</password> <controlid>{{$timestamp}}</controlid> <uniqueid>true</uniqueid> <dtdversion>3.0</dtdversion> <includewhitespace>false</includewhitespace> </control> <operation> <authentication> <login> <userid>"&userid&"</userid> <companyid>"&companyid&"{{temp_slide_in}}</companyid> <password>"&password&"</password> </login> </authentication> <content> <function controlid=""{{$guid}}""> <getAPISession /> </function> </content> </operation> </request>"
And I want to pass above XML into the Web.Contents() function code below:
let url = "https://examplewebsite.com", body = [Above XML formatted to pass into Web.Contents() function] , Parsed_XML = XML.Document(body), BuildQueryString = Uri.BuildQueryString(Parsed_XML), Source = XML.Document(Web.Contents(url,[Headers = [#"Content-Type"="application/xml"], Content = Text.ToBinary(BuildQueryString) ] )) in Source;
Any advice on how I need to pass in the variables to XML & then structure the XML body portion of the Web.Contents function?
Hi @SCHGroupDA
How about "Xml.Tables" instead of "Xml.Documents"?
You could use Xml Driver as a workaround.
Best Regards
Maggie