Close

Azure Function Update

When using an old version of Azure Functions, you might run into an issue like “The WebHook verification request must contain a ‘code’ query parameter”. This means you can’t call the functionsfrom your logic app anymore. Upgrade to the latest version of Azure Functions and redeploy your logic apps. I’m not entirely sure, but things should work again.

SQL Server Upsert

In SQL Server it often happens that you want to either insert or update a table row. You could first check the row count via select statement. Or you could check the @error variable after update. Nothing wrong, but wouldn’t it be convenient (and more performant) to do all of this in one statement. You…

BTDF Determine Environment

To identify the deployment environment in BizTalk Deployment Framework scripts, you use an environment variable by default. You can also use a RSA certificate however. To this end you will have to create a BTDF extension. In this post, I will not show the extension code. This post is just aims to make you aware…

TFS Deploy Web App

Another post on using TFS (or DevOps) for easy reference. To build a web application and deploy it locally on IIS, you can use the following build and release definitions: In the Visual Studio Build step, use the following MSBuild Arguments to build a web deploy package: /p:DeployOnBuild=true /p:WebPublishMethod=Package /p:PackageAsSingleFile=true /p:SkipInvalidConfigurations=true /p:PackageLocation=”$(build.artifactstagingdirectory)\” It’s this web…

TFS Replace Tokens

When building a web application you can use AppSettings in you web.config file to configure (not hard-code) settings like database connection strings. Looking at the web.config file, I noticed variables were used like value=”#{CONNECTIONSTRING_RELATIECORRELATIE_DB}#”. The reason variables are used is because we want to change the value of variables per environment (DTAP), but how do…

Upgrading PowerShell

For over two years I use Powershell to deploy my Logic Apps, API Apps and functions to Azure. The client moved from ADFS to Azure Active Directory Seamless Single Sign-On. I don’t know exactly what this means, to be honest, but what I do know is that I ran into problems with my Powershell scripts.…

Document REST service with Mermaid

For documentation of a REST service you can use a Javascript library called Mermaid (https://mermaidjs.github.io/). From the GitHub page, Mermaid is recommended as follows: Ever wanted to simplify documentation and avoid heavy tools like Visio when explaining your code? This is why mermaid was born, a simple markdown-like script language for generating charts from text…

BizTalk 2016 Relay Endpoint

In this post, I want to describe a hybrid integration scenario where a BizTalk 2016 service is exposed to Azure using a service bus relay. Note that the relay is not found under Service Bus, but under resource named Relays. This may be a point of confusion. First you will have to create a relay…