topic Re: tMongoDBInput parent node path in Talend Studio

tMongoDBInput parent node path

Anonymous — Sat, 16 Nov 2024 06:36:01 GMT

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"

}
]
}

Re: tMongoDBInput parent node path

vapukov — Wed, 13 Feb 2019 22:44:37 GMT

Hi,

Re: tMongoDBInput parent node path

Anonymous — Thu, 14 Feb 2019 15:12:00 GMT

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

Re: tMongoDBInput parent node path

Anonymous — Thu, 14 Feb 2019 18:02:55 GMT

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'.

Re: tMongoDBInput parent node path

vapukov — Thu, 14 Feb 2019 22:01:45 GMT

not sure - what is it

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