Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

Get the parameter value from Db using msnodesqlv8 in nodejs

var sqlParams = [];

 sqlParams=[
    {
        "name": "Name",
        "type": "sql.varchar",
        "value": "anshul"
    },{
        "name": "mob",
        "type": "sql.varchar",
        "value": "96"
    }];



 console.log(sqlParams[0].value);

pm.callproc('GetUser',[sqlParams[0].value,sqlParams[1].value], function(err, results) {

            if(err){
                console.log("Error in executing procedure :: "+err);
            }
            else{
                console.log('Procedure call success');
                console.log(results);
            }
        });

  });   

My requirement is that I will be getting the column from the key value by putting pm.callproc('GetUser',sqlParams, function(err, results) rather than putting pm.callproc('GetUser',[sqlParams[0].value,sqlParams[1].value], function(err, results) {

Comments