Need Urgent Help - Parsing XML with multiple attributes and namespaces

Hi All,

I am getting below error when I try to select the xmlnodelist from a xml that contains namespaces and multiple attributes.

Error: Namespace Manager or XsltContext needed. This query has a prefix, variable, or user-defined function.

The xpath I have used to select the nodes is as below.



I have attached the sample project as well. 

I have tried different xpaths that are discussed in the forum, but no help.

I have used this site to test my xml and xpath, I am able to see the result for the xpath I am passing, it is selecting the elements. However If I do it outsystems it throws the above error.

Could you check and help?

My ultimate aim will be select all the node elements of sdm:row and loop thru it to store the data.


Hi,


You are not providing the xsd, so the xmlParser cannot handle that.

If you don;t have a xsd or it still fails, you might want to strip the namespaces all together, then you could go for the xslt option.

see https://stackoverflow.com/questions/5268182/how-to-remove-namespaces-from-xml-using-xslt


good luck.


p.s. Adding "need urgent help" does not improve you chances to actually get help faster. So next time, please do not add it.


I don't have xsd file, hence I have generated the xsd from xml using  below link.

https://www.freeformatter.com/xsd-generator.html#ad-output

But still it is not helping. Getting the same error.