mongoimport Error, Failed: invalid JSON input

Question

I have many mongodb instance files like below;

[
{ 
    "_id" : ObjectId("35d455de983c0e6a53ea0848"), 
    "createdAt" : ISODate("2019-12-05T23:25:04.347+0000"), 
    "__v" : NumberInt(0)
},
{ 
    "_id" : ObjectId("1ecbe0f75df8ccd52a7b1662"), 
    "createdAt" : ISODate("2019-12-17T12:40:53.521+0000"), 
    "__v" : NumberInt(0)
}
]

I couldn't import these files because of invalid format.

mongoimport --db DATABASENAME --collection COLLECTIONNAME --file filename.json --jsonArray

And it says;

Failed: invalid JSON input. Position: 16. Character: O

Is there any other way to import those files?

If not, how can I convert them to be imported?

Answer 1

you can use --legacy option of mongoimport in order to import the file with the format you want with ObjectId("an oid"), NumberInt(an int) or new Date("an iso date" or any mongo extension available in extended json v1 : https://docs.mongodb.com/manual/reference/mongodb-extended-json-v1/)

Answer 2

invalid JSON input. Position: 96. Character: N

For me it was "N" for NaN that I replaced with 0 and it wroked.

It also worked with adding the --legacy option, but I preferred to fix the file as the legacy option did not work within my docker container.