I am working with MongoDB trying to upsert nested MongoDB documents. The JSON format would be something like:
{
“name”: “XXX”,
“tables” : [
{
“name”: “XXXX”,
“num_rows” : 3423,
“fields”: [
{“name”: “XXX”, “type”: “yyyy”} , ….
]
}, ….
]
I have no problems when I use a JSON string attribute inserting a new document with Document Source”: Json Attribute” and Insert operation.
But, I do need to UPDATE existing features.
In this case, the nested dcouments (tables in the json above) are created as plain strings. Which is a real inconvenience in my use-case.
{
“name”: “XXX”,
“tables” : [ “{“name”: “XXXX”,“num_rows” : 3423,“fields”: [ {“name”: “XXX”, “type”: “yyyy”} , …. ]} “ , ….
]
Valid datatypes do not currently include arrays (of objects)
Is there any alternative or workarounds?
