<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

How does your food company manage climate change, globalisation and stricter regulatory requirements? One thing is for sure, it has never been more important to have a business system that can manage different types of parameters in your food production chain.
If a problem were to be detected in one of the foodstuffs sold by your company, how long would it take for you to check every product affected? With a traceability solution you can do it in just minutes.
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!
right-arrow share search phone phone-filled menu filter envelope envelope-filled close checkmark caret-down arrow-up arrow-right arrow-left arrow-down