Upsert in KNIME MongoDB Update

Hi ,

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.

Thanks,
Nivedita

1 Like

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

Thanks,
Nivedita

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 :slight_smile: as the first step. The error when I use , is what I detailed in my post.

Thanks,
Nivedita

1 Like