MongoDB output collection with JSON tree attribute type 'objectid'

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

Friends,

Im a beginner to talend, creating a job to load data from MySQL to MongoDB. We have two collections (MASTER and DETAIL) in MongoDB, we load MASTER collection first and '_id' field of type 'ObjectId' is generated automatically. While loading DETAIL collection, we want the '_id' from MASTER collection to be assigned to a new field in DETAIL collection on certain join criteria in 'tmap'.

We are using JSON tree in tMongoOutput component to configure the collection structure, here '_id' field from MASTER collection is loading only as String field. Our expection is output field type should be 'ObjectId'. In JSON tree, is there any attribute type like 'objectid'?

Please provide your inputs to solve the problem.

Thanks & Regards,

Goushik Murugesan

Re: MongoDB output collection with JSON tree attribute type 'objectid'

Anonymous — Wed, 24 Apr 2019 10:07:53 GMT

Hello,

Please try to make the attribute type of ‘_id’ as @type and setting the Static Value to object in the Link target.

Best regards

Sabrina

topic Re: MongoDB output collection with JSON tree attribute type 'objectid' in Talend Studio

MongoDB output collection with JSON tree attribute type 'objectid'

Re: MongoDB output collection with JSON tree attribute type 'objectid'