[Jennifer Häfner Has successfully completed the online course Intermediate (200)Has successfully completed the online course Advanced (300)Has successfully completed the online course Basics (100)Has successfully completed the online course Advanced (310)Has successfully completed the online course Advanced (320)Has successfully completed the Intermediate CertificationHas successfully completed the Advanced Certification]

1 year 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"
     }
]