Configure route for dynamic query in API Express

Question

I'm working in this API where I can access data for many queries, but I'm having problems to retrieve data for a query by name containing (like:%data%), with dynamic data. I think it might just be a problem configuring the route so I can have access to this data in the URL api/data/dynamicdata.

Here's what I have - the controller:

const { Op } = require('sequelize');
const Artisan = require ('../models/artisan');

exports.getByName = async (req, res, next) => {
    
 try {
    const { nom } = req.params;

    const artisan = await Artisan.findAll({
      attributes: { exclude: ['createdAt', 'updatedAt'] },
      where: {nom: {[Op.like]: `%${nom}%}`},
    }});
    
    if (artisan) {
            return res.status(200).json(artisan);
        }
        return res.status(404).json('user_not_found');
    } catch (error) {
      console.error('Erreur dans /artisan :', error);
      res.status(500).json({ error: 'Failed to fetch artisan' });
    }
};

The route

var express = require('express');
var router = express.Router();
const service = require ('../services/artisans');

router.get ('/', service.getAll);
router.get ('/nom', service.getByName);

module.exports = router;

The app

const artisanNom = require('./routes/artisans');

app.use('/artisans/',artisanNom);

If I try to access the data from the URL localhost:3000/artisans/nom?=data, it returns me an empty array. If I put a static data in my controller localhost:3000/artisans/nom, it returns the data I expected, so this route is working for static data so it seems either I don't know how to retrieve the result from the URL using dynamic data, or I might configure the route differently.

I'd be grateful for any help.

Ayush · Accepted Answer · 2025-06-17 10:36:07Z

0

From what I could understand, you want to extract whatever is sent to the route (/artisans/nom) in place of nom. That is what you are trying to extract in const { nom } = req.params; .

If this is correct, then you simply have a typo in route registration.
In place of router.get ('/nom', service.getByName), it needs to be /:nom. This is what makes the parameter dynamic.
Resource: Search for app.param here -> https://expressjs.com/en/4x/api.html

On the other hand, the way you are passing your query parameter here: ?=data is also incorrect. The query needs to have a key=value. Eg. ?nom=data and you would fetch that via { nom } = req.query.

answered Jun 17 at 10:36

Ayush

1141 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

BoulayM Jun 17 at 13:33

Thanks Ayush, I tried that and my URL localhost:3000/artisans/dynamicdata returns me that: [ ].

BoulayM Jun 18 at 8:03

Hello Ayush, I found the error, there was an extra curly brace in my async function that was returning me a query for ... WHERE nom LIKE %data } %. Thanks for your answer.

Collectives™ on Stack Overflow

Configure route for dynamic query in API Express

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related