Is Looping through records using ION API possible

Hi, everyone, I need to loop through OCLINE table to calculate the total amount of a return. In a workflow, is it possible to loop through OCLINE for a certain return to calculate the return amount? I need the total return amount to determine if the workflow should go to Vice President level for approval.

Thanks,

Tony

Find more posts tagged with

ION API Gateway

Accepted answers

Anders Karlsson

ION Workflow is using ION API metadata to list available transactions. So if you see the transaction in ION API you can re-index the M3 API suite. Put the mouse over the lower part of the M3 API suite box to access the menu to re-index. This can take some time because of the amount of M3 API endpoints. The menu will be grayed out during this time. Hope it helps. :-)

All comments

Maxime Richard

Hello Tony,

Did you explore a CMS100MI API with a virtual "totalisation" field ?

Screen shot below : virtual field &MTLI has been defined as SAPR*REQ1 (for example) and standard sorting order 1 used in CMS015 has a totalisation at warehouse/receiving number level.

--> one output record with total amount of returned quantities.

Legacy Contributor

Thanks Maxime for the help. I'm checking this out now.

Legacy Contributor

[View:/cfs-file/__key/communityserver-discussions-components-files/75/CMS100MI.docx:320:240]

Hi Maxime, I got the Custom List created for CMS100MI and see it in Infor ION APIs but when I go into ION APIs in a workflow I'm not seeing CMS100MI listed.

Anders Karlsson

Copyright © 2025 Infor. All rights reserved.