What is the best way to search for a specific item in Express.js?

Question

What is the best way to search for a specific item in Express.js?

I recently got the Leaderboard API issue fixed, but now I'm encountering a new problem with express Querying. Specifically, I'm attempting to search for a specific Discord ID using quick.db as my database. I've included an excerpt of my express.js code below that successfully searches for Different Ban Evidences by ID on another project.

https://website.com/api/levelstats?id=DISCORDID

When I input the Discord ID into the above URL, it should process the URL and display the desired result in an Object: https://i.stack.imgur.com/WDe5j.png

app.get("/api/levelstats",  async function(request, response) {
  response.setHeader('Content-Type', 'application/json');
  if (!request.query.id) return response.send('null');
  let data;
  if (request.query.id !== 'all') data = await db.fetch('60Levelings', {
    target: request.query.id
  });
  else data = await db.fetch('60Levelings');
  if (!request.query.id !== 'all' && data) data.code = qs.parse(data.code).raw;
   response.send(JSON.stringify(data));
})

I attempted a different approach using params, but without success. Any assistance would be greatly appreciated. Thank you.

javascript arrays json express discord.js

Answer 1

Answer №1

Here's a solution you might consider:

app.get("/api/levelstats",  async function(request, response) {
  response.setHeader('Content-Type', 'application/json');
  if (!request.query.id) return response.send('null');
  let data;
  // To compare value only and ignore type data, replace !== with !=
  if (request.query.id != 'all') {
    // Convert request.query.id from string to int if it is not 'all'
    data = await db.fetch('60Levelings', {
      target: parseInt(request.query.id)
    });
    data.code = qs.parse(data.code).raw;
    response.send(JSON.stringify(data));
  }
  else {
    data = await db.fetch('60Levelings');
  }

Answer 2

Here's a solution you might consider:

app.get("/api/levelstats",  async function(request, response) {
  response.setHeader('Content-Type', 'application/json');
  if (!request.query.id) return response.send('null');
  let data;
  // To compare value only and ignore type data, replace !== with !=
  if (request.query.id != 'all') {
    // Convert request.query.id from string to int if it is not 'all'
    data = await db.fetch('60Levelings', {
      target: parseInt(request.query.id)
    });
    data.code = qs.parse(data.code).raw;
    response.send(JSON.stringify(data));
  }
  else {
    data = await db.fetch('60Levelings');
  }

What is the best way to search for a specific item in Express.js?

Answer №1

Similar questions

Mastering Puppeteer: Tips for Successfully Submitting Forms

Tips on how to prevent certain classes from being impacted by a hue-rotate filter applied to all elements on a webpage

Eliminate the need for background video buffering

Transferring SetState from a parent component to a child component in React Native

Identifying when two separate browser windows are both open on the same website

Send an object through the ejs include function

What is the best way to handle the keystroke event in a $.bind method?

Are you on the lookout for an Angular2 visual form editor or a robust form engine that allows you to effortlessly create forms using a GUI, generator, or centralized configuration

"Discovering the method to showcase a list of camera roll image file names in a React Native

Ajax in action

Material UI - The array is unexpectedly resetting to contain 0 elements following an onChange event triggered by the TextField component

Using JavaScript to pre-select a radio button without any user interaction

Display one div and conceal all others

There seems to be a problem with the bundle.js file caused by Uglify

Experiencing Chrome freezing issues due to a setInterval function in combination with React

Using Selenium Webdriver with Node.js to Crop Images

Decoding JSON with HTML in c#

What causes AJAX to disrupt plugins?

Utilizing AJAX in jQuery Mobile for Collapsible Content

When querying for a specific document in mongoose using findById,