Parse XML

General
1

We have a very unique xml format where all the elements have “:” example as per below:

	<stk:code>1264240</stk:code>
				<stk:isSales>true</stk:isSales>
				<stk:isInternet>false</stk:isInternet>
				<stk:purchasingRateVAT>high</stk:purchasingRateVAT>
				<stk:sellingRateVAT>high</stk:sellingRateVAT>
				<stk:name>FILTEREINSATZ /160 D010 BH4HC</stk:name>
				<stk:nameComplement>5085,5130,5170</stk:nameComplement>

how can i read this format?
thanks

2

https://ask.streamsets.com/question/1435/cant-parse-xml-element-names-containing-colon/

Does this help? I have no first-hand experience and you are likely to get a more informed answer later.

3

I found this but it didn’t help

4

Well, uncheck the answered button and hope for better advice :slight_smile:

Sorry.

5

What do you need to do?
Loading is the same, navigation by node (firstChild, nextsibling etc) is the same.

If you want to use XQL you have to define the name space (stk) , there are tons of examples in this forum

6

In stk:code “stk” is the namespace… which should be declared at the top of the xml file. see: https://en.wikipedia.org/wiki/XML_namespace