MongoDB Node: Support for Extended JSON

Feature Requests
1

In the MongoDB documentation there is support for Extended JSON - Node driver should support this already.

And so, a ObjectId could be represented by:

{"$oid":"5d505646cf6d4fe581014ab2"}

And a Date could be represented by:

{"$date":"2019-08-11T17:54:14.692Z"}

Mentioned in other questions:

MongoDB update field value as ObjectId
2

Have n8n introduced it ever or any other workaround? Is there a communiy node that solves it?

3

Ive solved this issue and all other using BSON as the parser. You can use at any any moment with my community node: https://www.npmjs.com/package/n8n-nodes-mongo-oid

3 إعجابات
4

@lehno is your node still working? I used the BSON syntax at least for the key id (in expression mode)
My data is not being updated, maybe I have to pass the updateOne() function?

 {
  "$set": {
    "STATUS": "failed",
    "NODE": "Google Drive2",
    "ATTEMPT": 1
  }
}

asfsgh
asfsgh646×333 14.3 KB