Set-AzureWebsite doesn't update ConnectionStrings

[rickrain]

$website = Get-AzureWebsite $websiteName -slot $websiteSlot
$connectionStrings = $website.ConnectionStrings

$result = $connectionStrings.Remove(($connectionStrings | Where-Object {$_.Name -eq $connectionStringName}))

Set-AzureWebsite $websiteName -slot $websiteSlot -ConnectionStrings $connectionStrings

Reference:
http://stackoverflow.com/questions/29648327/cannot-delete-all-azure-website-connection-strings

[NaveenGoli]

I will investigate

Thanks
Naveen

---

From: Rick Raineymailto:notifications@github.com
Sent: ‎4/‎15/‎2015 7:33 PM
To: Azure/azure-powershellmailto:azure-powershell@noreply.github.com
Subject: [azure-powershell] Set-AzureWebsite doesn't update ConnectionStrings (#340)

$website = Get-AzureWebsite $websiteName -slot $websiteSlot
$connectionStrings = $website.ConnectionStrings

$result = $connectionStrings.Remove(($connectionStrings | Where-Object {$_.Name -eq $connectionStringName}))

Set-AzureWebsite $websiteName -slot $websiteSlot -ConnectionStrings $connectionStrings

Reference:
http://stackoverflow.com/questions/29648327/cannot-delete-all-azure-website-connection-strings

---

Reply to this email directly or view it on GitHub:
#340

[martincostello]

Any updates on whether this is definitely a bug?

[NaveenGoli]

Sorry, I have been OOF and didn't get a chance to debug this.

Thanks
Naveen

---

From: Martin Costellomailto:notifications@github.com
Sent: ‎4/‎29/‎2015 6:28 AM
To: Azure/azure-powershellmailto:azure-powershell@noreply.github.com
Cc: Naveen Golimailto:ngoli@hotmail.com
Subject: Re: [azure-powershell] Set-AzureWebsite doesn't update ConnectionStrings (#340)

Any updates on whether this is definitely a bug?

---

Reply to this email directly or view it on GitHub:
#340 (comment)

[winperec]

Any updates on this?

[martincostello]

Any progress on this issue?

[bspunie]

Can we please have an update on this?

[nallurisrinu]

$connStrings = @{ AzureWebJobsDashboard = @{ Type = "Custom"; Value = $AzureWebJobsDashboard };
AzureWebJobsStorage = @{ Type = "Custom"; Value = $AzureWebJobsStorage }};

Set-AzureRMWebApp -Name $webServiceName -ResourceGroupName $rgName -ConnectionStrings $connStrings

[cormacpayne]

@twitchax: "Azure PowerShell continues to maintain RDFE support on a legacy basis: new functionality and bug fixes are addressed sparingly. This issue does not meet the current threshold for consideration."

[mganeshphani]

Just for the sake of people who reach this thread via Google/Bing .. looks like nallurisrinu's suggestion is working out here...

$connStrings = @{ AzureWebJobsDashboard = @{ Type = "Custom"; Value = $AzureWebJobsDashboard };
AzureWebJobsStorage = @{ Type = "Custom"; Value = $AzureWebJobsStorage }};
Set-AzureRMWebApp -Name $webServiceName -ResourceGroupName $rgName -ConnectionStrings $connStrings

[umaknow-jeanluc]

Also for people searching for this error :

Cannot validate argument on parameter 'ConnectionStrings'. Connection string type must be specified.

The Type value in the HashTable must be the string, explicitly, with .ToString().

$connStringsList = $webApp.SiteConfig.ConnectionStrings
$hashItems = New-Object System.Collections.HashTable
ForEach ($keyValuePair in $connStringsList) {
    $setting =  @{Type=$keyValuePair.Type.ToString();Value=$keyValuePair.ConnectionString.ToString()}
    $hashItems.Add($keyValuePair.Name,$setting);
}
Set-AzureRmWebApp -ResourceGroupName $resourceGroupName -Name $appServiceName -ConnectionStrings $hashItems

[xaviermignot]

@umaknow-jeanluc thanks a lot for your brilliant comment, you saved my day \o/