<?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 generate a JSON string contains Array? in Talend Studio</title>
    <link>https://community.qlik.com/t5/Talend-Studio/How-to-generate-a-JSON-string-contains-Array/m-p/2365929#M129480</link>
    <description>On TOS 6.1, I am trying to generate a JSON string contains one Array element. There is a ArrayList type "imageIds" in input schema of tWriteJSONField, and bind to "element" field which is an loop element in output schema. 
&lt;BR /&gt;However, as in output, I found there's additional "[]": 
&lt;BR /&gt;{ 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; "accountid": "1", 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; "token": "rAXRRuapwDsO5A", 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; "initialContent": { 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; "wxUserId": "o9-uWuNuTZgTW2p_FYzzZ5E2dGuA", 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; "productType": "1", 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; "description": "?????\n??", 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; "serverPhotoIds": [ &amp;nbsp; &amp;nbsp; 
&lt;FONT color="#ff3333"&gt;&amp;lt;-----unexpected&lt;/FONT&gt; 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; [ 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; "60e5a503-0c23-11e6-a5c9-d1b1a1c2ca83", 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; "610fc244-0c23-11e6-a5c9-43ab28439981", 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; "61334fd5-0c23-11e6-a5c9-c3176c103283" 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ] 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ] &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp; 
&lt;FONT color="#ff3333"&gt;&amp;lt;-----unexpected&lt;/FONT&gt; 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; } 
&lt;BR /&gt;} 
&lt;BR /&gt; 
&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009MHGS.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/158298i966C2122B533B9BA/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009MHGS.png" alt="0683p000009MHGS.png" /&gt;&lt;/span&gt;</description>
    <pubDate>Sat, 16 Nov 2024 10:40:20 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2024-11-16T10:40:20Z</dc:date>
    <item>
      <title>How to generate a JSON string contains Array?</title>
      <link>https://community.qlik.com/t5/Talend-Studio/How-to-generate-a-JSON-string-contains-Array/m-p/2365929#M129480</link>
      <description>On TOS 6.1, I am trying to generate a JSON string contains one Array element. There is a ArrayList type "imageIds" in input schema of tWriteJSONField, and bind to "element" field which is an loop element in output schema. 
&lt;BR /&gt;However, as in output, I found there's additional "[]": 
&lt;BR /&gt;{ 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; "accountid": "1", 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; "token": "rAXRRuapwDsO5A", 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; "initialContent": { 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; "wxUserId": "o9-uWuNuTZgTW2p_FYzzZ5E2dGuA", 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; "productType": "1", 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; "description": "?????\n??", 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; "serverPhotoIds": [ &amp;nbsp; &amp;nbsp; 
&lt;FONT color="#ff3333"&gt;&amp;lt;-----unexpected&lt;/FONT&gt; 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; [ 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; "60e5a503-0c23-11e6-a5c9-d1b1a1c2ca83", 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; "610fc244-0c23-11e6-a5c9-43ab28439981", 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; "61334fd5-0c23-11e6-a5c9-c3176c103283" 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ] 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; ] &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;&amp;nbsp; 
&lt;FONT color="#ff3333"&gt;&amp;lt;-----unexpected&lt;/FONT&gt; 
&lt;BR /&gt;&amp;nbsp; &amp;nbsp; } 
&lt;BR /&gt;} 
&lt;BR /&gt; 
&lt;span class="lia-inline-image-display-wrapper" image-alt="0683p000009MHGS.png"&gt;&lt;img src="https://community.qlik.com/t5/image/serverpage/image-id/158298i966C2122B533B9BA/image-size/large?v=v2&amp;amp;px=999" role="button" title="0683p000009MHGS.png" alt="0683p000009MHGS.png" /&gt;&lt;/span&gt;</description>
      <pubDate>Sat, 16 Nov 2024 10:40:20 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/How-to-generate-a-JSON-string-contains-Array/m-p/2365929#M129480</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2024-11-16T10:40:20Z</dc:date>
    </item>
    <item>
      <title>Re: How to generate a JSON string contains Array?</title>
      <link>https://community.qlik.com/t5/Talend-Studio/How-to-generate-a-JSON-string-contains-Array/m-p/2365930#M129481</link>
      <description>Hi
&lt;BR /&gt;Don't need to set an attribute @class to&amp;nbsp;serverPhotoIds element.&amp;nbsp;
&lt;BR /&gt;
&lt;BR /&gt;
&lt;BR /&gt;Regards
&lt;BR /&gt;Shong</description>
      <pubDate>Wed, 04 May 2016 08:35:44 GMT</pubDate>
      <guid>https://community.qlik.com/t5/Talend-Studio/How-to-generate-a-JSON-string-contains-Array/m-p/2365930#M129481</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2016-05-04T08:35:44Z</dc:date>
    </item>
  </channel>
</rss>

