MongoDB error parsing query as Extended JSON: invalid JSON input

Question

I am trying to run this command:

mongodump  --port 27017  -d local -c oplog.rs -q '{ts:{$gt: Timestamp(1578475955, 1)}}' -o /data/dump/inc/

but for some reason im getting this error:

Failed: error parsing query as Extended JSON: invalid JSON input

what's the issue?

Most likely your json not formatted correctly. Just try to validate using an online validator (probably your keys not quoted). — Oleg
– Oleg, Commented Mar 21, 2021 at 11:51

D. SM · Accepted Answer · 2021-03-21 12:32:16Z

1

{ts:{$gt: Timestamp(1578475955, 1)}} is JavaScript, not extended JSON. See https://github.com/mongodb/specifications/blob/master/source/extended-json.rst for the extended JSON description.

The correct formulation is {"ts":{"$gt": {"$timestamp":{"t":1578475955, "i":1}}}}.

answered Mar 21, 2021 at 12:32

D. SM

14.6k3 gold badges15 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1