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

Tips for saving JavaScript results to a form

Generate an object in Google Cloud Storage using the Text to Speech Response feature in Adalo

Prevent input from being cleared when selecting an option with React-Select

Accessing Form Data as an Array in a Single Page Application

Encountered an issue with formControlName being undefined during the render process in Angular 2

jQuery - Event cannot be triggered on the 'deselect' or 'focusout' of <option> tag

When attempting to add an object to an array in a collection, there was an issue with

I'm having trouble setting up Stripe Elements in PHP. It seems like there's a communication issue between my PHP code and my JS

Function Errors, How to Fix Them?

Utilizing AngularJS to upload numerous independent attachments to CouchDB

Using & in text leads to segmentation upon transmission to the server

When data is saved to the MongoDB collection, any outdated data is sent to the res() function

Tips for updating the content of a div with the click of another div

What is the best way to apply "display: none;" on a span element nested within a title attribute?

Obtain the data from the hyperlink destination

ActiveSupport changes the way #to_json works in Ruby on Rails

The functionality to download Excel files is malfunctioning in a MEAN stack application

"Responding to an Ajax request with a .NET Core server by sending an xlsx

Extract a free hour from the JavaScript time array without any filtering

Unable to retrieve information using the post method in Express framework