tMongoDBInput and nested components

[Anonymous]

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.

[Anonymous]

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



Regards
Shong