How to parse an XML using JavaScript

Question

Here is my xml
&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;BasicExport xmlns="http://www.in.casds.com/SSR/XTI/Traffic/0011" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.uk.nds.com/SSR/XTI/Traffic/0011 0011_export.xsd" transactionIdentifier="585073235185"&gt;
	&lt;CaProductList&gt;
		&lt;CaProductItem&gt;
			&lt;caProductId&gt;00000007832&lt;/caProductId&gt;
			&lt;productType&gt;IPPV and OPPV&lt;/productType&gt;
			&lt;productTypeId&gt;3&lt;/productTypeId&gt;
			&lt;productStartDateTime&gt;2013/09/10 19:30:24:00&lt;/productStartDateTime&gt;
			&lt;productExpiryDateTime&gt;2038/04/22 00:00:00:00&lt;/productExpiryDateTime&gt;
		&lt;/CaProductItem&gt;
		&lt;CaProductItem&gt;
			&lt;caProductId&gt;00000007832&lt;/caProductId&gt;
			&lt;productType&gt;XTV and OPPV&lt;/productType&gt;
			&lt;productTypeId&gt;6&lt;/productTypeId&gt;
			&lt;productStartDateTime&gt;2013/09/10 19:30:24:00&lt;/productStartDateTime&gt;
			&lt;productExpiryDateTime&gt;2038/04/22 00:00:00:00&lt;/productExpiryDateTime&gt;
		&lt;/CaProductItem&gt;
		&lt;CaProductItem&gt;
			&lt;caProductId&gt;00000007833&lt;/caProductId&gt;
			&lt;productType&gt;IPPV and OPPV&lt;/productType&gt;
			&lt;productTypeId&gt;3&lt;/productTypeId&gt;
			&lt;productStartDateTime&gt;2013/09/10 23:04:07:00&lt;/productStartDateTime&gt;
			&lt;productExpiryDateTime&gt;2038/04/22 00:00:00:00&lt;/productExpiryDateTime&gt;
		&lt;/CaProductItem&gt;
		&lt;CaProductItem&gt;
			&lt;caProductId&gt;00000007833&lt;/caProductId&gt;
			&lt;productType&gt;XTV and OPPV&lt;/productType&gt;
			&lt;productTypeId&gt;6&lt;/productTypeId&gt;
			&lt;productStartDateTime&gt;2013/09/10 23:04:07:00&lt;/productStartDateTime&gt;
			&lt;productExpiryDateTime&gt;2038/04/22 00:00:00:00&lt;/productExpiryDateTime&gt;
		&lt;/CaProductItem&gt;
	&lt;/CaProductList&gt;
&lt;/BasicExport&gt;
I would like to retrieve a value for&nbsp;caProductId[1]
Thanks

tristaanogre · Answer

What I've done in the past is create an instance of the MSXML2.DOMDocument object and do my parsing and examination that way. There are methods for "GetNode" and such built into that object that allows you to return all child nodes of a particular search pattern as an array that you can then navigate or reference by index.

See https://docs.microsoft.com/en-us/previous-versions/windows/desktop/ms754523%28v%3dvs.85%29

pravin_k99 · Answer

Sorry
The link seems to be broken. Would you be able to post your solution here please?
&nbsp;
Thanks

tanyayatskovska · Answer

Hi&nbsp;pravin_k99,
There is a great tutorial in the TestComplete documentation&nbsp;explaining how to work with XML files from script. Take a loot at it:
https://support.smartbear.com/testcomplete/docs/testing-with/advanced/working-with-external-data-sources/files/xml.html

tristaanogre · Answer

pravin_k99&nbsp;wrote:
Sorry
The link seems to be broken. Would you be able to post your solution here please?
&nbsp;
Thanks

The link is corrected... the page referenced gives some examples in JScript code.&nbsp; &nbsp;The link&nbsp;TanyaYatskovska&nbsp;provided gives some code examples as well.&nbsp; I don't have the code at my fingertips... that was at a different job so not immediately available and, unfortunately, I don't have time to reinvent it...

pravin_k99 · Answer

Thanks Robert and Tanya
&nbsp;
I wrote this piece of code but unfortunately, it works only when I remove namespaces from the XML.
&lt;BasicExport xmlns="http://www.in.casds.com/SSR/XTI/Traffic/0011" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.uk.nds.com/SSR/XTI/Traffic/0011 0011_export.xsd" transactionIdentifier="585073235185"&gt;

REPLACED with

&lt;BasicExport&gt;
&nbsp;
function FirstValue()
{
  var Doc, s, Nodes, ChildNodes, i, Node;
  Doc = getActiveXObject("Msxml2.DOMDocument.6.0");
  Doc.async = false;
  Doc.load("C:\mytest.xml");

if(Doc.parseError.errorCode != 0)
  {
    s = "Reason:	" + Doc.parseError.reason + "
" +
        "Line:	" + aqConvert.VarToStr(Doc.parseError.line) + "
" + 
        "Pos:	" + aqConvert.VarToStr(Doc.parseError.linePos) + "
" + 
        "Source:	" + Doc.parseError.srcText;
    Log.Error("Cannot parse the document.", s); 
    return;
  }
  
  Nodes = Doc.selectNodes("//caProductId");
  Log.Message(Nodes.item(1).childNodes.item(1).text);

}
&nbsp;
Though there is an example for namespace based XML. My XML seems to have namespace only in the first tag and then the rest of the xml doesnot use the namespace.
&nbsp;
Can you please help?

Forum Discussion

How to parse an XML using JavaScript

Recent Discussions

Windows 11 O.S. - Test Execute not correctly running

How to run failed BDD scenarios automatically?

A floating license among two machines

Related Content

Parse a JSON Response Using Groovy

How to parse JSON in javascript

Copy and rename a file using JavaScript