Requesting data from a REST API using a nested query in a GET

Question

Requesting data from a REST API using a nested query in a GET

After querying data from my MongoDB database, I am faced with the challenge of sending a GET request from the front end to meet this specific query. In my backend code, I retrieve the data using the following:

const products = await Product.find({
    'backCamera.sensor.megaPixels': { $gte: 8 }
  })

I attempted to send a GET request in the frontend using the approach below, but unfortunately, it did not yield the expected results:

I've tried this way but didn't work

fetch('http://localhost:5000/api/v1/products?backCamera.sensor.megaPixels[gte]=8')
      .then(response => response.json())
      .then(data => console.log(data));

Furthermore, I also experimented with incorporating query params in the backend, however, I encountered issues that prevented its successful execution.

javascript database mongodb rest mongoose

Answer 1

Answer №1

To begin with, there is no requirement to directly match the query from the URL with the backend or send it as is. This means you don't have to use something like

api/v1/products?backCamera.sensor.megaPixels[gte]=8

. Instead, a more efficient approach would be to pass a simplified version such as

api/v1/products?backCamSensorMinPx=8

, which can then be extracted and validated on the backend using req.query. This method not only addresses potential security vulnerabilities (especially if utilizing SQL), but also adheres to best practices by separating core logic from database implementation.

Answer 2

To begin with, there is no requirement to directly match the query from the URL with the backend or send it as is. This means you don't have to use something like

api/v1/products?backCamera.sensor.megaPixels[gte]=8

. Instead, a more efficient approach would be to pass a simplified version such as

api/v1/products?backCamSensorMinPx=8

, which can then be extracted and validated on the backend using req.query. This method not only addresses potential security vulnerabilities (especially if utilizing SQL), but also adheres to best practices by separating core logic from database implementation.

Answer 3

Answer №2

To retrieve the entire content dynamically using the URL, where the parameter backCamera.sensor.megaPixels is dynamic, you can follow this approach:

// Frontend
fetch('http://localhost:5000/api/v1/products?product=backCamera.sensor.megaPixels&minimum=8')
      .then(response => response.json())
      .then(data => console.log(data));

// Backend
// Extract the parameters product and minimum from the URL
const products = await Product.find({
    [product]: { $gte: minimum }
  })

Answer 4

To retrieve the entire content dynamically using the URL, where the parameter backCamera.sensor.megaPixels is dynamic, you can follow this approach:

// Frontend
fetch('http://localhost:5000/api/v1/products?product=backCamera.sensor.megaPixels&minimum=8')
      .then(response => response.json())
      .then(data => console.log(data));

// Backend
// Extract the parameters product and minimum from the URL
const products = await Product.find({
    [product]: { $gte: minimum }
  })

Requesting data from a REST API using a nested query in a GET

Answer №1

Answer №2

Similar questions

Instead of using colons, display the separation of hours, minutes, and seconds with underscores

``Protect your PDF Document by Embedding it with the Option to Disable Printing, Saving, and

How come my effort to evade quotation marks in JSON isn't successful?

Ways to add a substantial quantity of HTML to the DOM without relying on AJAX or excessive strings

Issue with Jquery function not executing on second attempt

Display the returned view following an AJAX request

Rgd: Double-Sided Horizontal Slide Control

React Weather App: difficulties entering specific latitude and longitude for API requests

I want to display events from my database table on their corresponding dates using JavaScript and jQuery. How can I achieve this?

Step-by-step guide on how to activate a colorbox using a targeted Id or class

Angular filter that replaces underscores with spaces

Ways to extract a specific element from a webpage's body section

Mongoose 5 unexpectedly encounters the error message "MongoError: unrecognized string alias for $type: 2dsphere"

The Docker build encountered an error due to confusion with MERN dependencies

Understanding the moment when the DOM is fully rendered within a controller

Unable to reach 'this' within a nested function

When the properties change, React Router Redux does not get rendered

Next.js Error: The text displayed on the page differs from the HTML rendered by the server

Looking for a versatile jQuery plugin that enables right-click functionality across different browsers?

Troubleshooting AWS S3 SDK upload error when sending data from Next.js API endpoint hosted on Vercel - ERR_HTTP_HEADERS_SENT