TmongoDbInput schema not retreiving properly

[Sujay1]

Hi All,

      I'm trying to retrieve below mongo document 

{
"id": "5b69b66d3dae73000fa39440",

"data":"Testing"
"products": [{ "orderid":"1234"
}],
"createDate": "2018-08-07T15:10:37.570Z",
"updateDate": "2018-08-09T16:09:46.621Z"
} 

I'm able to get Id,data but when i try to get products im unable to get the data. On top of it i'm getting products as below

[Document{{"orderid"="1234"}}] this is blocking me for parsing it as json. Can someone help. I think its a basic mistake but as i said im new to Talend OS for Big Data

[Sujay1]

thanks @rhall . So can it be safe to say it's a BUG from talend mongodbinput step? I'm already in the process of doing a work around.

[Anonymous · Accepted solution]

I can't really say unless I have access to the MongoDB database you are using. Also, try using the 3.2 driver with your tMongoDBInput component. I have heard that is a good way of getting around some issues

[Sujay1]

WOW just WOW  just by changing to mongo 3.2.x it worked fine. So it's a bug with new driver. Thanks @rhall  for bearing with my questions. Would you mind logging a bug so that others can for 3.5 driver. You can mark this as resolved.

[Anonymous]

I will take a look and see if this has been raised already. The  problem with this is that the bug looks like it is with the library which is supplied by MongoDB. Thanks for letting me know that this works