Correct syntax insert an array into MongoDB with validation rules

Question

I created a collection with validation rules using the following syntax:

>db.createCollection("CollName", {
   validator: {
      $jsonSchema:
{
    bsonType: "object",
    properties: {
        a1: {
            bsonType: "string",
        },
        a2:{
            bsonType: "string",
        },
        a3: {
            bsonType: "array",
            items: {
                bsonType: "object",
                  properties: {
                    b1: {
                        bsonType: "string",
                    },
                    b2: {
                        bsonType: "string",
                      }
                }
            }
        }

    }
}
}})

And I want to insert some documents into it. However, I am not able to find the correct syntax. I tried the following:

>  db.CollName.insert({
...  a1:"122234343",
...  a2: "name1",
...  a3: [b1: "aaa1111", b2: "bbb222"]
... })

2020-05-28T12:33:50.052+0200 E  QUERY    [js] uncaught exception: SyntaxError: missing ] after element list :
@(shell):4:8

>  db.CollName.insert({
...  a1:"122234343",
...  a2: "name1",
...  a3: ["aaa1111", "bbb222"]
... })

WriteResult({
    "nInserted" : 0,
    "writeError" : {
        "code" : 121,
        "errmsg" : "Document failed validation"
    }
})

How can I find the correct syntax?

Peter Mortensen · Accepted Answer · 2022-05-21 17:05:35Z

1

Try this:

db.CollName.insert({
 "a1":"122234343",
 "a2": "name1",
 "a3": [{"b1": "aaa1111", "b2": "bbb222"}]
})

edited May 21, 2022 at 17:05

Peter Mortensen

31.4k22 gold badges110 silver badges134 bronze badges

answered May 28, 2020 at 11:05

virendra singh deora

3235 silver badges13 bronze badges

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

1 Comment

Peter Mortensen Over a year ago

An explanation would be in order. E.g., what is the idea/gist? What did you change and why? What was the problem in the original? From the Help Center: "...always explain why the solution you're presenting is appropriate and how it works". Please respond by editing (changing) your answer, not here in comments (without "Edit:", "Update:", or similar - the answer should appear as if it was written today).

Collectives™ on Stack Overflow

Correct syntax insert an array into MongoDB with validation rules

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related