https://community.qlik.com/t5/Talend-Studio/problem-with-json-structre-mongodb/m-p/2249645#M34119 <P><SPAN>Hello Community</SPAN></P> <P>&nbsp;</P> <P><SPAN><BR />I have a json file which contains a lot of nested objects and arrays i want to import it and do a transformation on the id field which is a primary key and then i want to store this file on mongodb.<BR />I tried with this job&nbsp;<BR /><BR /></SPAN></P> <P><SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="job.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9ie.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/150681iF6F0F56D0B20DDC8/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9ie.png" alt="0683p000009M9ie.png" /></span></SPAN></SPAN></P> <P><SPAN><BR />but the problem is that the document stored on mongodb has lost its structure the content of the&nbsp;nested arrays has become a string .</SPAN></P> <P>&nbsp;</P> <P><SPAN>You will find attached the two json&nbsp;files input.json and output.json to more understand the problem.</SPAN></P> <P>&nbsp;</P> <P><SPAN>can you help me solve this problem even with another job that you propose ?<BR /></SPAN></P> <P>&nbsp;</P> <P><SPAN>Thank you all.</SPAN></P> Sat, 16 Nov 2024 02:59:07 GMT Anonymous 2024-11-16T02:59:07Z https://community.qlik.com/t5/Talend-Studio/problem-with-json-structre-mongodb/m-p/2249645#M34119 <P><SPAN>Hello Community</SPAN></P> <P>&nbsp;</P> <P><SPAN><BR />I have a json file which contains a lot of nested objects and arrays i want to import it and do a transformation on the id field which is a primary key and then i want to store this file on mongodb.<BR />I tried with this job&nbsp;<BR /><BR /></SPAN></P> <P><SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="job.PNG" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9ie.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/150681iF6F0F56D0B20DDC8/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9ie.png" alt="0683p000009M9ie.png" /></span></SPAN></SPAN></P> <P><SPAN><BR />but the problem is that the document stored on mongodb has lost its structure the content of the&nbsp;nested arrays has become a string .</SPAN></P> <P>&nbsp;</P> <P><SPAN>You will find attached the two json&nbsp;files input.json and output.json to more understand the problem.</SPAN></P> <P>&nbsp;</P> <P><SPAN>can you help me solve this problem even with another job that you propose ?<BR /></SPAN></P> <P>&nbsp;</P> <P><SPAN>Thank you all.</SPAN></P> Sat, 16 Nov 2024 02:59:07 GMT https://community.qlik.com/t5/Talend-Studio/problem-with-json-structre-mongodb/m-p/2249645#M34119 Anonymous 2024-11-16T02:59:07Z