Scheduled Workflow - Loop Data

Ryan Pukanski

Hello,

I am on Infor LTR. I have a workflow that runs to assign tasks and update values in IDM. However, I would like to run this workflow on a schedule based on data retrieved through an API call to IDM where a certain field is missing. How can I "loop" through items returned in an API call in a workflow and use this data to call a sub process workflow?

For example, here is the initial API return. How can I loop through each entry?

<?xml version="1.0" encoding="UTF-8" standalone="no"?> <items xmlns="http://infor.com/daf">
<searchXQuery>/Procedures</searchXQuery>
<item>
<lastChangedTS>2024-11-27T20:56:39.353Z</lastChangedTS>
<filename>Procedure - Managing Raw Material for Prototypes through Project Material List.docx</filename>
<size>58362</size>
<pid>Procedures-7-3-LATEST</pid>
<id>7</id>
<version>3</version>
<reprItem>Document_Name</reprItem>
<displayName>Managing RM via PML</displayName>
<entityName>Procedures</entityName>
<item>
<lastChangedTS>2024-11-28T17:45:44.710Z</lastChangedTS>
<filename>Procedure - Managing Raw Material for Prototypes through Material List.docx</filename>
<size>58362</size>
<pid>Procedures-11-12-LATEST</pid>
<id>11</id>
<version>12</version>
<reprItem>Document_Name</reprItem>
<displayName>Phosphate 2</displayName>
<entityName>Procedures</entityName>
</items>

Or is there a better way of handling this type of scneario?

Thanks
Ryan

Danil Klemeshov

Hi Ryan,

I think it is not possible to do such a "loop" in a workflow.
However, it may be possible using a DataFlow. You can do an API call (API connector) to retrieve data, then you can use a splitter, or you can run a Workflow from a Data Flow and pass a response from the API call as a structure. In the Workflow, you can create a loop to go through the structure.

Documentation:

https://docs.infor.com/inforosltr/2023.x/en-us/useradminlib_onpremises/default.html?helpcontent=iondeskopug/iun1703772023970.html

https://docs.infor.com/inforosltr/2023.x/en-us/useradminlib_onpremises/default.html?helpcontent=iondeskopug/syc1703772024955.html