AnsweredAssumed Answered

JSON array into single record DB profile

Question asked by milowski@ohsu.edu on Jan 8, 2018
Latest reply on Jan 10, 2018 by milowski@ohsu.edu

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.

Outcomes