Azure SQL Bindings for Functions - Python - ConnectionString Property

Question

I am try to set up an HTTP trigger based Azure Function with SQL input binding and HTTP output binding.

I am getting the following error : Executed 'Functions.HttpTrigger1' (Failed, Id=8698d277-ec47-40c8-b6ec-162077f58d41, Duration=6ms)
[2022-12-10T07:33:35.786Z] System.Private.CoreLib: Exception while executing function: Functions.HttpTrigger1. Microsoft.Data.SqlClient: The ConnectionString property has not been initialized.

Here is my script file :

Here is my local.settings.json

Answer 1

@Krishna Prasanth Thanks for reaching out. Can you please initialize the connectionStringSetting parameter as documented here rather than ConnectionStringSetting. Please also verify that you are passing the right connection string to your app settings variable akrispstring.