I am currently using SplitJSON to split incoming JSON into multiple records based on JSON path $.*. Further, I was able to aggregate all the splits into 1 single file with MergeContent. However, now when I am trying to aggregate split files into multiple chunks of 1 MB each, its not working as expected. I have followed some of the other artiles on the same use case, but most of them seems to use 'Minimum Number of Entries' for merging based on records than file size. Below is the MergeContent processor and respective properties. Any quick help or insight is highly appreciated. Thank you. ... View more

Hello there, Is there a simpler and dynamic way to replace JSON values dynamically than ReplaceText. Currently, below is my JSON and respective ReplaceText properties (PFA). { "orgId": "" "sourceId": "123" "eventDate", "31-12-2016", "eventDetail": "Transaction complete." "ingestionDate": "", } I have to add today's date dynamically to ingestionDate below, which I am somehow being able to achieve with ReplaceText, however I believe its at best fragile since it appends it at the end of the JSON. Search Value - (?s:(^.*)}$) Replacement Value - $1,"ingestionDate":"${ingestionDate}"} However, what if I needed to dynamically assign more values for various other attributes for a complex JSON (I do have another use case for that), and so I need a way to be able to refer to the incoming flow-file JSON attribute via regex (like ingestionDate) and update its value to current date more generically rather than manipulating it as a text. Is there a better way out? Please advice. Thank you and Happy New Year to all! replacetext.pngreplacetext.png ... View more

I have been struggling with ListSFTP and FetchSFTP (PFA) as none of them seem to be working and ending up with error below - java.io.FileNotFoundException: Could not perform listing on /home/temp/ because could not find the file on the remote server ListSFTP FetchSFTP ... View more