How to implement a process to read NACHA file format in Boomi?
NACHA file is a text file with different types of records, where the Batch Header records, Detail Records and Addenda records will be occurring multiple times (unbounded loop) sporadically in one document. In our requirement, we need to read the NACHA file according to the record type, sum up the amounts in the detail record of one batch, compare this sum with the Amount mentioned in the addenda record, then read and do the same to all the batches in the document. Finally translate it into XML format.
My question to this forum is, Is there a way we can create a custom profile (Flatfile) to handle the loops to read the NACHA file? Is there anyone using NACHA files in Boomi process? If yes, please let me know and help.