[
https://issues.apache.org/jira/browse/NIFI-5914?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Pierre Villard resolved NIFI-5914.
----------------------------------
Resolution: Feedback Received
Apache NiFi 1.x is no longer maintained and no new release is planned on the
1.x release line. Marking as resolved as part of a cleanup operation. Please
open a new one with an updated description if this is still relevant for NiFi
2.x.
> JSONPathReader doesn't unescape Unicode characters
> --------------------------------------------------
>
> Key: NIFI-5914
> URL: https://issues.apache.org/jira/browse/NIFI-5914
> Project: Apache NiFi
> Issue Type: Bug
> Affects Versions: 1.7.1
> Environment: Ubuntu 16 and Postgres 9
> Reporter: eric twilegar
> Priority: Major
>
> I have a flow that use FlattenJSON that read JSON out of a file which
> converts it to new JSON in the flowfile. If UTF-8 characters are present the
> resulting json becomes something like \{"key" : "value /u00EE" } . At the end
> of the flow I use PutDBRecord with JSONPathReader to grab JSON keys and plop
> them in a db table.
> The problem is that the values in the db become the escaped unicode of the
> JSON.
> I'm working around it by extracting the JSON and running it through Nifi
> Expression Languages unescapeJSON ... I'm not sure if the real issue is that
> FlattenJSON has no option to keep encoding at UTF-8 or if its in
> JSONPathReader or in PutDBRecord even should be unescaping.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)