Can we build custom API's in ION API?

Is it possible for us, as a customer of Infor M3 CloudSuite ERP, to build our own API's within the ION API module, and do our own back-end work to tie together data from multiple tables?

We have a front-end eCommerce system that will be calling API's from our ERP system. In many cases, we have found this would require multiple API calls, as there is not an individual existing API that combines information from the tables we need. We'd like to avoid making a multiple API call to get to the final data subset that we need.

Thanks,

Jon

Find more posts tagged with

ION Connect

Accepted answers

Maxime Richard

Maybe can you have a look at CMS015 to create standard custom 'read mode' API's that allow you to read from a main table and retrieve information from related tables at the same time. Filter and selection only possible on main table.

Start from CMS010, build your information browser category, select the related tables and the fields you need... then build the API in CMS015 based on this freshly new created information category.

All comments

Brandon Watson

Hey Jon - If you are using Infor OS in the Cloud, you will have access to the new API Orchestration in the new API Flows in ION Desk. You could use this to create an API endpoint that will be accessible through the ION API Gateway. This would be the best way to combine API's into just one. Have you looked at this new feature in the MT CloudSuite for Infor OS?

Legacy Contributor

Thanks Brandon, that sounds promising.

Would we be limited to combining existing ION API's or can we also build custom API's that join and associate multiple Infor DB tables?

Brandon Watson

The API Flow will allow you utilize any of the current API's you have in ION API Gateway.

As far as custom API's that retrieves specific data from M3, I do not know enough about M3 to answer that. I know other API's have specific API's or a FectchWhere API, which give you access to individual tables, are the only available API's or accessibility to the database. They do not have a way to create a custom API to access and aggregate data directly from the database, as this would require back-end database access, which Infor does not provide for CloudSuite ERP databases, or custom code, which Infor does not allow either.

I believe you are limited to the currently available API's in the Gateway. If you Cloud, the API Flow (Orchestration) is going to be Infor's go forward solution for combining multiple API calls into one, as it allows you to publish the API Flow as an endpoint in the Gateway.

Legacy Contributor

Thanks again,

Is the ION Desk API Flow to the point where it's released and documented?

Maxime Richard

Start from CMS010, build your information browser category, select the related tables and the fields you need... then build the API in CMS015 based on this freshly new created information category.

Legacy Contributor

All our CMS100MI and MDBREADMI API-s automatically showed up as ION API-s

Legacy Contributor

Thanks Maxime,

I gave these pages a brief review and will give this a go tomorrow. The fact you can relate the tables into custom lists able to be called by ION API sounds very good.

Legacy Contributor

Thanks again.

I set up our CMS010, CMS011, and CMS015 pages for this API request.

The main table is MITFAC, and the related tables are MITMAS, and OCUSIT.

On CMS015, I have one selection field M9FACI, and I do get Test API to return only items for the specified facility. The Test API has 3 FACI parameters for some reason, so I populated all three params with the same value. The TEST API showed a ITNO parameter and I left that empty for this test as we want a list of all items at the facility.

I wasn't quite sure how these parameters are determined, as the related tables don't have a FACI column.

Also for the JOINs that Infor determined, for some reason the 1st related table didn't get the CONO assocation, while the 2nd related table did. I checked and MITMAS has a CONO column, so not sure why that wasn't a part of the JOIN.

Is there a way to add the M9CONO as a param for this API call?

Also, is there a way to add more db columns to the output? At this point, there are two columns returned, M9FACI and M9ITNO.

Copyright © 2025 Infor. All rights reserved.