Need help with multiple issues with tMongoDBOutput while using "Generate JSON Document" option to get desired document structure for MongoDB.
1. As per talend documentation - "You can adapt the JSON objects into BSON objects by adding __DOLLAR__ before the object (for example, $oid and $date become respectively __DOLLAR__oid and __DOLLAR__date)."? How to achieve this for objectId and date fields. Appreciate any example of adding above things in JSON tree configuration.
2. When java primitive data types like integer are coming as null (not string "null") from database, we get java exception as some default value needs to be assigned. As a workaround we are defining such fields which are nullable as object. As per documentation there is a setting to "Ignore service attributes for empty elements". But this is available via patch. Can we apply this in Talend open studio without subscription?
3. String fields which are null get converted to array. Any solution for this issue?
Appreciate any help for above issues.
