Any way to query apoc.mongodb.find by ObjectId

[enstricht]

The documents in m MongoDB have a _id of type ObjectId. In Neo4j a node has a reference to the document by the ObjectId as a string representation. But i can´t figure out how to query a document by the ObjectId as a string using apoc.mongodb.

Neo4j 4.2.1 community and APOC (+ mongodb driver) 4.2.0

This obviously does not work:

CALL apoc.mongodb.find("mongodb://host:port", "testdb", "testcoll", {_id: "6005c050d36d9acd28b8679b"}, null, null)
CALL apoc.mongodb.find("mongodb://host:port", "testdb", "testcoll", {_id: ObjectId("6005c050d36d9acd28b8679b")}, null, null)

[conker84]

@enstricht thank you for reaching us now is not possible get the document by Object id value, I opened an issue in order to add a new feature ASAP:

github.com/neo4j-contrib/neo4j-apoc-procedures

Add mongo procedure to get record by id

opened 09:48AM - 25 Jan 21 UTC

conker84

Add a procedure apoc.mongo.get.byObjectId(<hostOrKey>, <db>, <collection>, <objectIdValueAsString>, <fieldName, default=_id>) in order to get the the documents by ObjectId becayse now not...

Larus

Thank you so much for pointing this out!

[giuseppe_villan]

@enstricht I created the new procedure, awaiting approval, apoc.mongodb.get.byObjectId(<host>,<db>,<collection>,<objectIdAsString>, <fieldValue: default='_id'>, <optionalConfigMap>).
For example, to get a document with object id, you can type CALL apoc.mongodb.find("mongodb://host:port", "testdb", "testcoll", "6005c050d36d9acd28b8679b").
In optionalConfigMap you can put compatibleValues (to convert MongoDB data types into Neo4j data types, with default true), extractReferences (it will include the related document instead of the ObjectId, default: false).

Unfortunately I cannot attach the .jar with this new procedure, because it is not a supported format.