SAP CPI - How to create one summary log file and send it to business owner

[mark_st]

Hi,

I would like to know how to approach following requirement.

Input csv file is read. Each record is validated and processed and written in one big output csv file (splitter/gather).

The validation result of each record needs to be written in one summary log file and mailed to the business owner.

How can I achieve this ? Thanks for any help or advice !

[karthikarjun]

Hi Mark - Well, you can use the mail adapter in the SAP Integration Suite to send the report via email. 

Refer: https://community.sap.com/t5/technology-blogs-by-members/sap-cloud-integration-custom-email-notifica...

Moreover, you can use the Groovy script to validate the records. 

Regards,

Karthik A

[mark_st]

Hi Karthik, the part that is unclear to me is how to build the email message containing the validation errors of all the invalid records. Each record will be validated using a groovy script between split and gather process. At the end of the complete process one summary mail needs to be send. I am new to CPI and Groovy. If I program such a logic in another tool, I write during validation process for each record the validation result in an array. At the end of the process, after processing all the record, I build the mail body based upon the array and send it out. How should I do this in CPI/Groovy ?

[NasirH]

Hello Karthik, I would advise you to write log to data store.  Then you can create a separate flow to read logs from data store and email them to business owner. Data store will allow you to keep your logs even in the case if email delivery fails. You can trigger it or manually download the log from data store at a later time.