Escaping characters in XML for a SOAP request

AitorEG · 2017-12-14

Hi everyone,

I have a little issue generating an XML. At first look, it seems that the XML is OK, but I find problem when I try to make a request with it.

The XML should have a field like this:

<collectionDateTime><![CDATA[2017-12-14T08:10:00]]></collectionDateTime>

I create the field in the XML like this:

lvl2XMlNode := XMLDocOut.createNode(1,'collectionDateTime','');
ConsigmentXMlNode.appendChild(lvl2XMlNode);
DomTextNode := XMLDocOut.createTextNode('<![CDATA[2017-12-14T11:35:00]]>');
lvl2XMlNode.appendChild(DomTextNode);

At the first look, I open the XML file with the briowser, and seems to be fine:

But the issue is that, this XML file is sent in a request in text format, and if I open it with the editor, I can see this:

collectionDateTime>&lt;![CDATA[2017-12-14T11:35:00]]&gt;</collectionDateTime>

So that provokes a marshalling error in the web service. How can I add the character correctly? I've tried to scape them in different ways, but i can't find the correct approach.

Any hint will be really appreciated.
Thanks!

Slawek_Guzek · 2017-12-14

sorry, my bad. <![CDATA[]]> is valid XML. It just cannot be added as a regular node.

check this:
https://msdn.microsoft.com/en-us/library/system.xml.xmldocument.createcdatasection(v=vs.110).aspx

logger · 2017-12-14

@AitorEG ,
Try

cdata := '2017-12-14T11:35:00';

Also, I guess, instead

lvl2XMlNode.appendChild(DomTextNode);

should be

lvl2XMlNode.appendChild(newCDATA);

Slawek_Guzek · 2017-12-14

You cannot have < or > inside the node value, that's why it has been escaped

This:

is invalid XML.

logger · 2017-12-14

Hi @AitorEG ,
Have you already tried to use next articles to create CDATA?
https://stackoverflow.com/questions/4679543/how-to-write-cdata-in-xml
https://msdn.microsoft.com/en-us/library/system.xml.xmldocument.createcdatasection.aspx

Slawek_Guzek · 2017-12-14

sorry, my bad. <![CDATA[]]> is valid XML. It just cannot be added as a regular node.

check this:
https://msdn.microsoft.com/en-us/library/system.xml.xmldocument.createcdatasection(v=vs.110).aspx

AitorEG · 2017-12-14

Thanks for your help.

I am doing this noe:

lvl2XMlNode := XMLDocOut.createNode(1,'collectionDateTime','');
ConsigmentXMlNode.appendChild(lvl2XMlNode);
cdata := '<![CDATA[2017-12-14T11:35:00]]>';
newCDATA := lvl2XMlNode.ownerDocument.createCDATASection(cdata);
//DomTextNode := XMLDocOut.createTextNode('<![CDATA[2017-12-14T11:35:00]]>');
lvl2XMlNode.appendChild(DomTextNode);

And I receive this error:

"Error in the call to System.__ComObject.CreateCDataSection with the message: No valid data por a node of type 'CDATA'"

I've used the approach found in
https://forum.mibuso.com/discussion/comment/310306#Comment_310306

logger · 2017-12-14

@AitorEG ,
Try

cdata := '2017-12-14T11:35:00';

Also, I guess, instead

lvl2XMlNode.appendChild(DomTextNode);

should be

lvl2XMlNode.appendChild(newCDATA);

AitorEG · 2017-12-14

Thanks, now It's working,

I'm creating the node this way:

lvl2XMlNode := XMLDocOut.createNode(1,'collectionDateTime','');
ConsigmentXMlNode.appendChild(lvl2XMlNode);
cdata := '2017-12-14T11:35:00';
newCDATA := lvl2XMlNode.ownerDocument.createCDATASection(cdata);
lvl2XMlNode.appendChild(newCDATA);

The service is still returning me an error, but al least, this step is solved.

Thank you very much to both of you!

Howdy, Stranger!

Quick Links

Categories

Escaping characters in XML for a SOAP request

Best Answers

Answers