Close

Large Web Request

A client has sent messages with a size > 30 MB to an Azure Web App. After two minutes the connection is aborted, which means the Azure Web App cannot be not called. A colleague pointed me to the following site: Slowtick.com I have changed the maximum message size (in bytes) and time-out settings in the…

Run After in Logic Apps

Using the visual designer in Logic Apps, you can specify the Run After property. Let’s say you have multiple branches and an action that should run after one of the branches has succeeded. Note that if one of branches is successfully executed, the other branches are skipped. That’s why you need a run after property…

Azure filesize limitations

While you, as a Microsoft developer, are inclined to approach Azure from the opportunities side, it’s also worth looking at the limitations. I didn’t find a web source with a full list of limitations. That’s why I simply start by discussing two file size limitations here: The FTP connector trigger supports max 50 MB. I…

AFAS Online

I have already written a few posts on AFAS Online. Below you will find a query example. I also like to share a very helpful link, which explains for example how you can apply filtering on multiple fields and with different query operations. Also note you will always have to include take, otherwise no results…

NuGet package CsvHelper

I came across an interesting NuGet package named CsvHelper. CsvHelper basically let’s you create a Csv file from a typed list. You can choose whether or not to include a header automatically. As an example, let’s say you access AFAS to get a list of users. private static async Task<List<ASB_Totara_User>> GetAfasUserAsync(Logging logging) { string take…

ForEach Queue Message

I had a logic app that started with a queue trigger followed by a ForEach statement. The Logic App run failed on the ForEach step with the following error message: ExpressionEvaluationFailed. The execution of template action ‘For_each’ failed: the result of the evaluation of ‘foreach’ expression ‘@triggerBody()?[‘QueueMessagesList’]?[‘QueueMessage’]’ is of type ‘Null’. The result must be…

Consumption Plan versus App Service Plan

You can run Azure Functions in two different modes: Consumption plan and App Service plan. You must choose the type of hosting plan during the creation of the function app. You can’t change it afterward. Consumption Plan The consumption plan automatically allocates compute power when your code is running, scales out as necessary to handle…

Using Http Webhook

When debatching a Json file with 5600 articles, I found out that using a looping construct in Logic Apps (like foreach or until) is very slow. I had to create a set of Json files with the number of articles equal to a configurable batch size. As an alternative to Logic App looping, I decided to…

FileZilla connection to FTPS Server

I tried to connect to a FTPS server via FileZilla, but received the following error when trying to get the directory listing: “Server sent passive reply with unroutable address. Using server address instead.” Note that I can connect to the FTP server. Just not able to get to the directory listing. It turned out that…