MongoDB upsert array using NodeJS

Question

I need to insert a list of elements and check if the element exists in database, if the element exists then the element will be update.

I used upsert and array:

    dbo.collection("Ebooks").update(arrayValues, {upsert: true, multi: true},function(err, res) {
         if (err) throw err;
         console.log("finish");
         db.close();
    });

Array eg:

[{_id: 10, name='Teste1'}, {_id: 11, name='Teste2'}]

And is returning this error:

MongoError: BSON field 'update.updates.q' is the wrong type 'array', expected type 'object'

How I convert Array to this Object?

Thanks.

Possible dupe of https://stackoverflow.com/questions/13588342/can-mongo-upsert-array-data — JohnnyHK, Jan 22 '18 at 14:50
Possible duplicate of https://stackoverflow.com/questions/23470658/mongodb-upsert-sub-document. You've to iterate input array and do a two step process as mentioned in duplicate. — s7vr, Jan 22 '18 at 14:53
Possible duplicate of https://stackoverflow.com/questions/37427610/mongodb-update-or-insert-object-in-array — Jithin Scaria, Jan 22 '18 at 15:00

score 1 · Answer 1 · answered Jan 22 '18 at 16:35

Not sure, but looks like you don't pass query(first parameter), what data should de updated.

dbo.collection("Ebooks").update((), arrayValues, {upsert: true, multi: true},function(err, res) {})

or

dbo.collection("Ebooks").update((_id:someValue), arrayValues, {upsert: true, multi: true},function(err, res) {})

MongoDB upsert array using NodeJS

1 Answers1