We're using VSTS for building various Azure Web Apps and deploying them to different environments. During the release process we are performing transformations on Web.config files, using variables stored in VSTS for things like connection strings per environment.
We want to do a similar thing with Azure Functions but we've had issues. We've found that performing transforms to the appsettings.json file doesn't work. New key/value pairs added aren't working in Azure and changes to existing ones aren't being loaded in Azure.
I've looked through countless documents and have only found documentation stating that app settings for Azure Functions must be stored using the Azure Portal, or set using a PowerShell script during the release process. However, these solutions then expose connection strings and other secrets to anyone who has access to the Azure Portal, which is not what we want.
How can I provide app settings to Azure Functions, such as the AzureWebJobsStorage and AzureWebJobsDashboard values, without exposing them on the Azure Portal?