Skip to content

Instantly share code, notes, and snippets.

@justinyoo
Created November 17, 2017 00:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save justinyoo/91e1a0c4d115637961fe753049b9317c to your computer and use it in GitHub Desktop.
Save justinyoo/91e1a0c4d115637961fe753049b9317c to your computer and use it in GitHub Desktop.
Outbound IP Registration to Azure SQL Using Azure Functions
public static class UpdateFirewallRulesHttpTrigger
{
[FunctionName("UpdateFirewallRulesHttpTrigger")]
public static async Task<HttpResponseMessage> Run(
[HttpTrigger(AuthorizationLevel.Function, "post", Route = "firewall/rules")]HttpRequestMessage req,
TraceWriter log)
{
var tenantId = Config.TenantId;
var subscriptionId = Config.SubscriptionId;
var clientId = Config.ClientId;
var clientSecret = Config.ClientSecret;
var credentials =
SdkContext.AzureCredentialsFactory
.FromServicePrincipal(clientId,
clientSecret,
tenantId,
AzureEnvironment.AzureGlobalCloud);
var logLevel = HttpLoggingDelegatingHandler.Level.Basic;
var azure = Azure.Configure()
.WithLogLevel(logLevel)
.Authenticate(credentials)
.WithSubscription(subscriptionId);
var resourceGroupName = Config.ResourceGroupName;
log.Info($"Firewall rules on database servers in {resourceGroupName} are updating...");
log.Info($"Firewall rules on database servers in {resourceGroupName} have been updated.");
return req.CreateResponse(HttpStatusCode.OK);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment