[NIFI-4983] JsonTreeReader and JsonPathReader should utilize specified date/time/timestamp format when used from ValidateRecord

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Extensions
• Assignee: Derek Straka
• Reporter: Koji Kawamura
• Created: 16/Mar/18 09:42
• Updated: 15/Apr/22 08:44

Description

Similar to CSVRecordReader, JSON readers should utilize specified date format for Record validation.

JsonPathRowRecordReader.convert(final Object value, final DataType dataType) is called when coerceTypes is false. But the method currently does not convert String values for Date/Time/Timestamp field types at all. The method should try convert like CSVRecordReader does. Without doing so, ValidateRecord routes any records validated against a record schema having Date/Time/Timestamp fields to 'invalid' relationship.
https://github.com/apache/nifi/blob/master/nifi-nar-bundles/nifi-standard-services/nifi-record-serialization-services-bundle/nifi-record-serialization-services/src/main/java/org/apache/nifi/json/JsonPathRowRecordReader.java#L138

A NiFi template file to illustrate the issue is attached.

Issue Links

• contains: NIFI-4509 Validate date format in records
• is related to: NIFI-4882 CSVRecordReader should utilize specified date/time/timestamp format at its convertSimpleIfPossible method