sqlAPI.js

sqlAPI.js

//API.JS

const sql = require('mssql');
const fs = require('fs');
var pool;

var config = {
  server: "serverip\\instance",
  database: "mydatabase",
  user: "myuser",
  password: "mypass",
  port: 1433
}

const sqlConnect = () => {
  pool = new sql.connect(config,err=>{
    if(err){
      console.log("Error connecting database");
    }else{
      console.log("Connected to", config);
    }
  });

  pool.on('error', err=> {
  console.log("error connection db",err);
  });
}
sqlConnect();

const express = require('express');
const https = require('https');
const cors = require('cors');
const app = new express();
app.use(cors());
const port = process.env.PORT || 8080;

const router = express.Router();

router.get('/', (req, res) => {
  res.send("Welcome to my first API");
});

router.get('/getTableData',(req,res)=>{
  const facts = new Promise((resolve,reject)=>{
    pool.on('error', err=> {
    console.log("error connection db2",err);
    reject("Error")
    });

    var query = "select * from mytable";
    var request = new sql.Request(pool);
    request.query(query, (err,result)=>{
      console.log(result.recordsets.length,"lengths");
      resolve(result.recordset);
    });
  });

  Promise.all([facts]).then(data=>{
    res.json({
      factibilidades: data
    })
  });
});


app.use('/api', router);

app.listen(port);
console.log('[API] Listening on port ' + port)

//REACTAPP.JS
  var xhr = new XMLHttpRequest();
    xhr.open("GET", "http://localhost:8080/api/getTableData",false);
    xhr.send();
    var json = JSON.parse(xhr.response);
    //console.log(json);
    let data = json.getTableData.map(d=>{
      return f
    });