Mongodb with nested Arrays

Question

I looked on the web and didn't find what I wanted.

I want to know if it's possible to insert an array inside another one like

Let's say I want to do this:

db.siteraiz.insert(     
    SiteRaiz:[
        [{Dados:'idSiteRaiz:#ChartSet',
         [{Metas:'metaValor'}],
         [{Robots:'link1:#linkN'}]
         }]
)

Mongo is a "document" based database...this means it basically just takes JSON objects as its input data...so yes...you can definitely nest data with JSON objects. — ewizard
– ewizard, Commented Jun 30, 2014 at 20:23
example JSON object with arrays: var object = {"array": yourarray, "array2": yourarray2} — ewizard
– ewizard, Commented Jun 30, 2014 at 20:26

Gergo Erdosi · Accepted Answer · 2014-06-30 21:11:21Z

1

Yes, it's possible to insert an array into another, but you can't use arrays in objects without a key. This syntax is invalid:

{
  Dados: 'idSiteRaiz:#ChartSet',
  [
    {Metas:'metaValor'}
  ],
  [
    {Robots:'link1:#linkN'}
  ]
}

You can use objects only with key-value pairs:

{
  key1: 'value1',
  key2: 'value2'
}

You can have arrays inside objects, but you still need to use a key for the array:

{
  key1: 'value1',
  key2: ['value2', 'value3']
}

I don't exactly understand how you want to structure your data, but here are some working examples:

db.siteraiz.insert({
  SiteRaiz:[
    {
      Dados: 'idSiteRaiz:#ChartSet'
    }
  ]
})

db.siteraiz.insert({
  SiteRaiz:[
    [
      {Metas:'metaValor'}
    ],
    [
      {Robots:'link1:#linkN'}
    ]
  ]
})

Make sure you are trying to insert a valid JSON object. You can validate your JSON object for example here: http://jsonlint.com/

edited Jun 30, 2014 at 21:11

answered Jun 30, 2014 at 20:30

Gergo Erdosi

42.3k21 gold badges122 silver badges95 bronze badges

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

3 Comments

Reno Over a year ago

I see, so i must use arrays that way, i thought about that, but didn't know if i could do the way i wanted to, thanks man, i wish i could vote for your answer.

Gergo Erdosi Over a year ago

@user3529913 Edited my answer to make it more clear what the issue is with your example.

Reno Over a year ago

So, it'd be like this db.siteraiz.insert( SiteRaiz:[ Dados:'idSiteRaiz:#ChartSet', [{Metas:'metaValor'}], [{Robots:'link1:#linkN'} ] ] }) i wanted to put meta and robots inside siterais, but what you did (the last one) it's what I want, really thanks man.

Collectives™ on Stack Overflow

Mongodb with nested Arrays

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related