Integration with Azure Static Web Apps from Business Central

Preamble I've been working lately on an integration with a 3rd party service where the UI needs to be displayed in a web page. Two main options I think: build the web controls into a control add-in and host everything inside the BC app host the web app somewhere else (Azure Static Web Apps) and use the WebPageViewer control add-in to display it…

jpearson.blog

Why do all my tests show up twice in the test explorer?

Long story, short Because you are using the pre-release of AL Language and you also have AL Test Runner installed. If you are using AL Test Runner then you probably want to switch to the release version of the AL Language extension for now. Short story, made unnecessarily long Microsoft are adding testing capability to the AL Language extension. It now discovers the tests in your project and puts them into the test explorer.

jpearson.blog

vscode.commands.executeCommand('al.publishNoDebug') not returning result? · Issue #8181 · microsoft/AL

Please include the following with each issue: 1. Describe the bug My extension (AL Test Runner) relies on calling the al.publishNoDebug command to optionally publish the test app before running tes...

github.com

Embed Visual Studio Code in Business Central

From time to time you might want to display large block of text in Business Central. Maybe the request / response from some integration. Maybe the contents of a text file that has been imported. I've written before about using the WebPageViewer add-in to format text nicely for a user to read. That's cool, but we can do better than that. We can embed Visual Studio Code's Monaco editor in a control add-in for a lovely text viewing and editing experience.

jpearson.blog

Using Azure DevOps Wiki as a WYSIWYG Editor for Your Static Site

Using Azure DevOps Wiki as a WYSIWYG Editor for Your Static Site #msdyn365bc #azure #docfx

jpearson.blog

Dynamics 365 Business Central: finally we’ll have TRUNCATE table in SaaS.

In the last 3 years I wrote many times about the need to have the possibility to execute a massive data deletion on SaaS and expecially the need to have the SQL TRUNCATE operation exposed to develo…

demiliani.com

Calling Business Central Directly from a Managed Identity

TL;DR You can assign Business Central (and other) API permissions to managed identities. Use the Microsoft Graph PowerShell module and then create an Entra Application record in Business Central for the client id of the managed identity (without the need for a separate app registration). Intro I've said it before and I'll say it again. The best thing about blogging now and then is that when people find a better way to do the things you're blogging about they sometimes tell you.

jpearson.blog

Calling Business Central APIs Without a Client Secret

Intro We're doing more with Azure resources. I expect that you are too. Especially Static Web Apps and Azure Functions that we need to be able to call back into the Business Central and Dataverse APIs. To authenticate with Business Central we would typically: create an app registration in Azure add Business Central APIs permissions to the app registration create an Entra Application in Business Central and assign permission sets to it…

jpearson.blog

Another Look at App Integration in Business Central – Part 2

Recap See here for part 1 of this series. The challenge that we are trying to solve is to allow Business Central apps to call each other's functionality without creating a dependency. ⚠️ Reminder: only do this when you cannot create a dependency between the two apps. If a dependency is acceptable then that is the way that you should solve this problem.

jpearson.blog

Tip – Access the Clipboard with Business Central

Intro I've written before about using the WebPageViewer control add-in to add a little zest et je ne sais quoi to your BC pages. You can set html content like this or use JavaScript to neatly format JSON like this. Obviously, you have more control over how your page looks and behaves if you write your own control add-in, but for smaller jobs where you just need a little sprinkling of HTML and (your favourite programming language and mine) JavaScript then the WebPageViewer might be just fine.

jpearson.blog

Another Look at App Integration in Business Central

Intro A while ago I posted a series of thoughts about integration between Business Central apps. You can find the original posts here. Those posts are 7 years old, presumably there must be a better way to do it now? It's time for a fresh look... Objective First, let's clarify what we are trying to achieve here. I'm interested in the ability for one app to call the functionality in another app…

jpearson.blog

20250127 - Grabbing BC artifacts in your pipelines via an Azure Function and how all of this works

YouTube video by Areopa webinars

youtube.com

Export Test Steps as CSV to Import to Azure DevOps

I don't know if anyone needs this. I'm not sure if even I need this yet, but I am starting to find it useful. We use test plans in Azure DevOps to record the steps and results of manual testing. I figured that if I'm writing decent comments in my automated (integration*) tests then I should be able to just copy them to the test plan in DevOps, or at least use them as the basis.

jpearson.blog

Trigger Sequence in AL

Here’s a small “let me bookmark this” post.

tine.staric.net

an elf on the shelf is sitting on a couch next to a sign that says " you opened your gifts before christmas "

ALT: an elf on the shelf is sitting on a couch next to a sign that says " you opened your gifts before christmas "

media.tenor.com

Issue when running AL Test Runner against a COMSO Alpaca container · Issue #152 · jimmymcp/al-test-runner

When executing tests using f.e. Run All Tests against a COSMO Alpaca container I am getting the error Error: No such object: fps-alpaca.westeurope.cloudapp.azure.com Get-CompanyInBCContainer Teleme...

github.com