How to read this JSON correctly? MSSQL and Node

Question

{
  "recordsets": [
    [
      {
        "IdUsuario": 5152490,
        "strNome": "Roberto ",
        "IdPapel": 1
      },
      {
        "IdUsuario": 5152490,
        "strNome": "Roberto ",
        "IdPapel": 3000001
      }
    ]
  ]

I am trying to return to the customer only his permissions (Idpapel), however, I am not getting.

Follows the code that executes the query and brings as a result the JSON presented:

function verify(query, res, user) {
  sql.connect(dbConfig, (err) => {
    if (err) {
      console.log("Error while connecting database :- " + err);
      res.sendStatus(403);
      sql.close();
    } else {
      var request = new sql.Request();
      request.query(query, (err, result) => {
        if (err) {
          console.log("Error while querying database :- " + err);
          res.sendStatus(403);
          sql.close();
        } else {
          res.send(result);
          sql.close();
        }
      });
    }
  });
}

Any hint?

Thank you!

Answer 1

To have an array in which each element is one IdPapel, you need to access the array of users returned by the query to the Database. Assuming the answer is stored in the variable result, we can do:

const respostaDecodificada = result
// Aqui estamos pegando o array com os usuários
const arrayUsuarios = respostaDecodificada.recordsets[0]
// Aqui estamos criando um novo array, com o IdPapel de cada usuário
const arrayIdPapel = arrayUsuarios.map(usuario => usuario.IdPapel)

And after the execution of the code, if we give a console.log(arrayIdPapel) we will receive: [ 1, 3000001 ]. From what you said is what you wanted. Then just do res.send(arrayIdPapel).