XML-110018 Error while parsing XML string

[AnasSpir05]

Hi,
I'm trying to read a variable and I get this error "XML-110018 Error while parsing XML string" here is my code : 

 var query = xtk.queryDef.create(
      <queryDef schema="xtk:schema" operation="select" lineCount="1">      
        <select>       
          <node expr="data" alias="data"/>
        </select>
        <where>
          <condition expr={"@namespace='nms'"}/>
          <condition expr={"@name='recipient'"}/>
        </where>     
      </queryDef>);
    var queryResult = query.ExecuteQuery(); // START QUERy
logInfo("Data type :"+ typeof queryResult[0].data);

var xml = new DOMDocument.fromXMLString(queryResult[0].data.toXMLString());
var tag = xml.getElementsByTagName("attribute")[0];

[LakshmiPravallika]

Hi @AnasSpir05 ,

Please check  the below part given in your code highlighted in yellow colour:

It should be having "@data "instead of "data" . Please cross check this and run it again.

Regards,

Pravallika.

[AnasSpir05]

hi @LakshmiPravallika ,

thank you for your reply but it still doesn't work and in the data schema it has the type memo with the tag element not attribute.

[LakshmiPravallika]

Hi @AnasSpir05 ,

Instead of trying to call the variables directly(replace last 3 lines with below), try using for each loop and print them as below:

for each (var row in queryResult)
{
logInfo("data printing "+row.data);

}

[adobechat]

Hi,

Need more context but try this 

var query = xtk.queryDef.create(
    <queryDef schema="xtk:schema" operation="select" lineCount="1">      
      <select>       
        <node expr="data" alias="data"/>
      </select>
      <where>
        <condition expr="@namespace='nms'"/>
        <condition expr="@name='recipient'"/>
      </where>     
    </queryDef>
);

var queryResult = query.ExecuteQuery(); // START QUERY
logInfo("Data type :"+ typeof queryResult[0].data);

var xmlString = queryResult[0].data.toXMLString();

logInfo("XML String : " + xmlString);

var xml = new DOMDocument.fromXMLString(xmlString);
var tag = xml.getElementsByTagName("attribute")[0];

Hope it works.

Thanks

Madhan

[isahore · Accepted solution]

Hi @AnasSpir05,

Change your line to this:

var xml = DOMDocument.fromXMLString("<?xml version='1.0'?> " + queryResult.schema[0].toString());

This will populate your "tag" variable without error.

Thanks,

Ishan

[jjwatson79]

@isahore has addressed a few issues in that reply.

1. When executing your query, you will build a "schema" collection, rather than a "data" collection, which the original code assumes
2. The XML declaration is not always necessary, but is best practice.
3. The toXMLString is not necessary, but not problematic in this case. You can just use the toString function, because it will be constructed as an xml object anyway, because you're using the DOMDocument.fromXMLString function. Either approach works here, but I suspect there is less processing required just using toString rather than toXMLString.

[AnasSpir05]

Thank you for your help finaly it's work !