https://community.qlik.com/t5/Talend-Studio/Issues-with-tMongoDBOutput-while-using-quot-Generate-JSON/m-p/2364236#M128019 <P>Need help with multiple issues with tMongoDBOutput while using "Generate JSON Document" option to get desired document structure for MongoDB.</P><P></P><P></P><P>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.</P><P></P><P></P><P>2. When java primitive data types like integer are coming as null (not string "null")&nbsp;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?</P><P></P><P></P><P>3. String fields which are null get converted to array. Any solution for this issue?</P><P></P><P></P><P>Appreciate any help for above issues.</P> Fri, 15 Nov 2024 23:47:07 GMT PB1608798450 2024-11-15T23:47:07Z https://community.qlik.com/t5/Talend-Studio/Issues-with-tMongoDBOutput-while-using-quot-Generate-JSON/m-p/2364236#M128019 <P>Need help with multiple issues with tMongoDBOutput while using "Generate JSON Document" option to get desired document structure for MongoDB.</P><P></P><P></P><P>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.</P><P></P><P></P><P>2. When java primitive data types like integer are coming as null (not string "null")&nbsp;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?</P><P></P><P></P><P>3. String fields which are null get converted to array. Any solution for this issue?</P><P></P><P></P><P>Appreciate any help for above issues.</P> Fri, 15 Nov 2024 23:47:07 GMT https://community.qlik.com/t5/Talend-Studio/Issues-with-tMongoDBOutput-while-using-quot-Generate-JSON/m-p/2364236#M128019 PB1608798450 2024-11-15T23:47:07Z