Support Questions

Find answers, ask questions, and share your expertise

How to write mongoDb query in Apache Nifi GetMongo Processor ?

avatar
Contributor

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

avatar

@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

4 REPLIES 4

avatar

@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}
}

avatar

@Vivek Singh did the suggestion worked for you?

avatar
Contributor

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

avatar

any way to use query for filter only last minutes transactions