I have used AttributeToJSON to generate this JSON:
{"sourcing.SHA256":"d46884d5b9f2617a9f16e7a4e8b056036f07cb02cb85953c5065dd55ff8e3c33","sourcing.MD5":"dd74cb837e5e701cdfa1fa070703be48","filename":"PLACES_ABC.csv","sourcing.sourceSHA256":"e3daeb8cfd6db4aad20bb42900bc5fa4815eba7e55d97cb01a1a9674668f20b2","triage.datatype":"mdb","triage.mdb.version":"JET4","triage.mdb.tables":"PLACES::-::ACCOUNTS::-::VEHICLES","sourcing.sourceMD5":"a18eed985ddb04cbe13b487062628585","triage.mdb.table.rowcount":"9982","triage.mdb.table":"PLACES","triage.mdb.table.header":"FIELDA,FIELDB,FIELDC","triage.mdb.table.database":"ABC.mdb"}
I try to employ a FlattenJSON to (un)flatten my JSON. It is configured like
so:
Separator .
F M dot notation
IRC false
RT unflatten
CS UTF-8
PPJ false
This error below results. Why? How can I get past this problem?
19:54:40 UTC
ERROR
4d6c3f2a-a72e-16b2-68ac-c90d5c31498d
FlattenJson[id=4d6c3f2a-a72e-16b2-68ac-c90d5c31498d] Failed to
unflatten JSON: java.lang.ClassCastException: class
com.fasterxml.jackson.databind.node.TextNode cannot be cast to class
com.fasterxml.jackson.databind.node.ObjectNode
(com.fasterxml.jackson.databind.node.TextNode and
com.fasterxml.jackson.databind.node.ObjectNode are in unnamed module
of loader org.apache.nifi.nar.NarClassLoader @2679311f)