Created 04-21-2022 02:46 PM
@J0sh ,
If you use a ReplaceText with the following settings it will clean up the garbage in your flowfiles:
Search Value: (?s)(^|(\})<br>).*?(\n).*?(<br>(\{)|$)
Replacement Value: $2$3$5
This file, though, has not 1 JSON, but 8 different JSON fragments. So the resulting flowfile will still have 8 lines, each with a valid JSON. You must use a SplitText process to separate those into 8 different flowfiles before applying the EvaluateJSONPath.
Cheers,
André