Posting a reference ID to the parent collection in MongoDB is not allowed

Question

Posting a reference ID to the parent collection in MongoDB is not allowed

Trying to add two records into mongoDB: one as a new collection and the other as a reference ID.

Here is a sample schema: Company{ name: Acme Company, Locations: [refID] }

The ID and location payload will be sent in the request body.

addNewLocation: (req, res) => {
        
        let {id, ...payload} = req.body;
        
        db.Location.create(payload)
            .then( record => {
                let refId = record._id
                db.Company.findOneAndUpdate( {_id: id} , { $push: { locations: refId } }, { new: true })
            })
            .then( result => {
                res.status(201).json({success: true},{result})
            })
            .catch( err => {
                res.status(422).json({success: false},{err})
            })
    }

When viewing the update on Robo3T, it seems that a document is being inserted into the location but not the ref ID in the companies collection. Any thoughts on what might be causing this?

javascript mongodb express mongoose-schema

Answer 1

Answer №1

Perhaps you are confusing the spelling of locations in your schema when trying to push a reference. It could be Locations as your schema field name, or you may need to change it to locations. You can test this by updating your company schema with the following code:

 {
    name: String,
    locations:[
      {
      type: Schema.Types.ObjectId,
      ref: "Location"
     }
    ]
 }

Answer 2

Perhaps you are confusing the spelling of locations in your schema when trying to push a reference. It could be Locations as your schema field name, or you may need to change it to locations. You can test this by updating your company schema with the following code:

 {
    name: String,
    locations:[
      {
      type: Schema.Types.ObjectId,
      ref: "Location"
     }
    ]
 }

Answer 3

Answer №2

addNewLocation: (req, res) => {
    let { companyID , ...data } = req.body;

    db.Location.create(data)
    .then(({_id}) => {
       return db.Company.findOneAndUpdate(companyID, {$push:{locations: _id}},{new: true})
    })
    .then(()=>{
        res.status(201).json({message: 'Location added successfully'})
    })
    .catch((error)=>{
        res.status(422).json({message: 'Failed to add location'})
    })
}

This modified code adds a new location with proper error handling.

Answer 4

addNewLocation: (req, res) => {
    let { companyID , ...data } = req.body;

    db.Location.create(data)
    .then(({_id}) => {
       return db.Company.findOneAndUpdate(companyID, {$push:{locations: _id}},{new: true})
    })
    .then(()=>{
        res.status(201).json({message: 'Location added successfully'})
    })
    .catch((error)=>{
        res.status(422).json({message: 'Failed to add location'})
    })
}

This modified code adds a new location with proper error handling.

Posting a reference ID to the parent collection in MongoDB is not allowed

Answer №1

Answer №2

Similar questions

I must adjust the size of images based on the size of the viewer's screen

Troubleshooting Connection Issues with Node.js, Mongoose, and MongoDB

Updating a slider based on the values of two other sliders can be achieved by implementing a

Restarting the Application Server on Vercel: What to Do When Only the "Redeploy" Button is Present?

Show divs in identical position when clicking

Linking Multiple Applications Through an Express Server Proxy

Ways to distinguish XmlHttpRequest Access-Control-Allow-Origin issues from regular network errors

Resolving cached CSS and JS files through the use of local storage

Next.js encountered an API resolution issue while uploading a file, resulting in no response being

A guide to testing window.pageYoffset in webdriverIO using chai assertions

Running Spring Boot and MongoDB on Heroku connected to an Atlas database

What is the best approach to accumulate model data in an Angular JS service or controller through a series of consecutive calls?

Performing an HTTP request response in JavaScript

From Google Assistant to Python Results

Pass along an event from a child component to its parent in Vue 2

Accessing UPI apps such as Google Pay through deep linking from a web application

Deleting an item in MongoDB and Mongoose using its unique identifier

Incorporating a YouTube channel into mobile websites

Enhancing Javascript Dialog Box with a Touch of Animation

AngularJS item