Whitelist the outbound IP address of an Azure Web App in the Azure SQL server firewall settings using ARM templates

Question

I want to whitelist the outbound IP address of my Azure Web App in the firewall settings of the Azure sql server using Arm templates. However, I do not want to hardcode the start and end Ip addresses in the ARM template. Is there a way of dynamically adding the Ip addresses in the firewall settings at runtime?

Any help would be greatly appreciated! Thanks

Answer 1

This describes exactly your scenario. However, have you rather considered using Regional VNET integration for your App Service and then using a Subnet-based firewall rule in the SQL DB? I would rather recommend the second solution.