I am getting below error on when using KNIME MongoDB update node . MongoDB writer works fine , but it always inserts , hence looking for node supporting upsert operations . Pls help
ERROR MongoDB Update 3:45 Execute failed: Invalid BSON field name XXX
I want to perform upsert operations on mongo DB , to insert if the record is not present and update if the record is already present . Please help.
Hi @nivedita_dixit , the DB Merge node is what you need to do Upsert.
Hi @bruno29a , DB merge node does not work for MongoDB , had tried it. Pls suggest for MongoDB
Hi @nivedita_dixit , sorry I did not carefully read that it was for MongoDB.
Have you tried the Upsert option in the MongoDB Update node?
Hi @bruno29a ,
yes, I did as the first step. The error when I use , is what I detailed in my post.