Adding Array object in mongo response JSON

Question

I want to add array in getting response in mongodb response (data fetching from mongo)

    { _id: 23232385,
      CompanyId: 232385,
      CompanyCd: 'MONDLAY',
      CompanyName: 'Company Name ',
      Competition: false,
      ParentCompany: 707,
      CareOf: '',
      AddressLine2: '',
      AddressLine3: '',
      Suite: '',
      City: 'Los Angeles',
      StateCd: 'CA',
      Zip: '90010',
      Title: '',
      Phone: '549-334',
      Extension: '',
      Fax:  '549-9834',
      Comment: '',
      Abrev: '',
      Email: '[email protected]' }

And want this response in JSON below like format.

[      
        { _id: 23232385,
          CompanyId: 232385,
          CompanyCd: 'MONDLAY',
          CompanyName: 'Company Name ',
          Competition: false,
          ParentCompany: 707,
          CareOf: '',
          AddressLine2: '',
          AddressLine3: '',
          Suite: '',
          City: 'Los Angeles',
          StateCd: 'CA',
          Zip: '90010',
          Title: '',
          Phone: '549-334',
          Extension: '',
          Fax:  '549-9834',
          Comment: '',
          Abrev: '',
          Email: '[email protected]' }
]

Also want something which goes with function. Also trying to implement the same thing with huge data set. Can anyone help me with this?

Thanks in advance

collection.find().each(function(err, item, response, status) { console.log(item) Array.from(item).forEach(itemdata => { bulk.push({index:{ _index: esIndexName, _type: mongoCollectionName, } }) bulk.push(itemdata) }) here I'm trying to convert item adding object array @SaurabhAgrawal — XFW
– XFW, Commented Sep 23, 2019 at 12:59

Saurabh Agrawal · Accepted Answer · 2019-09-23 13:00:18Z

1

You can use cursor.toArray() from mongoDB.

Try like this example:

var MongoClient = require('mongodb').MongoClient;
MongoClient.connect("url", function (_err, db) {
  var dbo = db.db("myDB");
  dbo.collection("myCollection").find({}).toArray(function (err, result) {
    console.log(result);//this will be array
  })
})

answered Sep 23, 2019 at 13:00

Saurabh Agrawal

7,7553 gold badges31 silver badges52 bronze badges

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

3 Comments

XFW Over a year ago

Can you edit the code I shared? Seems like I'm doing some mistake, data is getting lost.

Saurabh Agrawal Over a year ago

Everything seems to be fine with your question.

XFW Over a year ago

stackoverflow.com/questions/58324732/… can you check this

Collectives™ on Stack Overflow

Adding Array object in mongo response JSON

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related