Missing value for AzureWebJobsStorage in local.settings.json local development in Visual Studio 2017

Question

I'm developing a azure function locally, with the Storage Emulator and de Storage Explorer opened.

File tree

local.settings.json

{
  "IsEncrypted": false,
  "Values": {
    "AzureWebJobsStorage": "UseDevelopmentStorage=true",
    "AzureWebJobsDashboard": "UseDevelopmentStorage=true"
  },
  "ConnectionStrings": {
    "PlantaoEntities": {
      "ConnectionString": "CENSORED",
      "ProviderName": "System.Data.EntityClient"
    }
  }
}

But a receives the following message when trying to run the code:

Missing value for AzureWebJobsStorage in local.settings.json. This is required for all triggers other than HTTP. You can run 'func azure functionapp fetch-app-settings ' or specify a connection string in local.settings.json

It's was working before a rebuild solution, and if I try func azure functionapp fetch-app-settings <functionAppName> it try to retrieve the information from the azure portal itself.

I had the same problem, here is the easiest solution I followed: https://stackoverflow.com/a/72983736/12824729 — MarchalPT, Jul 14 '22 at 16:23

score 93 · Accepted Answer · answered Feb 21 '18 at 14:16

93

The solution was to right-click on local.settings.json, go to properties, change "Copy to Output directory" from "Do not copy" to "Copy always". Now the CLI picks up the settings when running from within Visual Studio 2017.

https://github.com/Azure/azure-functions-core-tools/issues/223#issuecomment-326225219

answered Feb 21 '18 at 14:16

rubens.lopes

2,265
1
18
23

4

There is no "Properties" – leonheess Nov 25 '19 at 13:11
3

This is only when you have your project on VS, not vscode with node. – makitocode Feb 27 '20 at 14:48
1

@makitocode what's the solution in vscode with node? – Jono Suave Sep 10 '20 at 22:39
1

@JonoSuave Always – SamiHuutoniemi Oct 13 '20 at 08:31
5

@SamiHuutoniemi Where do I add this configuration? – mneumann Jan 31 '22 at 09:29
This worked for me in VS 2022 also – KRM Jan 08 '23 at 18:59

Sibeesh Venu · Answer 2 · 2023-05-16T11:04:36.300

I was getting the same error when I was running my Azure Function in my Visual Studio 2019.

I had already set the Copy To Output Directory action to Copy always and I was still getting the same error. The issue is that the Azure Function local.settings.json file doesn't support nested json. You can track this issue here.

I was having values in local.settings.json as preceding.

{
  "IsEncrypted": false,
  "Values": {
    "Custom": {
      "Tickets": {
        "Channels": [
          "One",
          "Two"
        ]
      }
    },
    "AzureWebJobsStorage": "",
    "FUNCTIONS_WORKER_RUNTIME": "dotnet",
    "ServiceBusConnectionString": ""
  }
}

As you can see that there is an extra nested json (Custom) object inside Values, that is the reason why I was getting this error. To fix this, I had to add a new configuration file called configuration.json and add my custom values there.

"Custom": {
      "Tickets": {
        "Channels": [
          "One",
          "Two"
        ]
      }
    }

The fix is to use either the ConfigurationBuilder or read that file using File.ReadAllText. You can also add the entire JSON as a plain string in the local.settings.json instead of a JSON object.

Or you can add the custom configs under the Values JSON object as below.

"CustomConfigs:Config1": "",
"CustomConfigs:Config2:Config3": ""

And use a binding in the Startup file.

builder.Services.AddOptions<CustomConfigs>()
.Configure<IConfiguration>((settings, configuration) =>
{                    configuration.GetSection("CustomConfigs").Bind(settings);
});

Just make sure that you clean the solution and build again after the change above.

Thanks, this was it for me. In my case, I needed arrays, so I formatted my custom values like so: https://stackoverflow.com/a/34063168/348375, and it worked. — joe, May 08 '20 at 22:44
Thanks, this was the same thing that happened to me as well :) — HariHaran, Sep 03 '21 at 10:35
This answer has now saved med twice as I forgot about the limitation and had the same problem in a brand new .net 6 function app created with vs2022. I see the issue has been closed as obsolete, not sure why if it is still an issue. Would be much easier if appsetting.json and local.settings.json behaved the same so I didn't have to keep track of stuff like this. — Tarostar, Feb 02 '22 at 12:28

score 27 · Answer 3 · edited May 18 '21 at 04:39

27

FYI, you also get this error when the value for "AzureWebJobsStorage" is effectively empty (""). You can set it to e.g. "UseDevelopmentStorage=true" for development.

Be aware, this requires the storage emulator installed locally. See the docs.

edited May 18 '21 at 04:39

alexanderdavide

1,487
3
14
22

answered Nov 12 '19 at 12:10

Benjamin

1,983
23
33

score 17 · Answer 4 · answered May 12 '20 at 12:40

17

Just saw this error on VS2019 and resolved it by reordering the local.settings.json so that the IsEncrypted value was after the "Values"

{
   "Values": {
        "AzureWebJobsStorage": "removed",
      },
   "IsEncrypted": false
}

answered May 12 '20 at 12:40

ChrisR

171
1
2

Excellent! The other issues sounds reasonable enough but this solved it! – Tomas Hesse May 28 '20 at 10:12
2

WT...... this works. Nothing was wrong in my local.settings.json because it worked with the same content before. Suddenly it stopped working. Tried everything, clean solution, rebuild, removing bin and obj dirs manually, restart laptop... Nothing worked. Now it does !!! – Dennis Oct 28 '20 at 16:10
I hate that this is a valid answer because it is so stupid that we have to do things like that with MS config files. Order in a flat file for json should never matter. – Charles Boyung Aug 17 '22 at 20:54

score 12 · Answer 5 · answered Jun 29 '20 at 17:17

12

Same error appears when your local.settings.json file has a json error, e.g. to following commas ,,.

answered Jun 29 '20 at 17:17

kagetoki

4,339
3
14
17

score 6 · Answer 6 · answered Sep 10 '20 at 22:40

6

In case any of the above solutions aren't working for people who require nested JSON in their local.settings.json, just flatten the nested objects as so:

This:

"Config": {
 "MyCusomValue": "Value"
}

Becomes:

"Config:MyCustomValue": "Value"

answered Sep 10 '20 at 22:40

Bret Faller

251
3
5

score 5 · Answer 7 · answered Aug 03 '19 at 13:54

5

For anyone that may have encountered this and scratched their heads because they didn't have nested JSON and had their <ItemGroup> values correct, this may help you. Since local.settings.json is ignored, I had copied one over using the file system, and though Visual Studio for Mac was showing it in the solution explorer it was apparently not picking it up no matter what I changed <CopyToOutputDirectory> to. After closing and reopening my solution the issue went away.

answered Aug 03 '19 at 13:54

Robb Vandaveer

1,481
20
25

1

Same for me on Windows. Something in visual studio is getting stuck... It's funny that there are so many different issues out there when you search for problems and the azure functions support is so finicky that a simple VS restart is the last thing that came to mind. Thanks! – Jason Goemaat Apr 21 '20 at 12:18

score 5 · Answer 8 · edited May 13 '21 at 12:42

Solution - Azure Functions Node.js/Typescript (VSCODE)

This solution is for local development. Be aware, this requires the storage emulator installed locally. See the docs.

1.) From your project root, open local.settings.json and update the AzureWebJobsStorage value from "" to UseDevelopmentStorage=true.

example: "AzureWebJobsStorage": "UseDevelopmentStorage=true",

2.) Restart Function App

Example local.setting.json

{
  "IsEncrypted": false,
  "Values": {
    "AzureWebJobsStorage": "UseDevelopmentStorage=true"
    "FUNCTIONS_WORKER_RUNTIME": "node",
    "AZURE_STORAGE_CONNECTION": "Optional_your_remote_storage_string_in_azure"
    "AZURE_STORAGE_CONTAINER_NAME": "optional_remote_container_name"
  },
  "Host": {
    "LocalHttpPort": 7071,
    "CORS": "*",
    "CORSCredentials": false
  }
}

René K · Answer 9 · 2021-05-12T21:32:39.213

5

I know the question is related to Visual Studio, but I could fix the error by doing the following in Visual Studio Code:

Install the "Azurite" extension
Press F1 and type Azurite: Start
Debug your Azure Function as usual (by pressing F5)

For more details see the official documentation for Azurite

edited May 12 '21 at 21:32

answered May 12 '21 at 21:27

René K

337
5
14

score 2 · Answer 10 · answered Aug 12 '22 at 14:21

I follow this and it works:

Modify your .csproj file to have this:

<None Update="local.settings.json">
<CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
<CopyToPublishDirectory>PreserveNewest</CopyToPublishDirectory>
</None>

for more information, check this link: https://www.koskila.net/how-to-fix-missing-value-for-azurewebjobsstorage-in-local-settings-json-when-youre-debugging-azure-functions-locally/

score 1 · Answer 11 · answered Mar 31 '23 at 16:46

Have fixed error by switching Copy to Output Directory property for local.settings.json file from Copy if newer to Copy always.

In my local local.settings.json file AzureWebJobsStorage contains actual connection copied from Storage account -> Security + networking -> Access keys -> key1 -> Connection string

score 1 · Answer 12 · answered Apr 28 '23 at 09:50

1

Make sure you have local.settings.json, its spelling is correct and cs proj must have:

<None Update="local.settings.json">
  <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
</None>

answered Apr 28 '23 at 09:50

Priyank Kotiyal

241
2
13

score 0 · Answer 13 · answered Oct 24 '20 at 10:26

0

For me I found this file to be very finicky so I set it back to the way it was created by VS2019 and added my own configuration as has been suggested above.

answered Oct 24 '20 at 10:26

Larry Aultman

301
2
10

score 0 · Answer 14 · edited Nov 25 '22 at 08:32

0

Update the local setting below

{
  "Values": 
  {
  "AzureWebJobsStorage": "DefaultEndpointsProtocol=`connection string of a blob storage`",
  "FUNCTIONS_WORKER_RUNTIME": "python"
  },
  "IsEncrypted": false
}

Sample connection

string=https;AccountName=xxx;AccountKey=xxxxxxx==;EndpointSuffix=core.windows.net

edited Nov 25 '22 at 08:32

Dhanil Dinesan

575
9
27

answered Jan 24 '21 at 08:24

Abhiraj CS

5
1

score 0 · Answer 15 · answered Feb 02 '21 at 09:42

0

For me, I was missing a closing quote on one of my values. As soon as I fixed that, everything worked.

answered Feb 02 '21 at 09:42

Peter Morris

20,174
9
81
146

score 0 · Answer 16 · edited Dec 13 '21 at 03:59

This could also happen if you declare an string array on the settings since it is not supported. I had something like this:

{
  "IsEncrypted": false,
  "Values": {
    "AzureWebJobsStorage": "UseDevelopmentStorage=true"
    "FUNCTIONS_WORKER_RUNTIME": "node",
    "AZURE_STORAGE_CONNECTION": "Optional_your_remote_storage_string_in_azure"
    "AZURE_STORAGE_CONTAINER_NAME": "optional_remote_container_name",
    "AllowedTypesToProcess": 
    [
        "MyType1",
        "MyType2",
        "MyType3"
    ]
  },
  "Host": {
    "LocalHttpPort": 7071
  }
}

Since arrays are not supported, it failed to load the settings, but the error says "Missing value for AzureWebJobsStorage in local.settings.json"

If you need to have an array of the settings, take a look to this: https://www.titanwolf.org/Network/q/9256d500-5dbc-4375-851d-4d6f13928945/y

score 0 · Answer 17 · answered May 20 '22 at 18:12

I got mine to work by making sure the connection value ended with _STORAGE.

function.json

{
  "scriptFile": "__init__.py",
  "bindings": [
    {
      "name": "blob",
      "type": "blobTrigger",
      "direction": "in",
      "path": "container/{name}",
      "connection": "mystorage_STORAGE"
    }
  ]
}

local.settings.json

{
  "IsEncrypted": false,
  "Values": {
    "FUNCTIONS_WORKER_RUNTIME": "python",
    "FUNCTIONS_EXTENSION_VERSION": "~4",
    "WEBSITE_CONTENTAZUREFILECONNECTIONSTRING": "DefaultEndpointsProtocol=https;AccountName=xxx;AccountKey=yyy==;",
    "AzureWebJobsStorage": "DefaultEndpointsProtocol=https;AccountName=xxx;AccountKey=yyy==;",
    "mystorage_STORAGE": "DefaultEndpointsProtocol=https;AccountName=xxx;AccountKey=yyy==;"
  },
  "ConnectionStrings": {}
}

score 0 · Answer 18 · answered Apr 07 '23 at 16:40

0

If the spelling of the file local.settings.json is wrong, Visual Studio wont find it, but report that the values are not provided.

This is worked for me.

Please check the local.settings.json file name is correct.

answered Apr 07 '23 at 16:40

vinoth kumar

1

score 0 · Answer 19 · answered May 10 '23 at 14:23

0

in my case i had to do this

  <None Update="local.settings.json">
  <CopyToOutputDirectory>Always</CopyToOutputDirectory>
  <CopyToPublishDirectory>Always</CopyToPublishDirectory>
</None>

answered May 10 '23 at 14:23

Raas Masood

1,475
3
23
61

Atchaya Suresh · Answer 20 · 2023-06-09T15:24:29.623

0

Check once if the local.settings.json is in the same level as the azure functions folder. The function expects the value in this way.

For example:

 functions
 local.settings.json
     EventhubTrigger
        function.json

 local.settings.json
 EventhubTrigger
     function.json

edited Jun 09 '23 at 15:24

answered Jun 09 '23 at 15:20

Atchaya Suresh

1
1

score 0 · Answer 21 · answered Jul 25 '23 at 13:07

0

Check if your local.settings.json doesn't have an invalid value in it! For me a was missing a backslash, causing invalid character escaping in my connectiong string.

answered Jul 25 '23 at 13:07

Enrico

2,734
1
27
40

score -1 · Answer 22 · answered Apr 02 '21 at 14:52

I just encounter same issue with Intellij Idea (didn't wanted to move on VSCode). I just had to download Azure Core tools depending on my system (Windows, forced by the client -_-) on :

https://learn.microsoft.com/en-us/azure/azure-functions/functions-run-local?tabs=windows%2Ccsharp%2Cbash

Then edit the launch config, adding in App settings key :

AzureWebJobsStorage

And in App settings value :

UseDevelopmentStorage=true

Have fun.

score -1 · Answer 23 · answered Jun 03 '21 at 11:39

-1

I fixed this issue finally, it is because of your config files like local.settings.json or appsettings.json show any warning messages then it will fail to load the settings.

answered Jun 03 '21 at 11:39

Muni Chittem

988
9
17

score -1 · Answer 24 · answered Nov 05 '21 at 00:35

-1

Another gotcha:

If the spelling of the file local.settings.json is wrong, Visual Studio wont find it, but report that the values are not provided.

answered Nov 05 '21 at 00:35

Fin McCarthy

49
1
2

Missing value for AzureWebJobsStorage in local.settings.json local development in Visual Studio 2017

24 Answers24

Linked