<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Unable to parse XML with XPATH and put it to Header with cHeader component in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Unable-to-parse-XML-with-XPATH-and-put-it-to-Header-with-cHeader/m-p/2299927#M72214</link>
    <description>&lt;P&gt;I would like to parse XML and put the value in the header. I am using cSetHeader for that.&lt;/P&gt; 
&lt;P&gt;This is how my XML looks like&lt;/P&gt; 
&lt;PRE&gt;&amp;lt;?xml version="1.0" ?&amp;gt;
&amp;lt;ORDER xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&amp;gt;
	&amp;lt;HEAD&amp;gt;
		&amp;lt;DOC_STATUS&amp;gt;3&amp;lt;/DOC_STATUS&amp;gt;
		&amp;lt;DOC_NO&amp;gt;9300983009&amp;lt;/DOC_NO&amp;gt;
	&amp;lt;/HEAD&amp;gt;
&amp;lt;/ORDER&amp;gt;&lt;/PRE&gt; 
&lt;P&gt;and would like to set Header with XPATH(the expression: "/ORDER/HEAD/DOC_NO")&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;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}&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;How can I fix that?&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;My testing route looks like this:&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled2.png" style="width: 768px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009LrTk.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/152780iB818A8A2A2AC8C7C/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009LrTk.png" alt="0683p000009LrTk.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Sat, 16 Nov 2024 09:09:41 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2024-11-16T09:09:41Z</dc:date>
    <item>
      <title>Unable to parse XML with XPATH and put it to Header with cHeader component</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Unable-to-parse-XML-with-XPATH-and-put-it-to-Header-with-cHeader/m-p/2299927#M72214</link>
      <description>&lt;P&gt;I would like to parse XML and put the value in the header. I am using cSetHeader for that.&lt;/P&gt; 
&lt;P&gt;This is how my XML looks like&lt;/P&gt; 
&lt;PRE&gt;&amp;lt;?xml version="1.0" ?&amp;gt;
&amp;lt;ORDER xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"&amp;gt;
	&amp;lt;HEAD&amp;gt;
		&amp;lt;DOC_STATUS&amp;gt;3&amp;lt;/DOC_STATUS&amp;gt;
		&amp;lt;DOC_NO&amp;gt;9300983009&amp;lt;/DOC_NO&amp;gt;
	&amp;lt;/HEAD&amp;gt;
&amp;lt;/ORDER&amp;gt;&lt;/PRE&gt; 
&lt;P&gt;and would like to set Header with XPATH(the expression: "/ORDER/HEAD/DOC_NO")&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;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}&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;How can I fix that?&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;My testing route looks like this:&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled2.png" style="width: 768px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009LrTk.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/152780iB818A8A2A2AC8C7C/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009LrTk.png" alt="0683p000009LrTk.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Sat, 16 Nov 2024 09:09:41 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Unable-to-parse-XML-with-XPATH-and-put-it-to-Header-with-cHeader/m-p/2299927#M72214</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2024-11-16T09:09:41Z</dc:date>
    </item>
    <item>
      <title>Re: Unable to parse XML with XPATH and put it to Header with cHeader component</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Unable-to-parse-XML-with-XPATH-and-put-it-to-Header-with-cHeader/m-p/2299928#M72215</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Your result type is an object.&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Could you try with:&lt;/P&gt; 
&lt;P&gt;"/ORDER/HEAD/DOC_NO", String.class&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;&lt;SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 857px;"&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009LrQh.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/128415iC0BC1592F1F5C1AA/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009LrQh.png" alt="0683p000009LrQh.png" /&gt;&lt;/span&gt;&lt;/SPAN&gt;&lt;/P&gt; 
&lt;P&gt;&amp;nbsp;&lt;/P&gt; 
&lt;P&gt;Eric&lt;/P&gt;</description>
      <pubDate>Fri, 20 Oct 2017 14:18:31 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Unable-to-parse-XML-with-XPATH-and-put-it-to-Header-with-cHeader/m-p/2299928#M72215</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2017-10-20T14:18:31Z</dc:date>
    </item>
  </channel>
</rss>

