MongoExport error - cannot unmarshal string

Question

I have a MongoDB collection with the following documents. Some of the documents have 1 field and some have 2. I am interested in exporting only those that I have the field "productid". I am using the query below but getting the error: "cannot unmarshal string into GO value of type map[string] interface {}".

The document looks like this:

[
  {
     "id" : 1,
  },
  {
     "id" : 2,
  },
  {
     "id" : 3
     "Product Info":
      {
         "ProductName" : "test"
      }
  }
]

The MognoExport command I am using is as follows: mongoexport --username x --password x --host x --db mydb --collection mycol --query '{"Product Info.ProductName":{"$exists":true}}' --type=csv --fields id,productid --out "c:\myfile.csv"

degmo · Accepted Answer · 2016-04-06 22:14:20Z

3

I fixed this issue by updating my script to:

mongoexport --username x --password x --host x --db mydb --collection mycol --query "{ 'Product Info.ProductName':{$exists:true}}" --type=csv --fields id,productid --out "c:\myfile.csv"

answered Apr 6, 2016 at 22:14

degmo

1773 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

MongoExport error - cannot unmarshal string

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related