27 thoughts on “Testing M3 APIs”

1. Sandra November 19, 2011 at 12:48 pm

   Great information, Thank you.
2. Al November 23, 2011 at 8:02 pm

   Thanks Karin. I’ve been meaning to play with MDBREADMI since I read about it in the release notes for the May 2011 heartbeat. For sites without MDBREADMI you can also use MNS185 and CRS990MI to create and consume custom Get and List APIs. See http://movexblog.blogspot.com/2011/11/creating-custom-list-and-get-apis.html for details. Cheers, Al.
3. mikael December 19, 2012 at 5:04 pm

   Hi. One question. How is the connection between mashup-LES-MDBREADMI ? Does MDBREADMI use LES in someway ? Thanks !!!!! /mikael
   1. karinpb Post authorDecember 19, 2012 at 5:09 pm

      If with LES you mean enterprise search – no there is no such connection.
4. Newton May 26, 2014 at 2:09 pm

   Has anyone experienced problems when running several API calls with the same API? I have tried to run the following code both as separate threads (using BackgroundWorker) and directly as a for-loop.

   var api = “OIS100MI”;
   var transaction = “GetOrderPromise”;
   record = new MIRecord();
   record[“CONO”] = companyNo;
   record[“ITNO”] = inputPara.ItemNo;
   record[“WHLO”] = inputPara.Whlo;
   record[“ORQT”] = inputPara.OrderQty;
   record[“DWDT”] = inputPara.ReqDate;
   var response = MIAccess.Execute(api, transaction, record);

   However, my issue is that the API only return a response for every second call and without any errors i.e. the first is OK, second no response, third OK etc. I suspected a timing error so I also added long delays etc but nothing helps. Any ideas what I might be doing wrong? I get the impression I will have to close/reset the connection before a new call can be made.
   1. karinpb Post authorMay 26, 2014 at 7:36 pm

      Hi Newton,
      I have not heard of anyone having issues with multiple API calls. So you are requesting order promises for a list of different items? I would take a Fiddler log of the calls (in a tight loop) and report the issue to support. Or at least use the Fiddler log to investigate further.
   2. Cezary K July 23, 2019 at 11:19 am

      Hi Newton,
      I know it’s very old post but I wonder if you have found the cause of such behavior.
      We suffer from the same or maybe similar issue. Almost every second REST request doesn’t have MIRecord with calling parameter instead of response content:
      http://…/m3api-rest/execute/MWS410MI/GetHead;maxrecs=1?DLIX=327572

      0

      DLIX

      (This is from IE11)
      Best regards
      1. Billy Willoughby July 23, 2019 at 5:07 pm

         Hello Cezary;
         See if there are any patches for that MI. I’ve seen some problems with calling MIs via REST vs calling them using the MI binary port. Infor is constantly improving the REST Service.

         I did find a Header parameter you can add when making numerous API calls, “Grid-TrackingId” is a value that is returned from the first call. If you use that value in subsequent calls it seems to make it more stable. I’ve had good luck with that, let me know if it helps.

         Billy
5. Sam N July 9, 2014 at 7:12 am

   Hi Karin,

   1) Is it possible to create a new transaction in an existing API? For example an update transaction in PPS360MI.

   2) Is it possible to add a field to an existing transaction. I tried adding CRLM field to ChgBasic Data transaction in CRS610MI to test it .But, it would not work. I know that there is a separate transaction ChgFinancial in CRS610MI which will allow me to do this. But, I want to be able to do it in a transaction of my choice.

   Thanks .

   Sam
   1. karinpb Post authorJuly 9, 2014 at 5:46 pm

      Hi,
      1) Since it is possible to do modifications in all M3 programs it is possible to do them in MI programs as well.
      2) If there is enough room in an existing transaction then you can modify the transaction.
      But with any modification it is best to create your own new API and transaction so that you don’t need to consider what will happen with updates. So I would not recommend updating the delivered MI programs event though I think it is allowed. There is a seperate API toolkit with documentation for the M3 MI APIs and I’m acctually not the correct person to ask about M3 modifications.

      When working with APIs in Smart Office make sure the MRS001MI meta data is correct and that the cache in M3-API-WS has been cleared and the client restarted (we have a cache as well). There is the MDBRead tool that can generate APIs from the database.

      I’m not sure why it would matter where an update transaction is added.
      1. Sam N July 9, 2014 at 11:39 pm

         Hi Karin,

         Thanks for your immediate reply . I sincerely appreciate it. Especially since I am new to developing in the Infor M3 environment.

         I can access the M3-API-WS through the life-cycle manager.

         I still cant find the API tool kit. What is the API tool kit? Where can I get or find the API toolkit?

         Thanks.
         Sam
      2. Sam N July 10, 2014 at 4:11 am

         Hi Karin,

         Over the day I have made some progress . I tried creating my own MIs and transactions. I keep getting this error : “DC_0005 – Command does not exist ” . What does that mean.

         Thanks and Regards.
         Sam.
      3. karinpb Post authorJuly 10, 2014 at 4:57 am

         Hi,
         I’m sorry but I can’t help you with M3 API development. There might be some forums that can help you. Almost everyone here is on vacation.

         I think the error message is something really core becuase that message exists in all APIs for all transactions.
      4. Sam N July 10, 2014 at 5:44 am

         Hi Karin,
         I totally understand. I have one final question-

         How do you create a transaction in an existing MI and get it to work? At the moment I am creating it in MRS001-> MRS002-> MRS003. I am also clearing cache in the client (mforms:mitest) and in M3APIWS. Still nothing happens. It does not work.

         Am I missing something? I see it , I have created it, the field names, data type, field lengths are correct. But, still wont work.

         Is there documentation somewhere on creating new transactions and new MIs?

         Thanks heaps.

         Sam.
6. karinpb Post authorJuly 10, 2014 at 6:16 am

   You need the MAK and you need to edit and deploy java code to the M3. Just editing the metadata is not enough. You need the API Toolkit and the developers guide. I think it requires a license as well for the java M3 API development. Check the extreme support for information or contact Infor.
   1. Sam N July 10, 2014 at 6:25 am

      Oh.. Ok… that makes sense now. Was breaking my head over it a couple of days. I am sure this information will be useful for others in the future too.

      Thanks again.
7. Amanda September 2, 2014 at 10:59 am

   Hí Karin
   If I use an API, f ex MMS025MI/LstAlias, in a Mashup to list aliasnbr from a special Item. When I have an item that has an Aliasnbr, ok. But when I use an item that doesn’t have an Aliasnbr, I’ll get the messaage, “Post doesn’t exsist”, but Mashup still shows the previous item that had an Aliasnbr. Is it possible to trigger the Mashup to “clear”, so I don’t see the old data?

   Thanks in advance! 🙂
   1. karinpb Post authorSeptember 10, 2014 at 2:34 pm

      Hi,
      Sorry for the late reply. Depending on the version the MIPanel has a clear event that you can trigger before the currentitemchanged event. So Map current item changed first to clear and then to List so that the panel will be cleared before the list.
      1. Veeresh April 30, 2015 at 1:28 pm

         I’m also facing Kiran’s problem. Please provide more details about how clean the previous data as it’s returning previous record though I’m sending new.
      2. karinpb Post authorMay 6, 2015 at 5:13 am

         Hi,
         I don’t know what the specific scenario is but I’m thinking something like this:

         <m3:MIPanel Name="CustomerDetail" Grid.Row="2" Margin="8,16,8,8">
         		<m3:MIPanel.Events>
         			<mashup:Events>
         				<mashup:Event SourceName="CustomerList" TargetName="CustomerDetail" SourceEventName="CurrentItemChanged" TargetEventName="Clear">
         					<mashup:Parameter SourceKey="CUNO" TargetKey="CUNO" />
         				</mashup:Event>
         				<mashup:Event SourceName="CustomerList" TargetName="CustomerDetail" SourceEventName="CurrentItemChanged" TargetEventName="Get">
         					<mashup:Parameter SourceKey="CUNO" TargetKey="CUNO" />
         				</mashup:Event>
         			</mashup:Events>
         		</m3:MIPanel.Events>
         
8. Billy W. July 10, 2015 at 7:50 pm

   Greeting; I’m trying to use OIS100MI.AddText, what is the field FLDN “Field Number” expecting?
   1. karinpb Post authorJuly 13, 2015 at 9:42 am

      I dont’t know that API. Please see the documentation.
      1. Billy W. July 13, 2015 at 12:59 pm

         Good Morning; Sadly, the documentation I have for the M3 API and the Documentation with Smart Office both exclude any explanation of how to populate that field. Thanks; Billy
      2. Billy W. July 14, 2015 at 12:03 am

         Good Evening; I opened a ticket with Infor, for anyone else who has that problem, the AddText field number is listed as a numeric (6,0), but it’s actually a string, you put the field name of the note field you want to update. Thanks; Billy
9. karinpb Post authorJuly 23, 2015 at 5:44 pm

   Thanks for the update.
10. MR. EX June 13, 2016 at 9:54 am

    How can i do looping in mashup?
    1. karinpb Post authorJune 14, 2016 at 6:40 am

       No there is no looping support in Mashups.

Comments are closed.