app.get("/Products", (req,res)=>{
sql.connect (db,function(err){
if(err)console.log(err);
const request=new sql.Request();
request.input("portfolioId",sql.Int,req.body.portfolioId);
request.execute("GetAllProductList",(function(err, result){
console.dir(result);
res.json(result)
console.dir(err);
}))
output:
{ recordsets: [ [ [Object], [Object], [Object], [Object], [Object], [Object], [Object], [Object], [Object], [Object], [Object], [Object], [Object], [Object], [Object], [Object], [Object], [Object], [Object], [Object], [Object], [Object], [Object] ] ], recordset: [ { ProductName: 'AdminCentre (Elvis - PBX)' }, { ProductName: 'CloudLink Gateway for SMBC' }, { ProductName: 'Mi Cloud Connect' }, { ProductName: 'MiCloud Connect' }, { ProductName: 'MiCloud Flex' }, { ProductName: 'MiCloudConnect' }, { ProductName: 'Mitel Communications Director' }, { ProductName: 'Mitel Standard Linux' }, { ProductName: 'Mitel Virtualization Framework' }, { ProductName: 'MiVoice 5000' }, { ProductName: 'MiVoice 5000 Manager' }, { ProductName: 'MiVoice Business' }, { ProductName: 'MiVoice Business Express' }, { ProductName: 'MiVoice Business for Multi-Instance' }, { ProductName: 'MiVoice Business Multi-Instance' }, { ProductName: 'MiVoice Connect' }, { ProductName: 'MiVoice Connect Contact Center' }, { ProductName: 'MiVoice MX-ONE' }, { ProductName: 'MiVoice Office 250' }, { ProductName: 'MiVoice Office 400' }, { ProductName: 'ShoreTel' }, { ProductName: 'SX-200 ICP' }, { ProductName: 'Telepo' } ], output: {}, rowsAffected: [], returnValue: 0 }
please help me how to remove this recordset,returnvalue , i want only data in this format [{productname:'telco'}]