apoc.mongodb.get

Procedure APOC Full Deprecated

apoc.mongodb.get(host-or-key,db,collection,query,[compatibleValues=false|true],skip-or-null,limit-or-null,[extractReferences=false|true],[objectIdAsMap=true|false]) yield value - perform a find operation on mongodb collection

Signature

apoc.mongodb.get(host :: STRING?, db :: STRING?, collection :: STRING?, query :: MAP?, compatibleValues = false :: BOOLEAN?, skip = 0 :: INTEGER?, limit = 0 :: INTEGER?, extractReferences = false :: BOOLEAN?, objectIdAsMap = true :: BOOLEAN?) :: (value :: MAP?)

Input parameters

Name	Type	Default
host	STRING?	null
db	STRING?	null
collection	STRING?	null
query	MAP?	null
compatibleValues	BOOLEAN?	false
skip	INTEGER?	0
limit	INTEGER?	0
extractReferences	BOOLEAN?	false
objectIdAsMap	BOOLEAN?	true

Name

Type

Default

host

STRING?

null

STRING?

null

collection

STRING?

null

query

MAP?

null

compatibleValues

BOOLEAN?

false

skip

INTEGER?

limit

INTEGER?

extractReferences

BOOLEAN?

false

objectIdAsMap

BOOLEAN?

true

Output parameters

Name	Type
value	MAP?

Name

Type

value

MAP?

Install Dependencies

The Mongo procedures have dependencies on a client library that is not included in the APOC Library.

This dependency is included in apoc-mongodb-dependencies-4.3.0.12.jar, which can be downloaded from the releases page. Once that file is downloaded, it should be placed in the plugins directory and the Neo4j Server restarted.

Alternatively, you could copy these jars into the plugins directory:

bson-3.4.2.jar
mongo-java-driver-3.4.2.jar,
mongodb-driver-3.4.2.jar
mongodb-driver-core-3.4.2.jar

You should be able to get them from the following links:

Usage Examples

The examples in this section are based on a Mongo DB instance with a pre-populate twitter dataset. You can find instructions for setting this up at github.com/neo4j-examples/mongo-example.

Cypher

CALL apoc.mongodb.get('mongodb://mongo:neo4j@mongo:27017', 'test', 'tweets', {}, true) YIELD value
RETURN datetime({epochMillis:value._id.date}) AS date, value.user.name, value.text
LIMIT 10;

Table 1. Results
date	value.user.name	value.text
2015-04-25T16:20:26Z	"Mean Magazine Bot"	"RT @webinara: RT: http://t.co/tgxDJSOrHb #webinar #TrueTwit #TechTip. A Node.js API development webinar: https://t.co/nBjkk4MnuN"
2015-04-25T16:20:26Z	"Mean Magazine Bot"	"RT @zhangtai_me: Starting Angularjs Essentials, by Rodrigo Branas http://t.co/b2HaUzVtKt"
2015-04-25T16:20:26Z	"FC Barcelona"	"[CALENDAR] Barça have 5 league games left, 2 #UCL semi-final games, and the Spanish Cup final: http://t.co/mWKOzNEWFo http://t.co/cyN1ZZNsSx"
2015-04-25T16:20:26Z	"Mean Magazine Bot"	"RT @YAPCNA: David Golden (@xdg) talks about working with both Perl and MongoDB http://t.co/BEVQB521Al http://t.co/DallwKNcR8"
2015-04-25T16:20:26Z	"Hootsuite"	"Do you like social media? If so, you’ll LOVE this awesome list of movies: http://t.co/aUF2WUYudF http://t.co/T0ZtFaHoKJ"
2015-04-25T16:20:26Z	"Lemi Orhan Ergin"	"RT @serkanc: I’m going to @CraftSummit , who wants to join me? Some great speakers including @sandromancuso @alexboly @lemiorhan and @oezca…"
2015-04-25T16:20:26Z	"Mean Magazine Bot"	"RT @zhangtai_me: 25% done with Angularjs Essentials, by Rodrigo Branas http://t.co/wAMQJi7JoQ"
2015-04-25T16:20:26Z	"Hazelcast"	"Spring Integration Hazelcast Support 1.0 Milestone 1 is available http://t.co/kIu102CHKY"
2015-04-25T16:20:26Z	"Premier League"	"TEAM NEWS @MCFC are unchanged from the side that beat West Ham; Okore & Westwood replace Clark & Agbonlahor for @AVFCOfficial #MCIAVL"
2015-04-25T16:20:26Z	"Mean Magazine Bot"	"RT @Manjuics: Apply first: MNC looking for AngularJS in HYDERABAD, IND http://t.co/ijsnQWlgGb #job"