Open Shubgupta007 opened 2 years ago
Hello,
Using XSOAR platform for MongoDB query. When I was trying to find using ISO date query format it was showing not a valid JSON.
Query Using - "\"created\": { \"$gte\": { \"$date\": \"2022-06-08T00:00:00.000Z\" } }" return It is not a valid JSON
Mongo Entry present in mongo DB
{ "_id" : ObjectId("62a052980b0b5550f005b6e4"), "name" : "ABC", "email" : "abc@gmail.com", "title" : "asd", "intelligenceCenter" : "test", "rfiTitle" : "Test", "requestDescription" : "Test", "additionalContext" : [ "test" ], "requestEndpoint" : "trest", "requestDate" : "2022-06-02T18:30:00.000Z", "levelOfIntelligence" : "test", "type" : "request", "created" : ISODate("2022-06-08T07:41:12.817+0000"), "status" : "Pending" }
If possible can you provide the REST API documentation of Mongo DB that was a query to find using ISO date?
Hello,
Using XSOAR platform for MongoDB query. When I was trying to find using ISO date query format it was showing not a valid JSON.
Query Using - "\"created\": { \"$gte\": { \"$date\": \"2022-06-08T00:00:00.000Z\" } }" return It is not a valid JSON
Mongo Entry present in mongo DB
{ "_id" : ObjectId("62a052980b0b5550f005b6e4"), "name" : "ABC", "email" : "abc@gmail.com", "title" : "asd", "intelligenceCenter" : "test", "rfiTitle" : "Test", "requestDescription" : "Test", "additionalContext" : [ "test" ], "requestEndpoint" : "trest", "requestDate" : "2022-06-02T18:30:00.000Z", "levelOfIntelligence" : "test", "type" : "request", "created" : ISODate("2022-06-08T07:41:12.817+0000"), "status" : "Pending" }
If possible can you provide the REST API documentation of Mongo DB that was a query to find using ISO date?