How to get modified json output from MongoDB + Node.js + Mongoose

Question

Consider my collection is store as follows in MongoDB:

  { 
    _id: 'Unique_Value',
    FieldMONGO1: 'ngfn',
    FieldMONGO2: { SomeKey: ['val1','val2','val...']  },
  }

When I retrieve using find method on Model Instance of Mongoose. I get the following JSON output:

  { 
    _id: 'Unique_Value',
    FieldMONGO1: 'NAME_value',
    FieldMONGO2: { SomeKey: ['val1','val2','val...']  },
  }

Both are exactly same.

Question: Is there any way so that I can change the field names like FieldMONGO1 to FirstName, FieldMONGO2 to NewName & _id to IdentityNo?

So that my output will be something like this:

  { 
    IdentityNo: 'Unique_Value',
    FirstName: 'ngfn',
    NewName: { SomeKey: []  },
  }

Know Solution: Is to get the JSON output as is and then change field (attribute) name in Node.js code. But here the problem is, it becomes a blocking code. Which can create overhead on server if huge data is requested.

Could anyone help me out in find out some efficient way of doing the same?

Advance Thanks

Why are you using generic field names like FieldMONGO1 in your docs? — JohnnyHK
– JohnnyHK, Commented Feb 7, 2013 at 13:13

Community · Accepted Answer · 2017-05-23 10:24:50Z

5

check out Virtuals in mongoose.

check out the example in the reference link.

if you tweak like

urSchema.virtual('FirstName').get(function () {
  return this.FieldMONGO1;
});

you can do it.

check this answer on SO.

edited May 23, 2017 at 10:24

CommunityBot

11 silver badge

answered Feb 7, 2013 at 13:19

Mithun Satheesh

27.9k14 gold badges80 silver badges103 bronze badges

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

1 Comment

Amol M Kulkarni Over a year ago

If have some solution without mongoose as well, let me know.. Thanks for nice answer

Collectives™ on Stack Overflow

How to get modified json output from MongoDB + Node.js + Mongoose

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related