NodeJS API with Express and SQL Server database

Question

I have a NodeJS API with Express. In my views, I need to call SQL Server functions like in the following example.

const express = require('express');
const router = express.Router();
const { poolPromise } = require('../dbconfig');

router.use(express.json());

router.post('/addDesc', async(req, res) => {
    try {
        const
            username= req.body.nomUsager,
            descr = req.body.description ;

        const pool = await poolPromise;
        const result = await pool.request().query(`Select dbo.AddDescr('${nomUsager}', '${descr}')`);

        console.log(result.recordset[0]);

        return res.json({
            // I want to return the value returned by me SQL Functions, but the previous console.log() returned {"": "The function value returned"}. Is it possible to return only the value like that : { "the function value returned" }
        });

    } catch (err) {
        return res.json({
            "Fail"
        });
    }
});

module.exports = router

It works fine, however, how do I get only the result returned by my function rather than an object with an unnamed property? (See my console.log ())

I would like not to use an alias, all my sql function and stored procedure is done

joshuamango · Accepted Answer · 2021-02-16 22:15:40Z

1

I am not totally sure if I understand the question but you can get just the string by using:

result.recordset[0][""];.

Using the square brackets with quotes: [""] will help you get the value. However, JavaScript objects are {name: value} pairs so you cannot return a value alone.

answered Feb 16, 2021 at 22:15

joshuamango

2312 silver badges6 bronze badges

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

Collectives™ on Stack Overflow

NodeJS API with Express and SQL Server database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related