I have a database structure for Collection1 with a field with dbref like this:
"field_name" : DBRef("Collection2", ObjectId("5c3e25aaf1a79a001f1dbb08"), "database_name")
I want to get only the ObjectId of the field_name with tMongoDBInput but I can't do it.
With MongoShell, I can do it with this request :
Anyone has any idea? Thanks.
Are you able to use the tMongoDBRow component to run a simple command like the following: "db.TalendTest.find()"?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Pick up some tips and tricks with Context Variables