How to retrieve multiple rows from Json API output

I have a Json API configured in the ION API and the workflow built to read the Data from JSON API. i am able to read single record. However i am unable to read multiple records is there is any way to do this.

we tried following however we were not able to succeed.

We defined a counter as parameter(cnt) with expression type (incremented in the expression). a loopback has been defined and in the loopback we are calling the Json ApI and in the output parameter we are passing the counter cnt. Hoping to retrieve the array data but it is throwing error.

Following is the workflow .

Thank You

Lawry

Find more posts tagged with

ION Workflow

Accepted answers

All comments

Legacy Contributor

Hi Lawry,

Its not possible to do in workflow, I once tried the same approach you mentioned but it didn't work.

Legacy Contributor

Thank you sudhakaran,

How you achieved this then?

Regards

Lawry

Legacy Contributor

It's a BOD and Activation policy based trigger to workflow, so we changed it to trigger a document flow first and used python Script to convert JSON to xml BOD and used splitter and called the workflow for each record and sent notifications.

It fits into our solution because the workflow process is based on the BOD.

Legacy Contributor

Hello

Thank you for the response.

In my case there is no BOD is received for the activation Policy. i was planning to schedule the Workflow. My question was how to handle multiple records that is getting received from the Json API call.

Regards

Lawry

Copyright © 2025 Infor. All rights reserved.