Node.js While loop with Promise

const request = require("request");
var url = "https://localhost:50000/b1s/v2/Login";
var body = {
  CompanyDB: "",
  Password: "",
  UserName: "",
};
var postheaders = {
  "Content-Type": "application/json",
};
var options = {
  url: url,
  method: "POST",
  json: body,
  postheaders: postheaders,
  strictSSL: false,
};
request.post(options, (error, response, body) => {
    if(error){ 
        console.log(error);
    
    } else {
        console.log(body);
    }
});

import { Router } from 'express'
const router = Router()

router.route('/')
    .get((req, res) => {
        res.json('Welcome to my API')
    })


export default router

var hana = require('@sap/hana-client');
var express = require('express');
const { json } = require('express/lib/response');
const { Result } = require('hdb/lib/protocol');

var app = express();
var conn = hana.createConnection();
var conn_params = {
  host        : '',
  port        : '',
  uid         : '',
  pwd         : ''
};

app.get('/:tabla', function (req, res) {
  var nombreTabla  =  req.params.tabla;
  var resultado = "";
  conn.connect(conn_params, function(err) {
    if (err) throw err;
    conn.exec('select top  10 * from JDBC', function (err, result) {
      ///if (err) throw err;
      resultado = result;
      conn.disconnect();
    })
  });
})

var server = app.listen(8081, function () {
  var host = server.address().address
  var port = server.address().port
  console.log("Example app listening at http://%s:%s", host, port)
})