Requirement: After receiving JSON array with thousands of records, map some of the fields into database profile and call the database procedure to insert a record into a table. Of course I need to do it for all of the records received. Possibly, instead of calling the database procedure I can perform an INSERT statement into the table, however calling the procedure is preferred option.
This is my test Process:
Currently I have the following map which returns an error during processing:
My profiles are defined as follows:
My thinking is the error relates to mapping from array into a single statement. I tried to resolve it by using "instance identifier" but no luck. Also I need all the records not just specific occurrences.
What is the best way to handle this situation.