Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature request: Sql trigger params #943

Open
IlyaGazman opened this issue Oct 10, 2023 · 1 comment
Open

Feature request: Sql trigger params #943

IlyaGazman opened this issue Oct 10, 2023 · 1 comment
Labels
enhancement New feature or request P1
Milestone

Comments

@IlyaGazman
Copy link

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"
      }
    ]
  }
@chlafreniere chlafreniere added the enhancement New feature or request label Oct 10, 2023
@JetterMcTedder
Copy link

Thank you IlyaGazman for the feature request. We will take a close look at this. It would also be useful in output bindings for moving specific data from one place to another based on a trigger. Less code is always a good thing.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request P1
Projects
None yet
Development

No branches or pull requests

4 participants