tMongoDBOutput - getting null array when value is null
I'm writing to MongoDB - using the tMongoDBOutput using the generate JSON Document option. I'm doing a Set action to fill in addresses.
Input fields (all are string)
address1
address2
city
state
The target collection has a unique integer value CustomerID which is used for the "query".
Under the document there is
rootTag
data
CustomerID
addresses (@class array)
row5 (object, loop element)
address1
address2
city
state
with the obvious mapping.
This works fine... except when address2 is null ... I get the address2 output in Mongo as an 0 element array! The advanced option "create empty element if needed" is not checked.
What I want is either address2 being an empty string, or not having an address2 element if there is no address2 data. I tried in a tMap to convert null to "", but got the same result.
For testing purpose, could you please add single space " " and see whether it is resolving the issue?
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Could you please check whether you have selected "Remove Null Field" option in the mapping for tMongoDBOutput? If its checked, could you please uncheck it and try again?
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Could you please select it and see whether data is getting created for empty elements?
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Turning on or off the setting "create empty element if needed" seems to make no difference. Results are the same either way.
I wonder if the logic for creating (or not) is getting applied at the "row5" level, because that is an object? So if there's anything for the object, the entire object is created, including address2.
