Support Questions

Find answers, ask questions, and share your expertise

How to write mongoDb query in Apache Nifi GetMongo Processor ?

Explorer

I am trying to fetch some data from mongodb using Nifi and I am using GetMongo processor. I am trying to write a query inside GetMongo but I dont have any idea how t write query inside this processor.
This is my sample query

db.Person.find({
$and:[
{"createdAt":{$ne:null}},
{"updatedAt":{$ne:null}}
]
})

when I write this query it shows the exclamation marks over the processor showing that "Query validated against .... is invalid because JSON was expecting a value but find db." Help me with the correct expression variables at least a good sample will be helpful.

1 ACCEPTED SOLUTION

@Vivek Singh The query in GetMongo Processor should be in Extended JSON format. The format you are mentioning is the Mongo Shell format and not compatible with the processors. Switch your query to look something like below.

{
"createdAt":{$ne:null},
"updatedAt" : {$ne:null}
}

View solution in original post

3 REPLIES 3

@Vivek Singh The query in GetMongo Processor should be in Extended JSON format. The format you are mentioning is the Mongo Shell format and not compatible with the processors. Switch your query to look something like below.

{
"createdAt":{$ne:null},
"updatedAt" : {$ne:null}
}

@Vivek Singh did the suggestion worked for you?

Explorer

@Rahul Soni Yes Mr. Soni thanks its working. Thanks for your time.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.