What will be "parent json path" in tmongoinput [array data]?

[sudarshank]

In image data, what will be "parent json path" for read the questionid and questioName data.

[Anonymous · Accepted solution]

A good tool for working out JSON paths can be found here....

https://jsonpathfinder.com/

[sudarshank]

Thank you!​

[sudarshank]

Hi rhall,

returns null in output . Is it correct json path for read "questionId" data from below collection.

 

collection data:

[

{

"_id": {

"$numberLong": "1"

},

"projectid": "f2a32744aacc9",

"surveyQuestionData": [

{

"questionId": {

"$numberLong": "100"

},

"languageId": {

"$numberLong": "1"

},

"questionName": "Any symptoms you have?",

"subQuestionId": {

"$numberLong": "0"

},

"optionMap": {

"1": "Yes",

"2": "No"

},

"isActive": true,

"response": {

"value": "1"

}

},

{

"questionId": {

"$numberLong": "101"

},

"languageId": {

"$numberLong": "1"

},

"questionName": "Covid-19 report positive?",

"subQuestionId": {

"$numberLong": "0"

},

"optionMap": {

"1": "Yes:",

"2": "No"

},

"isActive": true,

"response": {

"value": "1"

}

}

],

"surveyId": {

"$numberLong": "1"

},

"surveyName": "COVID-19",

"languageId": {

"$numberLong": "1"

},

"isActive": true,

"_class": "com.dummy"

},

{

"_id": {

"$numberLong": "2"

},

"projectid": "f2a32744aacc9",

"surveyQuestionData": [

{

"questionId": {

"$numberLong": "100"

},

"languageId": {

"$numberLong": "1"

},

"questionName": "Any symptoms you have?",

"subQuestionId": {

"$numberLong": "0"

},

"optionMap": {

"1": "Yes",

"2": "No"

},

"isActive": true,

"response": {

"value": "1"

}

},

{

"questionId": {

"$numberLong": "101"

},

"languageId": {

"$numberLong": "1"

},

"questionName": "Covid-19 report positive?",

"subQuestionId": {

"$numberLong": "0"

},

"optionMap": {

"1": "Yes:",

"2": "No"

},

"isActive": true,

"response": {

"value": "1"

}

}

],

"surveyId": {

"$numberLong": "1"

},

"surveyName": "COVID-19",

"languageId": {

"$numberLong": "1"

},

"isActive": true,

"_class": "com.dummy"

}

]