Default query parameter values in Azure Functions bindings

Question

I am using the Azure Functions SQL Extension.

I have an endpoint with the following parameters (documentation).

"parameters": "@Limit={Query.limit},@Status={Query.status}",

Does anyone know whether it's possible to assign default/null values to Query parameters? E.g. if i don't specify status in my HTTP query string i want it to be null.

Currently it fails with the message:

Error while accessing 'status': property doesn't exist

PramodValavala · Accepted Answer · 2023-01-17 18:24:38Z

1

There is no way to set default values. Here are alternatives you could consider

If using C#, then you can Bind at Runtime
Use a separate HTTP function that would call the function with the SQL binding after validating and setting defaults. You could even consider Durable Functions here, if it makes sense for your scenario
Directly use the SQL SDK

answered Jan 17, 2023 at 18:24

PramodValavala

6,6701 gold badge16 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Default query parameter values in Azure Functions bindings

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related