Adding Multiple Items to an Express Endpoint

Question

Adding Multiple Items to an Express Endpoint

I have a requirement to store multiple objects in my mongo database within an express route. Currently, the process is smooth when I post individual objects (such as ONE casino), as shown below. Instead of repeating this numerous times, I am seeking assistance to do it as a single data dump so I can upload ALL my casinos at once.

Below is the functioning route for posting a single object:

router.post('/post', async (req, res) => {
console.log(req.body);
const casinoData = new Casino({
    casino: req.body.casino,
    table_and_other: req.body.table_and_other,
    poker: req.body.poker,
    slot_machines: req.body.slot_machines,
    total_gaming_win: req.body.total_gaming_win,
    year: req.body.year,
    month: req.body.month,
    combined_date: req.body.combined_date
})

try {
    const newCasino = await casinoData.save()
    res.status(201).json(newCasino)
} catch (err) {
    res.status(400).json({ message: err.message})
}
})

I am aware that using mongoimport could be a more efficient way to handle this, but it also comes with its own set of challenges.

Thank you

javascript database mongodb express mongoose

Answer 1

Answer №1

In agreement with @JDunken's suggestion, one can traverse through the POST body as an array and perform bulk insertion. For efficient processing, utilizing insertMany is recommended. When dealing with a large volume of data, it is advisable to establish a reasonable limit for the number of records per request and execute API calls in batches. Validation can be included, but Mongoose will handle validation based on the defined schema. The approach to handling validation errors is subjective. It is essential to familiarize yourself with the options such as ordered and rawResult.

router.post('/post', async (req, res) => {
  // Precautionary check to ensure req.body is an array, depending on error handling requirements
  const casinos = req.body.filter(input => isValid(input));

  try {
      const insertedCasinos = await CasinoModel.insertMany(casinos, { ordered: false });
      res.status(201).json(insertedCasinos)
  } catch (err) {
      res.status(400).json({ message: err.message})
  }
})

const isValid(input) {
    let valid = true;
    // Implement input validation logic here
    return valid;
}

Answer 2

In agreement with @JDunken's suggestion, one can traverse through the POST body as an array and perform bulk insertion. For efficient processing, utilizing insertMany is recommended. When dealing with a large volume of data, it is advisable to establish a reasonable limit for the number of records per request and execute API calls in batches. Validation can be included, but Mongoose will handle validation based on the defined schema. The approach to handling validation errors is subjective. It is essential to familiarize yourself with the options such as ordered and rawResult.

router.post('/post', async (req, res) => {
  // Precautionary check to ensure req.body is an array, depending on error handling requirements
  const casinos = req.body.filter(input => isValid(input));

  try {
      const insertedCasinos = await CasinoModel.insertMany(casinos, { ordered: false });
      res.status(201).json(insertedCasinos)
  } catch (err) {
      res.status(400).json({ message: err.message})
  }
})

const isValid(input) {
    let valid = true;
    // Implement input validation logic here
    return valid;
}

Adding Multiple Items to an Express Endpoint

Answer №1

Similar questions

Exploring the Intersection of Windows 8 Store Applications and jQuery: Leveraging MSApp.execUnsafeLocalFunction

Can you explain the concept of mounting as defined in the Express documentation?

Having trouble getting your Ajax script to function correctly when submitting a form?

What is the method for producing an li and anchor tag using a list object?

NuxtJS using Babel 7: the spread operator persists in compiled files

Using JavaScript to create a dynamic to-do list that persists on the browser even when refreshed

What is the sequence of the middlewares for error handling and handling of 404 errors?

Tips for extracting JSON data from an API with identical names as values

Mastering the art of building a datepicker: A comprehensive guide

Preserve the ajax controls while uploading files

NodeJs: The local server seems to be stuck on loading and is not displaying any information

Entering a new row and sending information through ajax

After making 5 Ajax get requests, there is no response being received

Remove all spaces from input fields in angular Typescript, excluding the enter key

Error message received from GitHub when attempting to create a repository through the REST API states that JSON cannot

The Aggregation Projection Query encountered an error due to an unrecognized expression

What is the best way to invoke my Python function within my JavaScript file?

Guide for implementing onclick event for info boxes in push pins on Bing Maps using ReactJS

Experiencing trouble with the integration of react native Vector icons in a current project

Tally of number series in an array