<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

Managing and keeping track of external documents like customer contracts does not have to be difficult. With a simple configuration you can archive customer contracts in Infor Document Management (IDM) and automatically associate the document with a customer record. This way you will always be able to easily find the document, without leaving the M3 user interface.
Sometimes you want to know how many records you have of a certain type in a list. If I am looking at purchase order lines I might want to know how many open order lines I have per supplier, or how many delayed order lines we have at the moment. If I am working with manufacturing orders I might want to know how many open orders we have in my facility, or how many orders we have of a certain type. How do we show this in a simple way?
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.
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down