[camel-kamelets] 01/01: SQL Server Sink Kamelet Fixed description and more information

[ac...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

acosentino pushed a commit to branch sql-server-fix-descr
in repository https://gitbox.apache.org/repos/asf/camel-kamelets.git

commit 41f8bfdee7bcc7b515fc7c49c3767b49e722575f
Author: Andrea Cosentino <an...@gmail.com>
AuthorDate: Mon Jun 14 13:30:49 2021 +0200

    SQL Server Sink Kamelet Fixed description and more information
---
 sqlserver-sink.kamelet.yaml | 21 +++++++++++++++------
 1 file changed, 15 insertions(+), 6 deletions(-)

diff --git a/sqlserver-sink.kamelet.yaml b/sqlserver-sink.kamelet.yaml
index e8952f6..d784b7c 100644
--- a/sqlserver-sink.kamelet.yaml
+++ b/sqlserver-sink.kamelet.yaml
@@ -16,12 +16,17 @@ spec:
     description: |-
       Send data to a Microsoft SQL Server Database.
 
-      In you KameletBinding file you'll need to explicitly declare the SQL Server driver dependency, like in the following YAML snippet
-      
-      spec:
-        integration:
-          dependencies:
-          - "mvn:com.microsoft.sqlserver:mssql-jdbc:<version>"
+      In you KameletBinding file you'll need to explicitly declare the SQL Server driver dependency in spec->integration->dependencies
+
+      - "mvn:com.microsoft.sqlserver:mssql-jdbc:<version>"
+
+      This Kamelet expects a JSON as body. The mapping between the JSON fields and parameters is done by key, so if you have the following query:
+
+      'INSERT INTO accounts (username,city) VALUES (:#username,:#city)'
+
+      The Kamelet need to receive as input something like:
+
+      '{ "username":"oscerd", "city":"Rome"}'
     required:
       - serverName
       - username
@@ -55,10 +60,14 @@ spec:
         title: Query
         description: The Query to execute against the SQL Server Database
         type: string
+        example: 'INSERT INTO accounts (username,city) VALUES (:#username,:#city)'
       databaseName:
         title: Database Name
         description: The Database Name we are pointing
         type: string
+  types:
+    out:
+      mediaType: application/json
   dependencies:
   - "camel:jackson"
   - "camel:kamelet"