Insert Issue in Groovy script within Json Loop

[Chandru_SAP]

Hi,

I am trying to loop json payload and execute Hana sql query in order to insert record into Hana DB. 

Its inserting only one record and breaks the loop. If i change the Json attribute(subscriptionactiontype) by keeping execute query outside loop, then loop is getting executed as many lines as we have. No Issues at all. But if i keep execute query statement within a loop, loop is getting executed for only once . Pls suggest.

Thanks