question Re: How to write mongoDb query in Apache Nifi GetMongo Processor ? in Support Questions

How to write mongoDb query in Apache Nifi GetMongo Processor ?

vivek_b3ds — Wed, 21 Mar 2018 17:16:43 GMT

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.

Re: How to write mongoDb query in Apache Nifi GetMongo Processor ?

RahulSoni — Thu, 22 Mar 2018 00:22:28 GMT

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

Re: How to write mongoDb query in Apache Nifi GetMongo Processor ?

RahulSoni — Fri, 23 Mar 2018 02:41:36 GMT

@Vivek Singh did the suggestion worked for you?

Re: How to write mongoDb query in Apache Nifi GetMongo Processor ?

vivek_b3ds — Fri, 23 Mar 2018 08:29:29 GMT

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

Re: How to write mongoDb query in Apache Nifi GetMongo Processor ?

moahmedhassaan — Fri, 10 Mar 2023 10:01:15 GMT

any way to use query for filter only last minutes transactions