[resolved] JSON format in tMongoDBOutput

Anonymous — Sat, 16 Nov 2024 11:24:38 GMT

Hi,
I was looking at this document.
https://help.talend.com/search/all?query=tMongoDBOutput&content-lang=en
I am not able to understand how exactly to use data node and query node here.
Also, the tMongoDBOutput component requires the schema to be same as input schema.
I have the input coming from a sql schema as:
Name, DOB, class, subject1_marks, subject2_marks,subject3_marks, average_marks
I want to frame a json in my mongoDB like:
{
_id:{ name:"abc", DOB:"26-01-1947"},
subjects:
}
Also i want to perform upsert operations where i can update marks for specific subjects and add additional fields like
{
_id:{ name:"abc", DOB:"26-01-1947"},
subjects:
}
How to do this?
I see upsert option but am not able to use it. Also how to use properties of mongo like $push and $set here.

Thanks!

Re: [resolved] JSON format in tMongoDBOutput

Anonymous — Tue, 02 Dec 2014 12:09:12 GMT

Hi
The data node and the query node have to be defined in the json tree, the data node defines the data will be updated or inserted, the query node defines the query condition. In the below example, the id element is defined under the query node, it will compare the input id value with existing ids in target database, if id already exists, then update the data, otherwise, insert a new data.

Best regards
Shong

topic Re: [resolved] JSON format in tMongoDBOutput in Talend Studio

[resolved] JSON format in tMongoDBOutput

Re: [resolved] JSON format in tMongoDBOutput