[jira] [Created] (NIFI-5914) JSONPathReader doesn't unescape Unicode characters

["eric twilegar (JIRA)" <ji...@apache.org>]

eric twilegar created NIFI-5914:
-----------------------------------

             Summary: 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


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
(v7.6.3#76005)