tMongoDBInput parent node path

[Anonymous]

Hi I am new to Talend .. I have created a mongodbconnection and using tMongoDBInput, I am able to fetch data and able to print. But for  one item it has array of list. I am not able to traverse array object. I am not able to understand what value I should give in parent node path. 

Please find attached screenshot for mongodb document 

I want to fetch title and all other fields  from relatedItems and it is an array of object which has multiple values. 

What will be parent node path for "title"

{
"relatedItems": [{
"title": "",
"type": "",
"products": [{
"productSequence": "1"
},
{
"productSequence": "2"

},
{
"productSequence": "3"

},
{
"productSequence": "4"

}
]
},
{
"title": "aaaa",
"type": "aaaa",
"description": "abcd",
"notiMsg": "RedBox Products"

}
]
}

[vapukov]

Hi,

[Anonymous]

Thanks for Reply but how should i send data from tmongodbinput to textractjsonfield. It is asking for mapping in tmongodbinput component. 

please find attached screenshot. 

tmongodbinput.jpg

[Anonymous]

getting error 

Expected to find an object with property ['relatedItems'] in path $ but found 'net.minidev.json.JSONArray'. This is not a json object according to the JsonProvider: 'com.jayway.jsonpath.spi.json.JsonSmartJsonProvider'.

---

---

[vapukov]

not sure - what is it

but you need first debug - what you receive from tMongoDBOutput - just connect it direct to tLogRow