tMongoDBInput and nested components

Anonymous — Sat, 16 Nov 2024 10:07:43 GMT

I have data in Mongo which look like this:
{"id":"id12345",
   "company":{"id":"sub34567","name":"Acme"}
}
I am able to read {"id12345","Acme"} using tMongoDBInput using a schema like this:
Column DBColumn
id    id
name      name

and a parent node "company" for the name entry in the mapping.

I am however not able to get {"id12345","sub34567"}. I cannot name two rows in the schema as "id" - and if I create a line in the schema saying
companyId id
(so I try to rename the entry) and associate the parent node path "company" to companyId in the mapping the output for this field is null.

Is there a way to solve this problem?

I am using TOS BD 6.3.0 and the embedded tMongoDBInput component.

Re: tMongoDBInput and nested components

Anonymous — Thu, 16 Feb 2017 02:23:31 GMT

Hi
Read by XPath and set loop jsonpath query as "/company", you are able to read all the values.

Regards
Shong

topic tMongoDBInput and nested components in Talend Studio

tMongoDBInput and nested components

Re: tMongoDBInput and nested components