<img src="https://secure.leadforensics.com/133892.png" alt="" style="display:none;">

MDBREADMI is a tool which was released in Infor M3 10.1. You can use it to build your own API-transactions, and it is really easy to use. You connect a simple program to your IP/port for API-traffic. Once you have done that, you add the table you want to use, and the input/output you want to use. When you click create MRS001 is updated, and the API is ready to use!

In the first versions of the tool you could use it to create lists and get transactions, but in the latest version you can also create select transactions! Some of you might wonder; what is so special about that?

Get transactions only display one record, and list transactions displays the matching record and all following records in the selected table. But with the new select transaction we are able to display only the records which matches your input.

So let’s say that I would like to see which packages that matches a certain item. The get transaction would only give me one record at a time.


Picture 1: The Get-transaction only retreives one record at a time

The list transaction gives me more than I want, not just records for my item, but records for all the following items as well.


Picture 2: The List-transaction shows too many records

The select transaction though, fulfills my wish and gives me only the records connected to my item, AA01!


Picture 3: The Select-transaction only shows the records I want to see!

Building you own API:s in a simple way makes it easy to extract data in a controlled way to external applications or excel sheets. With MDBREADMI you can extract data from one table at a time, but in M3 13.3 there are also possibilities to create API:s with data from many tables, but more about that in another blog post!

Subscribe to the M3 Usability Blog

Discuss this post

Recommended posts

If you are running Infor OS/H5 you have the possibility to create really nice homepages for your users. The homepages are the starting points for all roles, and one of the widgets you probably want to have on your homepage is the menu-widget. On the menu widget you can add links to M3 programs for example, but by using bookmarks you can make the links smart, and let them open the programs with predefined selections and searches.
In this blog post I'm describing how to create bookmarks in M3. Since we are moving towards Infor OS and H5, we need to handle that there are some differences in how you manage bookmarks in the different user interfaces for M3.
In Infor M3 13.4 there is a new possibility, you can build your own list program. This blog post will show you how to do that.
I have talked about personalizations many, many times – and I am still convinced that there is a lot left to do in this area for most M3 users. Recently we have done some M3 installations for new customers, and in that kind of projects the need for a smooth navigation in M3 becomes very clear. It is not easy to run M3 the old-fashioned way.
In my first two blog posts, I gave tips on what you need to consider before and during the year end. Below, you’ll find the third and last part of the blog series Preparations for year end in Infor M3 – after closing. Happy reading!
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down