Skip to Content
0
Jun 02, 2020 at 01:44 AM

CPI: WRITE and SELECT Data store operations

2229 Views Last edit Jun 02, 2020 at 01:49 AM 2 rev

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.

Attachments