<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.

MDBREADMI_GET_2OUT

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.

MDBREADMI_LIST_2OUT

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!

MDBREADMI_SELECT_2OUT

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

Sometimes you need a simple way of following changes of values for certain fields in M3. By using the event log in M3 you have a handy solution 😊 Follow the steps below and you will have a log of changed values for supplier bank accounts in just a few minutes!
In this blog post I describe how to get your item names in the language connected to the user when using custom lists in Infor M3.
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.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down