Storage account connection string does not exist - deploying Queue storage trigger for Azure Functions

Question

I want to create an azure storage queue triggered azure function. I went through the following tutorial https://learn.microsoft.com/en-us/azure/azure-functions/functions-bindings-storage-queue-trigger

I basically want to trigger the function whenever a message is pushed into the queue and push the result back to another queue once a function is finished.

function.json

{
  "bindings": [
    {
      "name": "input",
      "type": "queueTrigger",
      "direction": "in",
      "queueName": "queue-trigger",
      "connection": ""
    },
    {
      "type": "queue",
      "direction": "out",
      "name": "output",
      "queueName": "queue-receiver",
      "connection": ""
    }
  ]
}

When i deployed the function, then I am getting the following error in logs present in monitor.

2022-09-10T12:16:53.412 [Error] The 'QueueTrigger' function is in error: 

Microsoft.Azure.WebJobs.Host: Error indexing method 'Functions.QueueTrigger'. 

Microsoft.Azure.WebJobs.Extensions.Storage.Queues: Storage account connection string 'AzureWebJobs<storage account name>_STORAGE' does not exist. Make sure that it is a defined App Setting.

You can see I have defined, three application settings.

AzureWebJobs<storage account>_STORAGE
AzureWebJobsStorage
<storage account>_STORAGE

According to documentation, if connection is empty in function.json then AzureWebJobsStorage will be used.

Even i tried to set connection:"<storage account>_STORAGE", that also raised the same error.

As you left the connection property empty, have you set the value of AzureWebJobsStorage to point to the queue's conn string ? — Anand Sowmithiran
– Anand Sowmithiran, Commented Sep 11, 2022 at 10:54
I assume in the actual deployed function, connection is explicitly set to "AzureWebJobs<storage account>_STORAGE" in your function.json file ? — Mo Nazemi
– Mo Nazemi, Commented Sep 11, 2022 at 12:17

RithwikBojja · Accepted Answer · 2022-09-12 05:01:06Z

1

I have reproduced in my environment, and the below workaround worked for me:

I have created a storage account and copied the connection as below and i created a queue too over there as below enter image description here

Then i pasted it in local.settings file in vs studio as below:

enter image description here

And now i published it too azure. Click on App setting in Configuration , if Connection string name is present then open that and paste the connection string. If not Then in published function app i created a connection string in application settings and copied the same connection string that i have taken from Storage account enter image description here

enter image description here Then click on ok then save it. Then send message in queue as below: And this workaround worked for me.

edited Sep 12, 2022 at 5:01

answered Sep 11, 2022 at 16:55

RithwikBojja

12k2 gold badges5 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Storage account connection string does not exist - deploying Queue storage trigger for Azure Functions

function.json

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

function.json

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related