I was asked by a customer recently on how to call a third-party API that required an MD5 hash to be included as a query string parameter from Azure API Management. I knew the answer was in policies but was not exactly sure how to do it. I also seemed to remember the Marvel API…
Adventures with the Power Platform: Handling Dataflow Upserts
I want to import data from an Excel workbook into my Power Platform Dataverse. To get started, I created a Table to hold the imported data. I added a single column called Name to my Table. I created my Dataflow, in my example, it was from an Excel file hosted in OneDrive. I followed the…
Adventures with Power Apps: Don’t Forget Those Pesky Table Permissions
I created my first Power App. The app, a canvas app, is supported by (2) tables in the Dataverse. The app manages meetings for an internal community. It allows members to sign-up to speak to the community on a topic relative to the community. I shared by app with my teammates, giving them all Basic…
Adventures with Blazor: Custom Markdown Component
I created a simple Blazor Markdown component, you can download it at NuGet Gallery | PhatBrainSoftware.MarkdownEdit 1.0.1. Below is a screenshot of the component in action. The code is at phatbrainsoftware/MarkdownEdit: Blazor markdown editor component. (github.com), feel free to fork and make some changes!
Adventures with Azure DevOps: Manual Validations
I wanted to test adding approvals to an Azure DevOps YAML pipeline, outside of Environment approvals. I created a project that contains the following files: deploy.bicep – Bicep template that will create a storage account in Azure. validate.ps1 – PowerShell script that mocks a validation stage, could be a what-if or some other validation. deploy.ps1…
Adventures with Azure: Doh! Built-in App Service Identity Provider Not Working!
In adding the built-in Authentication support to an Azure App Services, I ran into a challenge where I kept getting a 401 Status Code whenever I called an API endpoint. The first thing after setting up Azure Active Directory as my Identity Provider, I used Postman to call the oauth2 token endpoint to get a…
Adventures with Cosmos: Delete All Documents
When testing my Cosmos database I often like to reset the containers, or in other words, delete all the existing documents. Unfortunately, there is no way to do a DELETE * FROM in Cosmos, at least not yet. I know I could create a Console Application or Azure Function to do this, but I was…
Adventures with Bicep: How to Create an App Service for Containers
I wanted to create the following Azure resources: Azure Container Registry App Service Plan App Service The App Service would need to support Linux containers. I have been doing a lot with Bicep, with the following bicep file as my first attempt: When I ran my script the first time, it wasn’t setup for containers,…
Adventures with PowerShell: Add or Update Resource Tags
Whenever I deploy a release to Azure, using Azure DevOps, I like to add or update a tag with the current build version. To do this, I created a PowerShell script called UpdateTags.ps1. In full disclosure, transparency, and whatever other buzz words there are now for coming clean, I cobbled this script together from a…
Adventures with Azure DevOps: Connect to Azure Database for MySQL
I have been doing a lot around Azure DevOps as of late, and started dipping my toe into the CI/CD for databases, thought of calling it DataOps, but that doesn’t look like the correct term. Anyway, in my Azure DevOps pipeline I wanted to run a few tasks against an Azure Database for MySQL, e.g….