[email protected]

Kendal, Cumbria, UK

WK Integration Services Ltd

Seamless Solutions, Tailored Integration

Contact Us

General

  • Becareful When Enabling SSH File Transfer Protocol (SFTP) support for Azure Blob Storage

    Becareful When Enabling SSH File Transfer Protocol (SFTP) support for Azure Blob Storage

    wkadmin

    I had enabled SFTP on my blob storage in a personal subscription, not realising the costings: SFTP support for Azure Blob Storage – Azure Storage | Microsoft Learn At the time of writing this post, it is £0.24 per hour just to have the SFTP enabled on the blob storage.  This equates to £40.32 per…

    Know More

  • Using Powershell to Deploy a Logic App using an Office365 API Connection

    Using Powershell to Deploy a Logic App using an Office365 API Connection

    wkadmin

    When using an Azure agent Powershell was available, so the deployment was straight forward: Validate then build the Office365 Connection And the same for the Logic App container with the following app settings In the Release Pipeline I used the Office365 artifact and the Logic App container artifact In the Release Pipeline Stage deployment, I…

    Know More

  • What is Consuming my Azure Service Bus Subscription?

    What is Consuming my Azure Service Bus Subscription?

    wkadmin

    A simple query to discover what service is using my Service Bus Subscription: requests | where source ==’wki-ais-sbus-dev.servicebus.windows.net/unenrolment/Subscriptions/vle’

    Know More

  • BTDF Visual Studio Extension Link

    BTDF Visual Studio Extension Link

    wkadmin

    BizTalk Deployment Framework (BTDF) Visual Studio plugin for BizTalk Server 2020 – SANDRO PEREIRA BIZTALK BLOG (sandro-pereira.com)

    Know More

  • Installing Visio Professional 2019 alongside Microsoft Office 365

    Installing Visio Professional 2019 alongside Microsoft Office 365

    Warren Kinley

    I have Microsoft Office 365 already install, and have a Visio Professional 2019 product key. 1. Create a configuration file: Home – Microsoft 365 Apps admin center (office.com) 2. Download Microsoft Office Deployment Tool: Download Office Deployment Tool from Official Microsoft Download Center 3. Save the configuration file from step 1. into the same directory as the…

    Know More

  • YAML Pipeline with Code Coverage Conditional

    YAML Pipeline with Code Coverage Conditional

    Warren Kinley

     The YAML flow builds the solution of an Azure Function, that contains 3 projects. The unit tests are run and published, and settings are contained in the coverlet.runsettings.xml: <?xml version=“1.0” encoding=“utf-8” ?> <RunSettings>   <DataCollectionRunSettings>     <DataCollectors>       <DataCollector friendlyName=“XPlat code coverage”>         <Configuration>          …

    Know More

  • Application Insights: Types of Availability Tests

    Warren Kinley

    Directly from Microsoft Learn Select an availability test – Training | Microsoft Learn:

    Know More

  • APIM Trace from Postman & Send One-Way Request Policy

    Warren Kinley

     I stumbled upon this: How to Debug and Trace request in Azure APIM – Portal, Postman, RequestBin | Tracing request in Azure APIM (tech-findings.com) Bookmarked for future reference.

    Know More

  • Bicep: Get the Trigger URL for a Consumption Logic App

    Warren Kinley

      resource logicApp ‘Microsoft.Logic/workflows@2016-06-01’ = {   name: logicAppName   location: logicAppLocation   identity: {… }   properties: {…   } } output id         string = logicApp.id output version    string = logicApp.apiVersion output triggerUrl string = listCallbackURL(concat(logicApp.id, ‘/triggers/manual’), logicApp.apiVersion).value

    Know More

  • Deploy Logic App (Std) Workflow Disabled with Bicep/YAML

    Warren Kinley

    In my yaml I send a the workflows in a pipe separated string e.g. “wf-one|wf-two|wf-three|wf-four” Then, in my bicep I populate an array of Workflow states app settings: var wfAppSettingStatuses = [ for wf in split(workflows,’|’): {   name: ‘Workflows.${wf}.FlowState’   value: ‘Disabled’  }] To add to the Logic App container configuration settings use the union function:…

    Know More

  • Ping from an Azure Function App Disabled

    Ping from an Azure Function App Disabled

    Warren Kinley

    Ping from the console was disabled by default but this blog post gave me another option: How to ping from an Azure App service with TCPPING – Code4IT  Ping response: Tcpping response:

    Know More

  • Xslt Transformation with Azure Function

    Warren Kinley

    XsltCompiledTransform does not allow embedded (inline script) code. I came across this github project and need to test this out: brandonh-msft/EmbeddedXsltTestFunction: Demonstrates how to use custom code in an XML Transform from within an Azure Function (github.com) On the face of it the embedded code can be migrated into ExtensionObjects – it sounds perfect!

    Know More

  • Error When Opening Logic App (Standard) Designer in VS Code

    Warren Kinley

    When trying to debug a Logic App (Standard) in Visual Code, I saw the following exception: Running command: “func host start –port 8000″…‘func’ is not recognized as an internal or external command,operable program or batch file.  It seems I was missing the Azure Function Core Tools: See this: https://github.com/Azure/Azure-Functions/issues/2098#issuecomment-969870820

    Know More

  • CRON Special Characters

    Warren Kinley

    This one’s for me: The order of the six fields in Azure is: {second} {minute} {hour} {day} {month} {day of the week}.

    Know More

  • Handle the HTTP 500 Response in APIM

    Warren Kinley

    APIM Add Retry Policy using Policy Fragment A connection that was expected to be kept alive was closed by the server We were seeing many API responses with status code 500 in APIM, with Exception type = BackendConnectionFailure: The underlying connection was closed: A connection that was expected to be kept alive was closed by…

    Know More

  • APIM Policy to Retrieve D365 Bearer Token

    Warren Kinley

    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

    Warren Kinley

    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

    Warren Kinley

    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

    Warren Kinley

    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

    Warren Kinley

     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

Recent Categories

Recent Posts

Post Archive

Catogery Tags

application insights azure service bus