$gte ISOdate function error VIA the api

MongoDB Atlas App Services & Realm Atlas Data API
3

Hi @spencerm - Welcome to the community :wave:

Thank you for providing the JSON used in the request.

The error I get is “Invalid syntax error: TypeError: invalid character ‘I’ looking for beginning of value”

I presume the wonDate is a date field but please correct me if I am wrong here. The Data API uses canonical MongoDB Extended JSON to encode BSON data types in request bodies. The ISODate() function is not valid MongoDB Extended JSON which is why the error is being returned.

Could you try with the following JSON instead:

{
   "dataSource":"Cluster0",
   "database":"v1",
   "collection":"pipedriveDeals",
   "filter":            {
         "wonDate":{
            "$gte": { "$date" : "2022-04-01T00:00:00Z" }
         }
      }
}

The Atlas Data API is currently in preview so there are chances the above behaviour may change.

If you’re still receiving errors, please advise of the full error message being received.

Hope this helps.

Regards,
Jason

3 Likes