[NIFI-8137] Record Path functions to un/escape JSON

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.11.4
• Fix Version/s: 1.14.0
• Assignee: Chris Sampson
• Reporter: Chris Sampson
• Created: 12/Jan/21 05:28
• Updated: 08/Jun/21 13:19
• Resolved: 08/Jun/21 13:19

Description

Record Path functions to:

• unescape JSON contained within a String field and put the resulting Record fields into the data, e.g. UpdateRecord for / => unescapeJson(/stringified_json) would unescape JSON String in /stringified_json and put the resulting Object fields into the top-level of the Record
• collect one or more Record fields into an Object that is put into a single stringified JSON field, e.g. UpdateRecord for /stringified_json => escapeJson( / ) would do the reverse of the above

These would be equivalent to the existing Expression Language functions, but mean there was no need to split records into individual flowfiles, extract the field from the content into an attribute, unescape the JSON then replace the text back into the content and re-merge all the records (which is fidly and resource expensive).

Issue Links

• links to: GitHub Pull Request #4756
• links to: GitHub Pull Request #5124