What is the alternatives of the On-Prem MWS(SQL) WebServices in MT?

Hello,

I have some interfaces consuming some MWS(SQL) webservices from the java code in the On-Prem and need to re-implement these interfaces on MT. I know in some cases we may use M3 Standard APIs to retrieve the same data coming from the webservices. but we have some cases where the services have complex queries with multiple joins with different table.

Thanks.

Find more posts tagged with

ION API Gateway

Accepted answers

All comments

Legacy Contributor

Hi @mohamed-elsharkawy

Check if it is possible to use CMS100MI to meet the expected result or if it is even complex then use XtendM3 transactions.

antonio-caria

If possible avoid CMS100MI. It's a slow API ...

If You have joins use XtendM3 otherwise use EXPORTMI.Select

Quick Links

Developer Community
Infor OS Platform Forums
Hackathon
Developer Portal
Developer Newsletter

Copyright © 2025 Infor. All rights reserved.