I am working on a requirement to load a JSON file into a Database. Before doing the ingestion, I have to validate the Json response against the schema. I read about Validate Record Processor, but that does not fit in my requirement because I want the error records in a flow file. With Validate Record Processor, the error records are moved to logs. I am trying to use RouteOnAttribute Processor and use an expression language to validate Date Columns in Particular.
Any Suggestions? Can we achieve this using EL?