Hi @dhanasekar
In GIT now, under branch params
(link)
I have contacted a co-author regarding publishing a beta to NPM but until then, you can install from github if you feel up to it? you can git clone https://github.com/bestlong/node-red-contrib-mssql-plus.git
and npm install ~/node-red-contrib-mssql-plus
- OR - install direct from github npm install bestlong/node-red-contrib-mssql-plus#params --save
Notes...
UDT and some other types are "not supported" (this is a tedious
driver limitiation)
TVP can only be used with stored procedure (this is tedious
driver stipulation)
Using the example sql type and procedure here, you would need data in the value to be in the following format...
{
"columns": [
{
"name": "a",
"type": "VarChar(50)"
},
{
"name": "b",
"type": "Int"
}
],
"rows": [
[ "hello tvp", 777 ],
[ "bye tvp", 888 ],
[ "call the cops", 999 ]
]
}
this flow works with the above example...
[{"id":"3eb71b1f.47fdb4","type":"MSSQL","z":"595a5dd5.a963a4","mssqlCN":"a51e405c.10f64","name":"","query":"MyCustomStoredProcedure","outField":"payload","returnType":"1","throwErrors":"0","queryMode":"execute","params":[{"output":false,"name":"tvp","type":"TVP(TestType)","valueType":"json","value":"{\"columns\":[{\"name\":\"a\",\"type\":\"VarChar(50)\"},{\"name\":\"b\",\"type\":\"Int\"}],\"rows\":[[\"hello tvp\",777],[\"bye tvp\",888],[\"call the cops\",999]]}"}],"x":500,"y":520,"wires":[["bfde3540.a91018"]]},{"id":"614325ad.afd22c","type":"inject","z":"595a5dd5.a963a4","name":"","topic":"","payload":"","payloadType":"date","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":500,"y":480,"wires":[["3eb71b1f.47fdb4"]]},{"id":"bfde3540.a91018","type":"debug","z":"595a5dd5.a963a4","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","x":510,"y":580,"wires":[]},{"id":"a51e405c.10f64","type":"MSSQL-CN","z":"","tdsVersion":"7_4","name":"Local SQL","server":"192.168.99.99","port":"1433","encyption":false,"database":"testdb","useUTC":false,"connectTimeout":"15000","requestTimeout":"15000","cancelTimeout":"5000","pool":"5","parseJSON":false}]