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!