General

  • Testing DotLiquid Maps Locally

    Testing DotLiquid Maps Locally

    Hurray! I have found a way to test before deployment for my liquid maps used in Azure. Thanks to finding this blog post: https://skastberg.com/2019/01/20/test-your-liquid-transformations-without-deployment/ And then this GitHub repos: https://github.com/skastberg/LiquidTransformation An example command is as simple as: “d:\TestingLiquid\LiquidTransform.exe” -t “d:\repos-wk\MyProject\logicapp\artifacts\Maps\This_To_That.liquid” -c “c:\temp\logicapp_input.json” -d “c:\temp\output.json” -u Such a time saver, and even gives great exceptions –…

    Know More

  • Share Files, Folders or Drives Between Host and Hyper-V Virtual Machine

    Share Files, Folders or Drives Between Host and Hyper-V Virtual Machine

    I found a useful post about this which saved me time in writing the same:  Share Files, Folders or Drives Between Host and Hyper-V Virtual Machine

    Know More

  • Bicep Deployment of APIM API Operations

    Problem: Deploy your API Operations into APIM using BICEP Existing Deployment: Simple deployment (no request or response definitions etc…) Using a YAML driver:   – template: ../apimanagement/cli/apis/APIM.AddApi.yaml     parameters:       azureServiceConnection: ${{ parameters.azureServiceConnection }}       resourceGroupName: ‘$(coreResourceGroupName)’       apiManagementServiceName: ‘$(coreApimInstance)’       name: ‘oracle-erp-internal-api’       displayName: ‘Oracle ERP Internal API’       description: ‘Oracle Internal API for ERP’       path: ‘/oracle/internal/erp’ – template: ../apimanagement/cli/apis/APIM.AddApi.Operation.yaml     parameters:       azureServiceConnection: ${{ parameters.azureServiceConnection…

    Know More

  • Retrieving Bicep Output Variables between Yaml Tasks

    In the Bicep file you can output variables: output laPrincipalId string = logicAppResource.identity.principalId So how do I then pass these to another Yaml task? My first research found this perfect discussion: BICEP Output to Pipeline Variables #4638 So this is the task that populates the output variables as pipeline variables after the create resource task:…

    Know More

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

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

    Since moving to a self-hosted agent I did not have Powershell available or the bash command to parse JSON, jq. If you have installed Powershell onto your agents then please refer to this earlier post for my solution using Powershell: Using Powershell to Deploy a Logic App using an Office365 API Connection Otherwise, I spent…

    Know More

  • 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

    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

    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?

    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

    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

    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

     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

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

    Know More

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

     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

      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

    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

    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

    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

    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

    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

    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