<?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 Re: Parsing XML data to Json in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/Parsing-XML-data-to-Json/m-p/2308040#M79415</link>
    <description>&lt;P&gt;Hi&lt;/P&gt;&lt;P&gt;tFileInputJson is used to read a Json file, it can't read a XML file. You should use tFileInputXML to read the XML file, then, create a Json file using tFileOutputJson or use tWriteJsonField to generate a Json string. &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards&lt;/P&gt;&lt;P&gt;Shong&lt;/P&gt;</description>
    <pubDate>Fri, 20 Nov 2020 02:52:07 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2020-11-20T02:52:07Z</dc:date>
    <item>
      <title>Parsing XML data to Json</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Parsing-XML-data-to-Json/m-p/2308039#M79414</link>
      <description>&lt;P&gt;Hello, &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I need to parse XML data to Json data &lt;/P&gt;&lt;P&gt;Do you have any idea how to do it ? &lt;/P&gt;&lt;P&gt;This is my input : &lt;/P&gt;&lt;P&gt;&amp;lt;root&amp;gt;&lt;/P&gt;&lt;P&gt;	&amp;lt;patient&amp;gt;&lt;/P&gt;&lt;P&gt;		&amp;lt;name&amp;gt;&lt;/P&gt;&lt;P&gt;	Andréa&lt;/P&gt;&lt;P&gt;		&amp;lt;/name&amp;gt;		&lt;/P&gt;&lt;P&gt;	&amp;lt;/patient&amp;gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;lt;/root&amp;gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I tried to use the tFileInputJson and pass the URL of the xml file but it didn't work &lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper" image-alt="0693p00000AZDA1AAP.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/155270i6BD934088881DA09/image-size/large?v=v2&amp;amp;px=999" role="button" title="0693p00000AZDA1AAP.png" alt="0693p00000AZDA1AAP.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;but I got the following error : &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;fail to parse the json files &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thank you &lt;/P&gt;</description>
      <pubDate>Sat, 16 Nov 2024 01:05:12 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Parsing-XML-data-to-Json/m-p/2308039#M79414</guid>
      <dc:creator>ODridi</dc:creator>
      <dc:date>2024-11-16T01:05:12Z</dc:date>
    </item>
    <item>
      <title>Re: Parsing XML data to Json</title>
      <link>https://community.qlik.com/t5/Talend-Studio/Parsing-XML-data-to-Json/m-p/2308040#M79415</link>
      <description>&lt;P&gt;Hi&lt;/P&gt;&lt;P&gt;tFileInputJson is used to read a Json file, it can't read a XML file. You should use tFileInputXML to read the XML file, then, create a Json file using tFileOutputJson or use tWriteJsonField to generate a Json string. &lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards&lt;/P&gt;&lt;P&gt;Shong&lt;/P&gt;</description>
      <pubDate>Fri, 20 Nov 2020 02:52:07 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/Parsing-XML-data-to-Json/m-p/2308040#M79415</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2020-11-20T02:52:07Z</dc:date>
    </item>
  </channel>
</rss>

