James Pearson

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…

Dynamics 365 Business Central: finally we'll have TRUNCATE table in SaaS. 🤩
demiliani.com/2025/08/04/d...
#msdyn365bc

The patches are usually made of organic amino acid crystals…

Truly extraordinary Google AI results. Amazing.

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.

Calling Business Central Directly from a Managed Identity #msdyn365bc

Authenticate directly from your Azure resources into Business Central without an app registration or client secret.

I can't tell if it is foreach or Copilot (or maybe the combination), but everytime I use foreach VS Code goes mad. All sorts of false compilation errors highlighted in the editor but actually compiles when I build.

Foreach does feels a little like a forgotten child of the AL language. #bcalhelp

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…

Calling Business Central APIs without a client secret

How to setup an Azure function to call a Business Central API without the hassle of having to manage and maintain client secrets.

#msdyn365bc

Can we auth web service calls with a managed identity? Telemetry says "successfully authenticated in Microsoft Entra ID but the user does not have any entitlements in Business Central". Also found @demiliani.bsky.social blog which suggests this is not possible. Is that right? #bcalhelp #msdyn365bc

I like a ConfirmationDialog for this kind of thing as well where the enum is rendered as radio buttons. You can limit the options with the AllowedValues property, BUT that is hardcoded 😢 I think I've seen a BCIdea to allow it to be dynamic which would be great.

"Fabric [gestures widely]" - that made me laugh...

...and then sigh

This is cool 👍

Is this ready for a straight switch with alc.exe commands? Are all the same parameters supported?

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.

Another Look at App Integration in Business Central - Part 2 #msdyn365bc

It turns out you can drop the ics file directly into the OWA calendar for a substantially less-bad user experience.

Telemetry cost control in Business Central - Stefan's BC Blog In the dynamic world of Business Central, telemetry data plays a crucial role in providing actionable insights into system performance and usage patterns. However, as...

Shout out to this article: ssosic.com/telemetry/te... good starting point 👍

Anyone willing to share data transformation rules that they use to reduce BC telemetry costs? Trimming out authorization calls (RT0004 and RT0003) seems like an obvious place to start? #bcalhelp #msdyn365bc

Writing to the clipboard from Business Central #msdyn365bc

Another use for the WebPageViewer control add-in to add a small layer of UX joy to your apps.

Are the MS marketing team paid per-rebrand?

This is why I've used for several years Outlook web client. Loading an invite from a file is the only reason I would open the desktop app now. "Outlook (new)" is basically a skin for the web client anyway 🤷‍♂️

Outlook is genuinely baffling. Downloaded an appointment ics file. Outlook (new) opens and...does nothing with it. I select "Outlook" from the open with menu (called "Outlook (classic)" in start menu). Prompts me to set up my account. Evidently the two outlooks don't even share account setup.

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…

Another Look at App Integration in Business Central #msdyn365bc

Problems logging into @evernote.bsky.social web app? The Continue button on the login page remains disabled after I enter my username... 🤔

What are your experiences with Cursor? What are you using it for?

Ouch. That feels...unintended. Thanks for sharing. I'm sure there must be partners using internal tables on the understanding that they cannot be access by anyone else. How about rapidstart come to think of it?

Is IsolatedStorage the only actually protected data then?

Versions Returned by Get-BcArtifactUrl Inconsistent with NuGet Packages · Issue #3827 · microsoft/navcontainerhelper The version number of artifacts returned by Get-BcArtifactUrl do not match with the versions available as NuGet packages from the MSApps feed. For example: Get-BCArtifactUrl -country gb -version 23...

Thanks Freddy 👍 created a GitHub issue: github.com/microsoft/na...

Genuine question. Does anyone actually use AI tools to "change the tone" of their writing? Just noticed that it has popped up in Evernote now as well. Who needs that?

OK, thanks for the reply. Still confused as to why the versions don't line up, but have reworked our pipeline:

$feed, $package, $version = Find-BcNuGetPackage -packageName Microsoft.Application.GB -version 23.1.0.0 -select Earliest -nuGetServerUrl $bccontainerhelperconfig.MSAppsNuGetFeedUrl

Yes, returns the same url as bccontainerhelper. My expectation was that I can retrieve the version from the url and then pass that to nuget to install. This specific example is:

GB, sandbox, 23.1 = 23.1.13431.29781
nuget install Microsoft.Application.GB -Version 23.1.13431.29781 ❌

YouTube video by Areopa webinars 20250127 - Grabbing BC artifacts in your pipelines via an Azure Function and how all of this works

@tobiasfenster.io, @arthurvdv.bsky.social - great webinar recently on artifacts (www.youtube.com/watch?v=7i1h...) 👍 I'm trying it out in our pipelines, but the version returned by the proxy doesn't exist in the MSApps nuget feed. Am I doing something wrong? Perhaps a question for Microsoft?

Didn't see this coming, but one of the more satisfying uses of Copilot in VS Code is to suggest completions to my apologetic comments to others devs/future self.

Exporting your test steps from VS Code to import into Azure DevOps #msdyn365bc #bcalhelp

There's a special circle in hell for those who comment their code with 'magic happens here.' Magic is for Hogwarts, not for code review.

Trigger Sequence in AL Here’s a small “let me bookmark this” post.

Here’s another “Let me bookmark this” post

What’s executed earlier, OnBeforeValidate event or OnBeforeValidate trigger?

I’m never 100% certain so I’ve visualized a few sequences for myself. Maybe it will help you too!

tine.staric.net/blog/2025/tr...