In MongoDB Atlas UI I can use the following [ {“xyz”: {$exists:true}} ]to return documents in a collection that contain the field “xyz”. But in make.com I get a the error, invalid JSON. Unexpected token $ in JSON at position 13 I’ve tried all sorts of combinations without luck. I’ve confirmed the s…

OK, I’ve got a new one. Hope you can help. This query works perfectly in mongo and mongo compass: {time: {$lt: ISODate(‘2022-11-10T18:09:23.000+00:00’)}} the goal is to return documents created later than xyz. adjusted per your earlier suggestion, the query runs but no results: {“time”: {“$lt”: I…

Hey @ryan_rockwood , In Make you have to use JSON format to send over the query. Try to use the following {"xyz": {"$exists": true}} Hope that works!

Created a new post for this followup Help format MONGODB query in make

Invalid Json Mongodb Search Documents

Questions

ryan_rockwood November 9, 2022, 4:39pm 3

You nailed it. Thank you!

Help format MONGODB query in make

Topic		Replies	Views
Help format MONGODB query in make Questions	8	1674	November 13, 2022
Query documents of the last 24h in MondoDB Questions	3	283	December 7, 2022
MongoDB dynamic timestamp search Questions connections	0	17	September 18, 2025
MongoDB query result is empty Questions connections	1	547	February 18, 2024
HTTP request filter by date Questions date-time-functions , format-date	2	915	November 2, 2023

Invalid Json Mongodb Search Documents

Related topics