You can deploy a function via FTP after selecting Publish/Folder. As an FTP client you can for instance use FileZilla. Note that when you remove the function’s bin folder before redeploying the function to the FTP server, you will run into issues with the Logic Apps that use the specific function. Removing the bin folder will…
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…
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…
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…
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…
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…
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…
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…
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…
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…