[jira] (NIFI-5901) Write JSON record in database

["Luigi De Giovanni (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/NIFI-5901 ]


    Luigi De Giovanni deleted comment on NIFI-5901:
    -----------------------------------------

was (Author: JIRAUSER298268):
It would be great to know at least a workaround for this case, if this feature is not being implemented.
JOLT transformations don't seem to work, handling the JSON as string, as all the field names lose the double quotes.

> Write JSON record in database
> -----------------------------
>
>                 Key: NIFI-5901
>                 URL: https://issues.apache.org/jira/browse/NIFI-5901
>             Project: Apache NiFi
>          Issue Type: Improvement
>    Affects Versions: 1.8.0
>            Reporter: Flo Rance
>            Assignee: Mike Thomsen
>            Priority: Minor
>          Time Spent: 3h 50m
>  Remaining Estimate: 0h
>
> It would be good to be able to store a whole json record in databases that implement it (e.g. postgresql). This would require to define the field in the shema as json/jsonb and then let PutDatabaseRecord inserts the json value in the json/jsonb field.
> At the moment, it's possible to store a json/jsonb through Postgresql JDBC using the Java sql type 'OTHER':
> Object data = "\{...}"; // the JSON document
> PreparedStatement.setObject(1, data, java.sql.Types.OTHER);



--
This message was sent by Atlassian Jira
(v8.20.10#820010)