Author Archives: Soren Klemmensen

About Soren Klemmensen

Another Microsoft Dynamics 365 Business Central geek

Standard Web APIs are going out of BETA with the spring release

Some great news on the API front.

With the release of the upcoming Spring 2019 release of Business Central the APIs are finally leaving BETA and going into v1.0.

Why is that a great thing?

Well now we can count on them being there and they will not change. Creating strong and deep integrations, into Business Central with little or no knowledge of the code, is within everybody’s reach. Using some of the many tools (Flow and Power Apps to mention 2) available is now something anyone can do.

The sky is the limit.

The release comes with 48 entities out of the box, but if you are missing an API you can also create your own.

Happy coding everyone

Field and Row size changes coming to the Spring 2019 Release

Another change coming to the April 2019 release of Business Central is changes to the field sizes allowed in the code and database.

Fields and variables of type Text and code can now be up to 2048 characters. The same for Text constants.

The earlier restrictions were 250 characters for table fields of type code and text and 1024 for variables of type Code and Text.

Yes I know you could have a Text variable with no length specified that would be unlimited, but this is only a variable and managed differently.

You can find all public information about this here: https://docs.microsoft.com/en-us/business-applications-release-notes/April19/dynamics365-business-central/max-length-of-variable-length-table-fields-has-been-expanded

This comes with another change to the tables where the 8KB row size is getting relaxed. Microsoft has not said a lot about this change and the only public available documentation on this can be found here: https://docs.microsoft.com/en-us/business-applications-release-notes/April19/dynamics365-business-central/relax-requirement-of-8k-row-size

With great power comes a great responsibility:

Just because you can doesn’t mean you should.

We have seen it all too often that restrictions are relaxed and people jump on the wave starting to do all kind of strange things. Use your new found power with great wisdom my friends.

Happy Coding everyone.

Multiple Unique Keys on AL Tables in Business Central

My first thought was FINALLY.

Having multiple unique keys is very common in just about all databases and finally it is coming to Microsoft Dynamics 365 Business Central.

Basically there is a new property that can be set on each key called “unique” which indicates that this key is a unique key.

When you have a unique key there cannot be any records in the database with the same key and it is validated and verified at the time a record is inserted that this is the case. If there is a duplicate key the insert will fail.

Why am I so excited about this? Well one of the things I have wanted for many years is a surrogate key. A key consisting of a single field that is unique and not based on any of the user controlled data in the table. Basically a single unique key on every record in a table. I have wanted that on all tables in Business Central, because it would create a single anchor to connect everything and anything to.

Having multiple unique keys is the start for creating this, so hoping this is just the beginning.

All the information in this blog is public and can be found here: https://docs.microsoft.com/en-us/business-applications-release-notes/April19/dynamics365-business-central/multiple-unique-indexes

This is coming in the April 2019 release as per https://docs.microsoft.com/en-us/business-applications-release-notes/April19/dynamics365-business-central/planned-features

Happy Coding to everyone.