Azure / Azure/azure-functions-host

SQL Input Binding parameters does not support single query parameter with comma-separated values

Open
#11,272 0 comments 0 reactions 0 assignees View on GitHub
Needs: Triage (Functions)
Dominant language
C#
Stars
2k
Forks
482
Avg merge
2d 12h
Merged PRs (30d)
38

Description

```
export const sqlInputFlashReportData = input.sql({
commandText: "SOME STORED PROCEDURE",
commandType: "StoredProcedure",
parameters:
"@LotIDs={Query.LotIDs}",
connectionStringSetting: "SqlConnectionString",
});

```

Where LotIDs =` 5659d42f-cdca-44b0-9799-6f1e60fbf6fa,17abde92-9e3a-49bd-b67d-6065ff7a624`

I tried to do solve by below example, but it still does not work. It seems to take only LotIDs = 789

multiple parameters with the same key, like:
`LotIDs=123&LotIDs=456&LotIDs=789`

Pls help

Contributor guide

Open the contributing guide

Research direction

The issue provides no repository file, test, or entry point to start from. Reproduce the SQL input binding configuration with a comma-separated LotIDs value and the repeated-key form, then trace the parameter handling to determine the expected behavior. Done means the supported behavior is implemented and covered by a regression test, or the limitation is documented.

Written by the indexing model from the issue text.

Assessment

Tech stack
azure, csharp, sql
Domain
backend, cloud, database
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
30/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.