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'}]