MongoDB Atlas免费版mongoimport报错：cannot decode array into a D

Hey there! Let's break down why your import is failing and how to fix it quickly.

The Root Cause #

The error Failed: cannot decode array into a D almost always points to a JSON file format issue. By default, mongoimport expects your file to use JSON Lines format (one JSON object per line, no outer array brackets). If your records.json is wrapped in an array like this:

[{"id": 1, "name": "Alice"}, {"id": 2, "name": "Bob"}]

That's exactly what's causing the failure—older versions of mongoimport (like your v4.2.0) don't handle this array structure by default.

Quick Fixes #

You have two straightforward options to resolve this:

Option 1: Add the --jsonArray parameter to your command #

This tells mongoimport to accept a top-level JSON array as input. Just update your command like this:

mongoimport --host Cluster0-shard-0/cluster0-shard-00-00-MY.mongodb.net:27017,cluster0-shard-00-01-MY.mongodb.net:27017,cluster0-shard-00-02-MY.mongodb.net:27017 --ssl --username MYUSER --password MYPASS --authenticationDatabase admin --db db --collection coll --type json --file D:\downloads\records.json --jsonArray

This is the fastest fix if you don't want to edit your JSON file.

Option 2: Convert your JSON file to JSON Lines format #

If you prefer to stick with the default mongoimport behavior, rewrite your records.json to have one document per line:

{"id": 1, "name": "Alice"}
{"id": 2, "name": "Bob"}

Remove the outer [] brackets and the commas between objects, then run your original command again.

Note About the "replicaset" Warning #

The warning ignoring unsupported URI parameter 'replicaset' is just a minor issue with your older v4.2.0 mongoimport tool not recognizing a parameter in the Atlas connection string. It won't block your import once you fix the JSON format issue, so you can ignore it for now.

内容的提问来源于stack exchange，提问作者majortom84