azure-functions-sql-extension
azure-functions-sql-extension copied to clipboard
Feature request: Sql trigger params
When triggering via SQL, it would be awesome if you could allow the columns in the trigger to be used in the input binding, like it is done with HTTP trigger params.
Example
{
"bindings": [
{
"name": "changes",
"type": "sqlTrigger",
"direction": "in",
"tableName": "[dbo].[Products]",
"params": ["Cost"]
"connectionStringSetting": "AzureSQLConnectionString"
},
{
"name": "products",
"type": "sql",
"direction": "in",
"commandText": "select * from Products where Cost = @Cost",
"commandType": "Text",
"parameters": "@Cost={cost}",
"connectionStringSetting": "SqlConnectionString"
}
]
}