I would like to parse XML and put the value in the header. I am using cSetHeader for that.
This is how my XML looks like
<?xml version="1.0" ?> <ORDER xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <HEAD> <DOC_STATUS>3</DOC_STATUS> <DOC_NO>9300983009</DOC_NO> </HEAD> </ORDER>
and would like to set Header with XPATH(the expression: "/ORDER/HEAD/DOC_NO")
But in Header I get the value instead of 9300983009 I get something like ORDER_NO=com.sun.org.apache.xml.internal.dtm.ref.DTMNodeList@7ff63561}
How can I fix that?
My testing route looks like this:
Solved! Go to Solution.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.