Skip to content

Instantly share code, notes, and snippets.

@justinyoo
Created November 17, 2017 00:35
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Embed
What would you like to do?
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