cancel
Showing results for 
Search instead for 
Did you mean: 

Need to do validations for csv file (Incoming)

former_member751869
Discoverer
0 Kudos

Hello All,

How to do validations for incoming CSV file, if file header is missing or incorrect format and mandatory filed validation failed then email should send so they will resend file with correct details. ( email should be customize where it tells which field or what is the reason for failure in CPI.)


Can you help with any groovy code please.

Thanks,

Chaitanya

Accepted Solutions (0)

Answers (1)

Answers (1)

daviddasilva
Active Contributor
0 Kudos

Hi,

I don't have a way to do this with groovy script but this could easily be achieved with a message mapping step!

Just transform you CSV into an XML and then use a message mapping step to check each field for the desired inputs (or lack thereof!).

Kind regards,

David

abhinavsingh04
Explorer
0 Kudos

Hi David, could you please tell how it can be done with message mapping