https://community.qlik.com/t5/Talend-Studio/JSON-path-question/m-p/2342923#M110736 <P>Hi everybody,</P> <P>&nbsp;</P> <P>I am trying to get particular Json info in order to write in file the result.</P> <P>&nbsp;</P> <P>With <A href="http://jsonpath.com/" target="_self" rel="nofollow noopener noreferrer">http://jsonpath.com/</A>, I got the results expected with this JSON path expression :</P> <P>&nbsp;</P> <P>&nbsp;</P> <PRE>$.[?(@.idList)].name</PRE> <P>=</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 764px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lr5s.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144122i7D419AB88EB1E56C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lr5s.png" alt="0683p000009Lr5s.png" /></span></SPAN></P> <P>...</P> <P>&nbsp;</P> <P>In Talend, with this job :</P> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 646px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lr55.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132602i19F7B7A026CC22E9/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lr55.png" alt="0683p000009Lr55.png" /></span></SPAN></P> <P>&nbsp;</P> <P>In my componant TrelloImport2, I did this :</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lr62.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/149540i0B68CC12204EAEE8/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lr62.png" alt="0683p000009Lr62.png" /></span></SPAN></P> <P>&nbsp;</P> <P>But It didn't work ! Why ? I got this in my file actually : ( the row "name" appears like an empty array)</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lr6C.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/130583iF4631A271F98D0CD/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lr6C.png" alt="0683p000009Lr6C.png" /></span></SPAN></P> <P>Could you give me a clue ?</P> <P>&nbsp;</P> <P>Thanks,</P> Thu, 14 Sep 2017 13:37:06 GMT Anonymous 2017-09-14T13:37:06Z https://community.qlik.com/t5/Talend-Studio/JSON-path-question/m-p/2342923#M110736 <P>Hi everybody,</P> <P>&nbsp;</P> <P>I am trying to get particular Json info in order to write in file the result.</P> <P>&nbsp;</P> <P>With <A href="http://jsonpath.com/" target="_self" rel="nofollow noopener noreferrer">http://jsonpath.com/</A>, I got the results expected with this JSON path expression :</P> <P>&nbsp;</P> <P>&nbsp;</P> <PRE>$.[?(@.idList)].name</PRE> <P>=</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 764px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lr5s.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144122i7D419AB88EB1E56C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lr5s.png" alt="0683p000009Lr5s.png" /></span></SPAN></P> <P>...</P> <P>&nbsp;</P> <P>In Talend, with this job :</P> <P>&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 646px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lr55.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132602i19F7B7A026CC22E9/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lr55.png" alt="0683p000009Lr55.png" /></span></SPAN></P> <P>&nbsp;</P> <P>In my componant TrelloImport2, I did this :</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lr62.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/149540i0B68CC12204EAEE8/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lr62.png" alt="0683p000009Lr62.png" /></span></SPAN></P> <P>&nbsp;</P> <P>But It didn't work ! Why ? I got this in my file actually : ( the row "name" appears like an empty array)</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lr6C.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/130583iF4631A271F98D0CD/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lr6C.png" alt="0683p000009Lr6C.png" /></span></SPAN></P> <P>Could you give me a clue ?</P> <P>&nbsp;</P> <P>Thanks,</P> Thu, 14 Sep 2017 13:37:06 GMT https://community.qlik.com/t5/Talend-Studio/JSON-path-question/m-p/2342923#M110736 Anonymous 2017-09-14T13:37:06Z https://community.qlik.com/t5/Talend-Studio/JSON-path-question/m-p/2342924#M110737 <P>Hi,</P> <P>What does your input json data look like?</P> <P>Best regards</P> <P>Sabrina</P> Tue, 26 Sep 2017 07:39:45 GMT https://community.qlik.com/t5/Talend-Studio/JSON-path-question/m-p/2342924#M110737 Anonymous 2017-09-26T07:39:45Z