General

  • APIM Policy to Retrieve D365 Bearer Token

    The policy below adds the “Authorization” header to the backend request.  All token request parameters are added to APIM as Named values.  The “D365-secret” named value points to a secret in the key vault so that it is kept private.  A retry policy is also added in case there is an issue retrieving the bearer…

    Know More

  • Remove Duplicate Rows from a SQL Table

    A small reminder for myself: delete t from ( SELECT * , DupRank = ROW_NUMBER() OVER (               PARTITION BY PurchaseOrderNumber, LineNumber               ORDER BY (SELECT NULL)             ) FROM [PurchaseOrderLines] ) as t where DupRank > 1

    Know More

  • Deploy Azure Durable Function with Zero Downtime

    Requirement To deploy a new version of an Azure Durable Function using Terraform to a Function App with zero downtime Release Pipeline The production deployment is triggered when a modification to the main repository branch is committed.  The production release pipeline path looks like this:   Plan & Apply Steps include the following tasks: Install…

    Know More

  • Connect to Key Vault from a Local Azure Function Instance

    I was having an issue debugging an Azure Function locally.  The start routine loaded the Key Vault secrets into config to be used later: var secretClient = new SecretClient(     new Uri($”https://{keyVault.KeyVaultName}.vault.azure.net/”),    new DefaultAzureCredential());configBuilder.AddAzureKeyVault(secretClient, new AzureKeyVaultConfigurationOptions(){         Manager = new APIKeyVaultSecretManager(keyVault.KeyVaultSecretNames),    ReloadInterval = TimeSpan.FromSeconds(keyVault.ReloadIntervalSeconds)} The problem was I have multiple tenants on…

    Know More

  • Remote Debug Azure Function

     See: Remote debug your azure function app v2 in Visual Studio 2019 – Krish Kothapalli Blog Process: Debug > Attach to process… Key in the functions website address: pop-func-weu-d-justenoughd365import-01.azurewebsites.net:4024                     Found here: VS 2019 port is 4024 You will be asked for credentials, retrieve these from the Azure Portal from the…

    Know More

  • Service Bus Explorer

     Great work here: Service Bus Explorer

    Know More

  • Logic App XML Transform Ignoring XSLT Output Attributes

    It seems Microsoft have still not fixed this one.  When using a XML Transform shape in a Logic App, the output XML always contains the XML declaration and the action shape ignores the omit-xml-declaration=”yes” attribute that is set in the XSLT: <xsl:output omit-xml-declaration=”yes” method=”xml” version=”1.0″ /> See: Remove XML Declaration in XML Transform (microsoft.com) And: Azure Integration…

    Know More

  • Logic App Deployment Failed Due to a Called Azure Function not being Started

    This is where I found the resolution: Encountered an error (Forbidden) from extensions API. – Adventures in Software (benoldfield.co.uk)

    Know More