Hi Experts,
I have to make an API call and store the data until the HTTP response is 404-not found. I can achieve this using a looping process call. Once I get a 404 response, I need to collect all the data from the data store and send it to SFTP.
As 404-not found is an exception I am catching the exception using exception subprocess call with a groovy script and calling another local integration process to collect the data from DataStore and delete it upon collection. But it is not working.
After the SELECT step, I am not getting the complete Payload while processing it. I am getting the following payload only
<?xml version="1.0" encoding="UTF-8"?><messages></messages>
Is there a limitation for WRITE and SELECT operations in the same IFlow. Do I have to use SELECT explicitly in another flow ?
Let me know if I have to follow any other approach to achieve the requirement. My IFlow looks as below:

Any pointer will be highly appreciated.
Thanks and Regards,
Pavan G.