$ne (Not Equal) in data api?

MongoDB Atlas App Services & Realm Atlas Data API
#1

Hi there, I can’t figure out how to use the $ne filter correctly in the data api. Here is what I’m trying to query. Everything works up until I add the “$ne” part. Can you help? Thank you!

{
   "dataSource":"Cluster0",
   "database":"v1",
   "collection":"pipedriveDeals",
   "filter":{
      "reasonLost":{
         "$ne":"Existing Customer"
      }
   },
   "inquiryDate":{
      "$lt":{
         "$date":"2022-04-15T00:00:00Z"
      },
      "$gt":{
         "$date":"2022-04-01T00:00:00Z"
      }
   },
   "sourceFirst":"Google Paid"
}
#2

Hi @spencerm ,

Your filter is malformed.

See that you have closed the filter after $ne for some reason, extra }…

If i am not mistaken this should.work:



"filter":{
      "reasonLost":{
         "$ne":"Existing Customer"
      },
   "inquiryDate":{
      "$lt":{
         "$date":"2022-04-15T00:00:00Z"
      },
      "$gt":{
         "$date":"2022-04-01T00:00:00Z"
      }
   },
   "sourceFirst":"Google Paid"
}

Ty