Xml help - probably CDATA[

HCL Domino Domino Forum
1

Summary - I call a Web Service Initialise function and get returned a token that I can then use to call other functions.

The token is returned correctly and is a string of about 1000 characters. However, when I try and use the token I get error: “Input string was not in a correct format”.

My code is shown below:

Dim objHttp As Variant

Dim mysoap As String

Dim SoapServer As String

Dim strToken As String



Set objHttp = CreateObject("Microsoft.XMLHTTP")

SoapServer = "http://nayrhsincmgt4/ParisTest.Net/WebServices/InternetPayments.asmx"



MySoap = {<?xml version="1.0" encoding="utf-8" ?>}

MySoap = Mysoap & Chr(10) & {<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">}

MySoap = Mysoap & Chr(10) & {<soap:Body>}

MySoap = Mysoap & Chr(10) & {<GetDetails xmlns="http://tempuri.org/">}

MySoap = Mysoap & Chr(10) & {<sToken>}

MySoap = Mysoap & Chr(10) & {<![CDATA[} & strToken

MySoap = Mysoap & Chr(10) & {]]>}	

MySoap = Mysoap & Chr(10) & {</sToken>}

MySoap = Mysoap & Chr(10) & {</GetDetails>}

MySoap = Mysoap & Chr(10) & {</soap:Body>}

MySoap = Mysoap & Chr(10) & {</soap:Envelope>}



objHttp.open "POST", SoapServer, False, "", ""

objHttp.setRequestHeader "Content-type", "text/xml; charset=utf-8"

objHttp.setRequestHeader "SOAPAction", "http://tempuri.org/GetDetails"



objHttp.send(mySoap)

When I print the string mySoap it is as it should be (the desired xml was supplied). I think it may be something to do with CDATA as the call to Initialise works and this has no data added to CDATA.

If it’s any use, here is the xml string for the working Initialise function:

MySoap = {<?xml version="1.0" encoding="utf-8" ?>}

MySoap = Mysoap & Chr(10) & {<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">}

MySoap = Mysoap & Chr(10) & {<soap:Body>}

MySoap = Mysoap & Chr(10) & {<Initialise xmlns="http://tempuri.org/">}

MySoap = Mysoap & Chr(10) & {<ID>}

MySoap = Mysoap & Chr(10) & {<![CDATA[  ]]> }

MySoap = Mysoap & Chr(10) & {</ID>}

MySoap = Mysoap & Chr(10) & {</Initialise>}

MySoap = Mysoap & Chr(10) & {</soap:Body>}

MySoap = Mysoap & Chr(10) & {</soap:Envelope>}

Does anyone have any ideas or suggestions.

Thanks.

2

Subject: xml help - probably CDATA[

Well, I will assume everything else is set up OK since you seem to be able to call the function and get a reply, so I will go with the easiest first…

You’ve declared the variable strToken, but you’ve seemingly given it no value. I don’t think the CDATA is the issue in this case.

3

Subject: RE: xml help - probably CDATA[

Brendan, thanks for responding.

StrToken is a string of around 1000 characters that is returned when I call the Initialise function. Sorry for the confusion but I did not want to over complicate this post.

Basically, I can use CDATA if there is no parameter but if there is a parameter then it doesn’t work. As I said, I know what the xml string should be.

Lets say I was to send the following string to the server:

<?xml version="1.0" encoding="utf-8" ?>

<soap:Envelope xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=“http://www.w3.org/2001/XMLSchema” xmlns:soap=“http://schemas.xmlsoap.org/soap/envelope/”>

soap:Body

</soap:Body>

</soap:Envelope>

I would build the string as follows:

strToken = “00019D0B”

MySoap = {<?xml version="1.0" encoding="utf-8" ?>}

MySoap = Mysoap & Chr(10) & {<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">}

MySoap = Mysoap & Chr(10) & {<soap:Body>}

MySoap = Mysoap & Chr(10) & {<GetDetails xmlns="http://tempuri.org/">}

MySoap = Mysoap & Chr(10) & {<sToken>}

MySoap = Mysoap & Chr(10) & {<![CDATA[} & strToken

MySoap = Mysoap & Chr(10) & {]]>}	

MySoap = Mysoap & Chr(10) & {</sToken>}

MySoap = Mysoap & Chr(10) & {</GetDetails>}

MySoap = Mysoap & Chr(10) & {</soap:Body>}

MySoap = Mysoap & Chr(10) & {</soap:Envelope>}

If I now msgbox this string (MySoap) it looks correct but does not work. I suppose my question is - does domino add anything extra to CDATA or is it anything to do with the string being long (about 1000 characters). I have just used a short string above by way of an example.

Thanks.

4

Subject: RE: xml help - probably CDATA[

Two thoughts:

  1. You’re adding wihtespace (i.e. LF characters) in your sToken Tag and the CDATA section. While the web service may probably tolerate the extra whitespace in the sToken tag, it will definitely not like the extra LF in the CDATA section. Update your code to:

MySoap = Mysoap & Chr(10) & {}

MySoap = Mysoap & {<![CDATA[} & strToken

MySoap = Mysoap & {]]>}

MySoap = Mysoap & {}

  1. Depending on the data of the token (does it contain non-ascii stuff?) you may want to ensure you’re printing the data with the same encoding specified in the XML header. (Lotusscript does not print UTF-8).

cheers,

Bram

5

Subject: RE: xml help - probably CDATA[

Thanks Bram. The xml code that was supplied to me does have spaces in it but I think you may be correct.

I removed the spaces but got another error:

“Index and length must refer to a location within the string”

I will now investigate this error.

Thanks.

6

Subject: RE: xml help - probably CDATA[

Solved. Bram was right about the spaces but I also had to remove Chr(10) references from my xml string when calling the GetDetails function i.e. when there was data in CDATA.

The Chr(10) commands did not cause a problem when calling the Initialise function (CDATA was empty).

Posting this as it may be useful for someone.