[Jennifer Häfner]

2 years, 9 months ago #34531

Up

0

Down

::

Hi Patrick,

according to your SQL statement, the input collection has to contain objects with the keys ‘col1’, ‘col2’, ‘col3’, ‘col4’. However, in your input JSON, these fields are called ‘value1’, ‘value2’, ‘value3’, ‘value4’.

The names of the fields in the SQL statement have to match the fields inside the object.

 

For example, if you want to insert one or more fruits into the table ‘Fruit’, the repeatable insert statement will be:

INSERT INTO Fruit (color, name) VALUES (:color:, :name:);

The input collection looks like this:

[
     {
          "color": "red",
          "name": "Apple"
     },
     {
          "color": "yellow",
          "name": "Banana"
     }
]