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?
