Hello!
Can't understand whats wrong...
I've got processors group to take data from json to sql.
When I try to "view as formatted" - I see this:
Use SplitJson to split file after it use ReplaceText... and he doesn't work correctly. Unable to generate view of data: Unrecognized token 'INSERT': was expecting 'null', 'true', 'false' or NaN at [Source: (BufferedInputStream); line: 1, column: 8"
Before ReplaceText processor use EvaluateJsonPath processor to extract the json values, keep as flowfile attributes.
Add all your properties(case sensitive) in this processor and keep the destination as flowfile-attribute then feed the success relationship from EvaluateJsonpath to Replace text processor.
Flow:
---
--- other processors 3.SplitJson
5.EvaluateJsonPath 6.ReplaceText
Before ReplaceText processor use EvaluateJsonPath processor to extract the json values, keep as flowfile attributes.
Add all your properties(case sensitive) in this processor and keep the destination as flowfile-attribute then feed the success relationship from EvaluateJsonpath to Replace text processor.
Flow:
---
--- other processors 3.SplitJson
5.EvaluateJsonPath 6.ReplaceText
