Advanced Editor - defined variable inside Text.ToBinary

[cleon169]

I'm rather new to M code. I'm trying to get the current date as a variable to appear inside this XML API call that is wrapped up in a Text.ToBinary function. Any suggestions?

let

defined = DateTime.ToText(DateTime.LocalNow()),

Source = Xml.Tables(Web.Contents("https:...ReportingWs.asmx?WSDL"

,[Content=Text.ToBinary("<soapenv:Envelope xmlns:soapenv="&Character.FromNumber(34)&"http://schemas.xmlsoap.org/soap/envelope/"&Character.FromNumber(34)&" xmlns:rep="&Character.FromNumber(34)&"http://...ReportingWs"&Character.FromNumber(34)&">
<soapenv:Header/>
<soapenv:Body>
<rep:ConsolidatedReport>
<rep:sLocationCodesCommaDelimited>L001,L002</rep:sLocationCodesCommaDelimited>
<rep:sCorpUserName>...</rep:sCorpUserName>
<rep:sCorpPassword>...</rep:sCorpPassword>
<rep:dReportDateStart>2018-04-01T00:00:00</rep:dReportDateStart>
<rep:dReportDateEnd>defined</rep:dReportDateEnd>
</rep:ConsolidatedReport>
</soapenv:Body>
</soapenv:Envelope>"),Headers=[#"Accept-Encoding"="gzip,deflate", #"Content-Type"="text/xml;charset=UTF-8"]]))
in
Source

[Anonymous · Accepted solution]

I am not familliar with that function but it seems that you have done a simmilar thing already in the fucntion. Have you tried the same technique you used earlier? ("&Character.FromNumber(34)&") 

That is instead of 

<rep:dReportDateEnd>defined</rep:dReportDateEnd>

<rep:dReportDateEnd>" & defined & "</rep:dReportDateEnd>? 

[cleon169]

Thanks ThisIsFalse. I had been trying to use "Character.FromNumber(34)&"Defined"&Character.FromNumber(34)" as I incorrectly thought it needed to be in double quotes. I also had the date variable formatted differently than the API required. Here's the line I used:

         <rep:dReportDateEnd>"&Defined&"</rep:dReportDateEnd>

[Anonymous]

Well  I am glad you got it sorted out. I felt that it was a little too simple the way you presented it, formatting is always an issue with this kind of thing.