Azure / Azure/azure-functions-sql-extension

Feature request: Sql trigger params

Open
#943 1 comment 0 reactions 0 assignees View on GitHub
enhancement P1
Dominant language
C#
Stars
130
Forks
71
Avg merge
4d 8h
Merged PRs (30d)
4

Description

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"
}
]
}
```

Contributor guide

Open the contributing guide

Research direction

The issue names SQL trigger and SQL input bindings but no files or tests. Start by tracing those binding entry points and comparing the requested column-parameter behavior with HTTP trigger parameters; done means trigger columns can populate parameters such as {cost} for the SQL query, with coverage for the example.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, csharp, sql
Domain
backend, databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.