'Extracting embedded data from mongo object ( sub fields) in Talend

I'm working on Talend open studio for Big Data and connected to a MongoDB Database , however i can't extract complex subfields objects from my collections, sometimes there is 4 levels of subfields and i always get a null when i try to extract more than the 1st level of data inside a sub field. can you please help me ? Thank you <3

mongodbobjectextractetltalend


Solution 1:[1]

Use get and set methods. Only For data that is non persistent.

Solution 2:[2]

You can get the whole JSON object by writing a * to the DB column name field in the schema.

Once you have the raw json you could get the information from it a lot easier.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Thaveshan Naidoo
Solution 2 Balazs Gunics

Related Questions