<?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 How to get tExtractJsonFields to output multiple rows in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/How-to-get-tExtractJsonFields-to-output-multiple-rows/m-p/2295081#M67898</link>
    <description>&lt;P&gt;Hello.&lt;/P&gt;
&lt;P&gt;I use tRest to Post a _search request to ElasticSearch&lt;/P&gt;
&lt;P&gt;{&lt;/P&gt;
&lt;P&gt;"_source": "PersonID",&lt;/P&gt;
&lt;P&gt;"size": 20&lt;/P&gt;
&lt;P&gt;}&lt;/P&gt;
&lt;P&gt;and getting a proper response as expected.&lt;/P&gt;
&lt;P&gt;Than I pass it to tExtractJsonFields with this parameters:&lt;BR /&gt;Read By=JsonPath,&lt;BR /&gt;Json field = Body&lt;/P&gt;
&lt;P&gt;Loop Jsonpath query = "$"&lt;/P&gt;
&lt;P&gt;Mapping =&lt;/P&gt;
&lt;P&gt;&amp;nbsp;Column = PersonID, Json query = ".PersonID"&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;It seems to work fine, but insead of 20 rows as output, I seem to get only 1 string row like so&lt;/P&gt;
&lt;P&gt;[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;How can I get it to return 20 rows to the next component?&lt;/P&gt;
&lt;P&gt;Thanks&lt;/P&gt;</description>
    <pubDate>Sat, 16 Nov 2024 07:51:02 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2024-11-16T07:51:02Z</dc:date>
    <item>
      <title>How to get tExtractJsonFields to output multiple rows</title>
      <link>https://community.qlik.com/t5/Talend-Studio/How-to-get-tExtractJsonFields-to-output-multiple-rows/m-p/2295081#M67898</link>
      <description>&lt;P&gt;Hello.&lt;/P&gt;
&lt;P&gt;I use tRest to Post a _search request to ElasticSearch&lt;/P&gt;
&lt;P&gt;{&lt;/P&gt;
&lt;P&gt;"_source": "PersonID",&lt;/P&gt;
&lt;P&gt;"size": 20&lt;/P&gt;
&lt;P&gt;}&lt;/P&gt;
&lt;P&gt;and getting a proper response as expected.&lt;/P&gt;
&lt;P&gt;Than I pass it to tExtractJsonFields with this parameters:&lt;BR /&gt;Read By=JsonPath,&lt;BR /&gt;Json field = Body&lt;/P&gt;
&lt;P&gt;Loop Jsonpath query = "$"&lt;/P&gt;
&lt;P&gt;Mapping =&lt;/P&gt;
&lt;P&gt;&amp;nbsp;Column = PersonID, Json query = ".PersonID"&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;It seems to work fine, but insead of 20 rows as output, I seem to get only 1 string row like so&lt;/P&gt;
&lt;P&gt;[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;How can I get it to return 20 rows to the next component?&lt;/P&gt;
&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Sat, 16 Nov 2024 07:51:02 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/How-to-get-tExtractJsonFields-to-output-multiple-rows/m-p/2295081#M67898</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2024-11-16T07:51:02Z</dc:date>
    </item>
  </channel>
</rss>

