Export SQL data to CSV or XML File via Powershell

Sometimes it may be useful or necessary to use powershell to read data from SQL Server to export it to other formats This can also be used with older versions of Dynamics NAV which do not have access to the integrated powershell. Using standard powershell commands it is possible for example to read an SQL view and export it to CSV or XML file.

Source : Roberto Stefanetti Blog
Read more…

Get your BC artifact URLs without PowerShell

In June 2020, a drastic change happened to how we can work with Microsoft Dynamics 365 Business Central in containers: Instead of ready made images, BC started to rely on artifacts (see Freddy’s blog post on the topic). As a result of that, you can no longer just use an image to start BC but instead need to first find out what the right BC artifact URL for your type, version, localization etc. is.

Source : Tech blog – Tobias Fenster
Read more…

Service to service authentication in Business Central 18.3 – How to test (REST Client & PowerShell)

In the previous blog posts I’ve described the usage scenarios around OAuth client credentials flow for Business Central and how to set it up. The next step is to test the APIs and with OAuth authentication to see if it works properly. In this post, I want to focus on the REST Client extension for VS Code and PowerShell. In the next posts, I will also cover Postman, Insomnia and C#.

Source : Kauffmann @ Dynamics 365 Business Central
Read more…

Update apps installed from Appsource in Business Central Online with Powershell

This post will show you how you can update apps installed from the Marketplace in Business Central Cloud with Powershell.

In the example below, powershell will be used which will invoke the APIs needed to update the APPs installed from the marketplace. For convenience I added a couple of functions to the BCContainerhelper to make it more convenient, in this way we can take advantage of the token management already present in the module, placed in GitHub.

Source : Roberto Stefanetti
Read more…

Download all Microsoft Dynamics 365 Business Central Source Code with PowerShell

You might wonder: why would I need this? Why would I need to download source code of Business Central, while I can simply access it through the symbols when I’m working in VSCode – or even better, while I can simply click the symbol, and look at the code from there?

Source : Waldo’s Blog
Read more…

Update one or all license files without restarting the servicetier

Again this week I met consultants that didn’t know that it is possible to update the license-file in a servicetier without restarting the servicetier and thereby kicking all users off.

I have blogged about that in a previous post: Tips for Wizards in Dynamics NAV and 365 Business Central, but most surprisingly, not everybody has read that post

So, here it is again, but this time with a twist.

Source : Aphorisms about Microsoft Dynamics NAV
Read more…