topic Re: What will be &quot;parent json path&quot; in tmongoinput [array data]? in Talend Studio https://community.qlik.com/t5/Talend-Studio/What-will-be-quot-parent-json-path-quot-in-tmongoinput-array/m-p/2330759#M99809 <P>A good tool for working out JSON paths can be found here....</P><P>&nbsp;</P><P>https://jsonpathfinder.com/</P> Wed, 02 Nov 2022 16:51:42 GMT Anonymous 2022-11-02T16:51:42Z What will be "parent json path" in tmongoinput [array data]? https://community.qlik.com/t5/Talend-Studio/What-will-be-quot-parent-json-path-quot-in-tmongoinput-array/m-p/2330758#M99808 <P>In image data, what will be "parent json path" for read the questionid and questioName data.</P> Fri, 15 Nov 2024 22:24:05 GMT https://community.qlik.com/t5/Talend-Studio/What-will-be-quot-parent-json-path-quot-in-tmongoinput-array/m-p/2330758#M99808 sudarshank 2024-11-15T22:24:05Z Re: What will be "parent json path" in tmongoinput [array data]? https://community.qlik.com/t5/Talend-Studio/What-will-be-quot-parent-json-path-quot-in-tmongoinput-array/m-p/2330759#M99809 <P>A good tool for working out JSON paths can be found here....</P><P>&nbsp;</P><P>https://jsonpathfinder.com/</P> Wed, 02 Nov 2022 16:51:42 GMT https://community.qlik.com/t5/Talend-Studio/What-will-be-quot-parent-json-path-quot-in-tmongoinput-array/m-p/2330759#M99809 Anonymous 2022-11-02T16:51:42Z Re: What will be "parent json path" in tmongoinput [array data]? https://community.qlik.com/t5/Talend-Studio/What-will-be-quot-parent-json-path-quot-in-tmongoinput-array/m-p/2330760#M99810 <P>Thank you!​</P> Wed, 02 Nov 2022 17:03:17 GMT https://community.qlik.com/t5/Talend-Studio/What-will-be-quot-parent-json-path-quot-in-tmongoinput-array/m-p/2330760#M99810 sudarshank 2022-11-02T17:03:17Z Re: What will be "parent json path" in tmongoinput [array data]? https://community.qlik.com/t5/Talend-Studio/What-will-be-quot-parent-json-path-quot-in-tmongoinput-array/m-p/2330761#M99811 <P>Hi rhall,</P><P>&nbsp;</P><P>returns null in output . Is it correct json path for read "questionId" data from below collection. </P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000YzS1KAAV.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/154664i0C8FCFA38CB8C146/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000YzS1KAAV.png" alt="0695b00000YzS1KAAV.png" /></span>&nbsp;</P><P>&nbsp;</P><P><B>collection data:</B></P><P>&nbsp;</P><P>[</P><P>{</P><P>"_id": {</P><P>"$numberLong": "1"</P><P>},</P><P>"projectid": "f2a32744aacc9",</P><P>"surveyQuestionData": [</P><P>{</P><P>"questionId": {</P><P>"$numberLong": "100"</P><P>},</P><P>"languageId": {</P><P>"$numberLong": "1"</P><P>},</P><P>"questionName": "Any symptoms you have?",</P><P>"subQuestionId": {</P><P>"$numberLong": "0"</P><P>},</P><P>"optionMap": {</P><P>"1": "Yes",</P><P>"2": "No"</P><P>},</P><P>"isActive": true,</P><P>"response": {</P><P>"value": "1"</P><P>}</P><P>},</P><P>{</P><P>"questionId": {</P><P>"$numberLong": "101"</P><P>},</P><P>"languageId": {</P><P>"$numberLong": "1"</P><P>},</P><P>"questionName": "Covid-19 report positive?",</P><P>"subQuestionId": {</P><P>"$numberLong": "0"</P><P>},</P><P>"optionMap": {</P><P>"1": "Yes:",</P><P>"2": "No"</P><P>},</P><P>"isActive": true,</P><P>"response": {</P><P>"value": "1"</P><P>}</P><P>}</P><P>],</P><P>"surveyId": {</P><P>"$numberLong": "1"</P><P>},</P><P>"surveyName": "COVID-19",</P><P>"languageId": {</P><P>"$numberLong": "1"</P><P>},</P><P>"isActive": true,</P><P>"_class": "com.dummy"</P><P>},</P><P>{</P><P>"_id": {</P><P>"$numberLong": "2"</P><P>},</P><P>"projectid": "f2a32744aacc9",</P><P>"surveyQuestionData": [</P><P>{</P><P>"questionId": {</P><P>"$numberLong": "100"</P><P>},</P><P>"languageId": {</P><P>"$numberLong": "1"</P><P>},</P><P>"questionName": "Any symptoms you have?",</P><P>"subQuestionId": {</P><P>"$numberLong": "0"</P><P>},</P><P>"optionMap": {</P><P>"1": "Yes",</P><P>"2": "No"</P><P>},</P><P>"isActive": true,</P><P>"response": {</P><P>"value": "1"</P><P>}</P><P>},</P><P>{</P><P>"questionId": {</P><P>"$numberLong": "101"</P><P>},</P><P>"languageId": {</P><P>"$numberLong": "1"</P><P>},</P><P>"questionName": "Covid-19 report positive?",</P><P>"subQuestionId": {</P><P>"$numberLong": "0"</P><P>},</P><P>"optionMap": {</P><P>"1": "Yes:",</P><P>"2": "No"</P><P>},</P><P>"isActive": true,</P><P>"response": {</P><P>"value": "1"</P><P>}</P><P>}</P><P>],</P><P>"surveyId": {</P><P>"$numberLong": "1"</P><P>},</P><P>"surveyName": "COVID-19",</P><P>"languageId": {</P><P>"$numberLong": "1"</P><P>},</P><P>"isActive": true,</P><P>"_class": "com.dummy"</P><P>}</P><P>]</P> Thu, 03 Nov 2022 07:10:45 GMT https://community.qlik.com/t5/Talend-Studio/What-will-be-quot-parent-json-path-quot-in-tmongoinput-array/m-p/2330761#M99811 sudarshank 2022-11-03T07:10:45Z