Close

Deploy Logic App via Portal

Another quick gotcha. If you want to migrate a Logic App from Development to Accept and you don’t want to use Powershell/ARM or Visual Studio Team Services (DevOps), you can perform the following steps in the Azure Portal: Clone the Dev version of your Logic App and name it Acc_LogicApp (follow the correct naming convention).…

Logic App parameters in SQL

In a previous post, I explained how you can use Logic App parameters in ARM templates. This solution is quite complicated. You will have to parameterize your Logic Apps. At deployment, the parameters are substituted by actual values. But, If you lookup the logic app in the Azure Portal, you will notice that the value…

Deploy API Connection using ARM

Azure API Connections have a name and a display name. When you create a new API Connection via the Azure Portal, you are not able to specify the name of the API Connection. This name is actually used in Logic Apps however. Example: @parameters(‘$connections’)[‘sftp_1’][‘connectionId’] In this case sftp_1 is the name, not the display name.…

Generate SQL Create and Insert script

Today I came across a SQL feature I had been looking for a long time: creating a table create script including the data that are inside that table. If you right-click the table, you can only get a table create script. If you click the database instead, you can select context menu Generate Scripts. In…

Extract ZIP file on FTP

The Azure FTP Connector currently has a limit on file size of 50MB. That’s pretty tiny for a file transfer application. It may even mean that you are unable to use this connector. There’s a solution however. In my situation I had a file of 134MB. I send this file in zipped format to the…

Remote debugging Azure Functions

In a previous post we talked about debugging an Azure function in Visual Studio. You can also debug a function deployed to Azure, ie. remote debugging. There’s a few points to note: For remote debugging to work, we will have to deploy the function container in Debug mode. Next open the Azure Portal. In the Application…

Whitelist Azure

If you want to call a webservice from Azure, the webservice provider might ask you for a list of ip addresses to whitelist on their firewall. As you know, Azure has no fixed IP addresses. It’s no good practice either to supply ip addresses per individual service. As an example in the properties of an…

Password protected ZIP file

Windows’ own native compression tool doesn’t support password-protecting your zip file, but many other well-known tools like 7-Zip, WinZip and WinRAR do. I used 7-Zip. When you add files to your .7z file, you can enter a password in the dialog box that appears. Easy peasy. Link: WindowsClub.com