import json file to mongodb without '[' causes error

Question

mongoimport --db my_db --collection mycol --file "D:\workspace\intelligent_TDR\charm\employees.json" --jsonArray

Importing the employees.json file using the above command gives me the error

Failed: error reading separator after document #1: bad JSON array format - found no opening bracket '[' in input source

The content of json file is

{"employees":[
  { "firstName":"John", "lastName":"Doe" },
  { "firstName":"Anna", "lastName":"Smith" },
  { "firstName":"Peter", "lastName":"Jones" }
]}

If I place the content within '[' and ']' the import works.

The below json is imported without error

[{"employees":[
  { "firstName":"John", "lastName":"Doe" },
  { "firstName":"Anna", "lastName":"Smith" },
  { "firstName":"Peter", "lastName":"Jones" }
]}]

Why do you use the --jsonArray option if you don't have an array as your input? — Thilo
– Thilo, Commented Jan 29, 2020 at 11:11

Tom J Muthirenthi · Accepted Answer · 2020-05-06 16:29:37Z

1

In the json file you can pass the documents like,

{"employees":
  { "firstName":"John", "lastName":"Doe" },
  { "firstName":"Anna", "lastName":"Smith" },
  { "firstName":"Peter", "lastName":"Jones" }
}

It is not required to give the documents as a list.

answered May 6, 2020 at 16:29

Tom J Muthirenthi

3,3408 gold badges49 silver badges68 bronze badges

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

Collectives™ on Stack Overflow

import json file to mongodb without '[' causes error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related